How do I or can I remove the “New” Option from a Lookup column.
Enum columns have the options to “Allow other values” But a Lookup Column does not.
The columns have to be editable because they are being copied to a New table for historical purposes. I’ve created a slice but that didn’t seem to work because it broke the Bot which does the copying due to one field being not editable.
Unless I am doing something wrong, which is very likely.
Does this mean a Ref type column?
If it is a Ref type column, and you are NOT interested in/not using the [Related …] column that is automatically created in that referenced Table, then you can switch the column to an Enum with a base type of Ref - i.e. Enum/Ref. See image and take not of all circled areas.
IF you DO need the [Related …] column that is generated in the referenced table, there is still a way to do it…just slightly odd. You can temporarily disable the Add capability on that form by changing the Table properties on referenced table See images below.
Tap the Table Properties button
Tap the Expression Assistant button
Delete the default expression and replace with one similar to the below - Assumes you DO NOT already have other permissions implemented
The result is New button is removed on drop down - NOTE this will also impact any other Add capabilites you have on the Form for the referenced table
I hope this helps!
The First Option worked…(So Far).
Thank you.
