Adding new value to sheet while entering another form - Hide

[Djigi]

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?

[WillowMobileSys · Accepted solution]

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

Sampl column definition

Result of the dropdown

[Djigi]

Thank you! :d