How can I limit a column to one input - one row and any other additional input would be invalid?
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.
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โ)
Found it!! THANKS
Youโre welcome
User | Count |
---|---|
41 | |
36 | |
30 | |
23 | |
16 |