How can I limit a column to one input - one r...

(Ellen Sligh) #1

How can I limit a column to one input - one row and any other additional input would be invalid?

(Bellave Jayaram) #2

Make a slice with [_RowNumber]=2

(Gil Littman [AppSheet]) #3

In your column settings, click on the flask in the “Are updates allowed?” field. Now you can use formulas to determine when is adding allowed.

(Ellen Sligh) #4

I understood the slice, but Gil I’m not sure where you are referring to.

(Gil Littman [AppSheet]) #5

A slice as Bellave suggested will help you show only the first row, if that’s what you’re looking for you should do it, because it’s simple.

However, if you want to prevent users from adding new rows, go to your column definitions (Data -> Tables) and find the field “Are updates allowed?”. The buttons in this field determine which changes are allowed. If you click the flask icon, you’ll be able to use a formula instead of the static buttons, for example: IF(ISNOTBLANK(your_table_name[table_key]), “ALL_CHANGES”,“UPDATES_AND_DELETES”)

(Ellen Sligh) #6

Found it!! THANKS

(Gil Littman [AppSheet]) #7

You’re welcome