Hi,
I just wanna know whether it is possible with AppSheet. I have a column in my data table where I’d like to let all users put different values but the only one user can put the only one specific value. I am trying to achieve that but no results.
For example:
Column [A] has Enum values like “X”,“Y”,“Z” and “XYZ”. I wanna make that everyone can choose one of “X”,“Y” or “Z” but the only one user can choose “XYZ”.
Thanks everyone in advance!
Solved! Go to Solution.
Maybe this as valid_if of the column
IF( USEREMAIL()= user1@testingemailexampletest.com , LIST(“XYZ”),
LIST(“X”, “Y” , “Z”)
)
Edit: Please ensure that the Enum options in the column setting are not there and enum options are presented through the valid_if list only
Maybe this as valid_if of the column
IF( USEREMAIL()= user1@testingemailexampletest.com , LIST(“XYZ”),
LIST(“X”, “Y” , “Z”)
)
Edit: Please ensure that the Enum options in the column setting are not there and enum options are presented through the valid_if list only
Hm, I will try and if that’s the answer I wish the ground would swallow me up… Let you know in few minutes. Thanks a lot!
Jesus it works! So easy solution that I cannot even believe that. Thanks AppSheet for this community. Thanks @Suvrutt_Gurjar for help. It is done
User | Count |
---|---|
43 | |
30 | |
26 | |
14 | |
14 |