I have an action to set values in three fields when the user clicks it. Two fields work, simply setting one field as “Yes” and one with “TODAY()”.
I have a USERS table with USER_ID and USER_EMAIL. I want to compare the logged in user’s email, USEREMAIL() to the matching/ referenced USER_EMAIL in the USERS table and pull out the USER_ID to put that value in the 3rd field.
I just can’t get it to work even after researching dereferencing, LookUP() and more.
This is my latest attempt for the action setting the value:
These are the relevant fields in my main table, the ones I want to set with the action.
Could it be because I’m trying to set the value of field with a REF field type? If so, if I change it to text, how can I access that related record email in other parts of the app?
Thanks in advance for helping me through this MAJOR BLOCK.