I have an app where users can submit test courses to be reviewed. The tests have their own form along with a form for adding test questions.
There is a Users table with fields:
User (key), Email
ex: John Smith , email@example.com
A RequestForm table with fields:
RequestFormID (key), Requestor (a ref to Users)
ex: ABC123, John Smith
A RequestQuestions table with fields:
ex: JHN567, ABC123
So a User creates a RequestForm and appends its RequestQuestions. How can I setup the behavior of the edit button (on the RequestQuestions table) so that only Requestors can edit the Questions they made via their USEREMAIL()?
I’ve got it working with at the RequestForm level with this formula, but I can’t get it working at the question level:
IN( [Requestor], SELECT(Users[User],([Email] = USEREMAIL())))