I’ve been using Appsheet for a month now so am still a noob. It’s been going quite well for the most part. One issue that has me stumped is how to present an Enum list to the user based on their user role.
Here’s a screenshot of the field setup. Basically I only want an Admin user to be able to select the last two options. I don’t mind if they are visible and unavailable to other users or if they are invisible to other users.
I tried using the Valid If field setting but then other users get an error message if it is set to one of the two Admin-only values.
I would also like the field not to be editable by non-Admin users if it is set to one of the last two values. Any pointers would be much appreciated.