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

  • 0
  • 2
  • Question
  • Updated 4 months ago
  • In Progress
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.
Photo of Dawn Rene

Dawn Rene

  • 100 Points 100 badge 2x thumb

Posted 4 months ago

  • 0
  • 2
Photo of Jason

Jason

  • 1,022 Points 1k badge 2x thumb
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.

Photo of Kevin Rybicki

Kevin Rybicki

  • 62 Points
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.
Photo of Jason

Jason

  • 1,022 Points 1k badge 2x thumb
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.
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 27,694 Points 20k badge 2x thumb
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