How can I remove the add new choice on a conditional drop-down?

Question

I have a conditional dropdown in my Projects Table called Related Tactic. The condition is set up to pull related tactics from a Related Initiative. I want to remove the Add new option from both of those fields as initiatives and tactics are not to be added from the Project Table. Is there a way to do this? I can't turn off "Add" permissions as they still need to be able to add new records - I just don't want them to add new initiatives or tactics from these two dropdowns.

markshnier__you · Answer

If you set the Role User Interface to hide the Add Button then I believe that suppresses the Add button on the drop down menu

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------

jasonjohnson · Answer

You could create a table for each list then don't allow the users the ability to add to those tables. I have an Issue Log table with an Issue Type selection from an Issue Type table then a sub table under that for the selection of an Issue Category. None of my users can add types or categories to the management approved list but can create issues and assign the types and categories.

kevinrybicki · Answer

I am also having this issue.On the Quick Base side, it should be a quick/easy feature to implement. Hacking a solution with multiple tables and subtables seems foolish.

Within the first week of introducing our application to new users, one of the first things they were confused about was seeing the <Add a new....> item in the dropdown menu. Wanting to control how and where a user creates a new record seems like a pretty common use case.

_anomdiebolt_ · Answer

This is trivial to fix this with script (essentially one line of code). However, I don't have time to create a demo as I am headed to a weekend conference. If you need individual help with this issue feel free to contact me off-world using the information in my profile:

https://getsatisfaction.com/people/dandiebolt

jasonjohnson · Answer

It's not really 'hacking' a solution. We have some selections that management wants to control and it allows the control in addition it allows management to make changes to a table without going through editing a field. A very clean option to use sub tables and many vendors will use. Back in my MS Access days I used the same method for a few databases and it was great then as well.

Forum Discussion

How can I remove the add new choice on a conditional drop-down?

Related Content

Conditional Drop down

Conditional Drop-down

Conditional & Cascading Drop Downs

Conditional Drop Down of Child Records based on Dates

Options in a drop down