So in my app I want my users to have the ability to task one another. I have a “To” reference to the users table, and then I have a “From” reference. How can I make it so the “From” is automatically filled in with the information of the current user so I don’t have the issue of users pretending to be each other when sending tasks?
Put USEREMAIL() in the app formula for “From”.
Using App formula would recalculate the column value each time the row is modified, potentially changing to a different user. Instead, I suggest using USEREMAIL() as suggested, but in the Initial value expression. Also set the Editable? property to the expression,
FALSE, to prevent the user from changing it.