How to make it so that new entries cannot be created

Screenshot 2022-06-23 163421.png I have 2 table (and "ref" field - on photo), How can I make it impossible to create new fields in "ref" type field?

Solved Solved
0 7 134
1 ACCEPTED SOLUTION

One approach is to change the column to Type Enum with Base type Ref. Compare the following.

dbaum_1-1656100794364.png

dbaum_0-1656100707586.png

 

View solution in original post

7 REPLIES 7

In the column's Valid If property, enter an expression whose result is a list of the values you want to be available. See Drop-down on a Ref column - AppSheet Help 

And what is the condition for the "New" field?

I don't understand what specifically you're asking. Maybe post a screenshot of your column's properties.

Rectangle 1.png

I showed you in the screenshot, I want to block the ability to add new rows by the ref field. 

In simple words, I want to make... smth like...  the field "enum" from the field "ref"

One approach is to change the column to Type Enum with Base type Ref. Compare the following.

dbaum_1-1656100794364.png

dbaum_0-1656100707586.png

 

Yes, that's exactly what I needed, thank you so much, good luck and have a nice day

I believe it would be necessary either for the referenced table to disallow adds, or to reference a read-only slice. 

Top Labels in this Space