I am having a hard time setting Editable_If permissions based on user role in my app. Hopefully someone can lead me to the correct formula.
I am making a real estate app and I am trying to restrict an Edit behavior only to admin AND the user that published the property listing in the app. I think my issue stems from the "Listing Agent" label in the property profile is a REF_Row to my Agents table where the agent's name, email, etc is listed.
Using the expression =IN(USEREMAIL(), SELECT(Agents[Email], [role]="Admin")) allowed me to only have admins edit the property listings, but I am missing the ability to have the user who is the "Listing Agent" also be able to edit their property post.
Any suggestions?
User | Count |
---|---|
19 | |
10 | |
7 | |
5 | |
5 |