So, I asked this question:
When the user clicks Add Job I save a bunch of details in the JobDetail table. One of the items I want to save is “JobAddedBy” currently it’s set to Current User. I was hoping it saves the current user’s email. However it doesn’t. When I try to use dynamic filed and say Current User’s Email… it expects further statement.
Whilst on the same page, I can display (only in test mode) the Current User’s email - I can add that to the DB… am I missing something basic here?
The reason I want to save the user’s email is, so if I ever want to delete the whole user or run some queries / build features, I want to have the email id of the current user to query on in the JobDetails table.
Here’s Emmanuel’s reply:
it’s because JobAddBy is of type user, while an email is a text. if you want to save the email, which i don’t recomment, you should use the user, make it a text.