Adding new value to sheet while entering another form - Hide

Hi,

I’d like to hide the “New” function here in this form:

I tried adding a condition to “Add” for that specific table at behaviours:

NOT(CONTEXT(“VIEWTYPE”)=“Form”)
CONTEXT(“VIEWTYPE”)=“Detail”
CONTEXT(“VIEW”)=“Verpakking”

All three sollutions do not result in what I need.

So I’m not sure on how to make this happen. Does anyone have experience with this?

Change the column definition from Ref to Enum/Ref…AND place an expression in the Valid_If to select the desired list of items. These two things will give you a dropdown list that uses the Ref functionality but will not allow adding new rows to the referenced table.

Sample column definition - note valid_if expression

Result of the dropdown

2 Likes

Thank you! :d

1 Like