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

Ellen_Sligh
Participant II

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

0 6 473
6 REPLIES 6

Make a slice with [_RowNumber]=2

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
Participant II

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

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
Participant II

Found it!! THANKS

Youโ€™re welcome

Top Labels in this Space