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

[Ellen_Sligh]

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

[Bellave_Jayaram]

Make a slice with [_RowNumber]=2

[Gil_Littman_App]

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]

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

[Gil_Littman_App]

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]

Found it!! THANKS

[Gil_Littman_App]

You’re welcome