I don't want to allow users to add lines to a dropdownlist (ref column) in a form

AppSheet AppSheet Q&A
1

I have a form with a dropdown list wich refers to a table with names.

I don’t want the user of the form to add new names to the list. I wan’t them to just choose from the list. In the column setting there isn’t something like: “Allow adding new values”

How do I prohibbit users from adding new values?

2

Please add a valid_if expression to that reference column something like

Names_Table[Key_Column]

Where “Names_Table” is the referenced table that contains list of names and [Key_Column] is the key column of that table.

Drop-down on a Ref column - AppSheet Help

2 Likes
3

Alternatively you could also define users that can R/W on the table, if theirs only a small pool of Admins etc

Then Admin still have the convenience to add users from the front end. Well general users can only select the available options.

2 Likes