How to make it so that new entries cannot be created


I have 2 table (and “ref” field - on photo), How can I make it impossible to create new fields in “ref” type field?

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

3 Likes

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.

1 Like

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.

2 Likes

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

1 Like

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

1 Like