Is it possible with AppSheet?

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 Solved
0 2 102
1 ACCEPTED 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

View solution in original post

2 REPLIES 2

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

Top Labels in this Space