I am learning AppSheet, so forgive the fairly simple question…
I’ve built a few apps for my office, mostly centering around work requests. In my data structure, I often have a column for [Email Address] of the user who submits some request. In another column, I often use a [Processed By] header (by the way, isnt shown in the original form, and is included in a slice with its own view), which is meant to also display an email address (that of the person who completed the work, etc.)
If I use the formula, “=USEREMAIL()” for both [Email Address] and [Processed By], I obviously don’t see two unique email addresses.
As a work-around, I’ve been making the users type in their email address, and I’ve reserved “=USEREMAIL()” for the workers who complete requests.
I know I can do better than this. The beauty of using AppSheet is that it knows the email address of the person filling out the form.
My expression building stinks, there’s probably something easy here.
Anyone have a suggestion?