Discussions

 View Only
  • 1.  How can I remove the add new choice on a conditional drop-down?

    Posted 08-07-2018 13:38
    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.


  • 2.  RE: How can I remove the add new choice on a conditional drop-down?

    Posted 08-07-2018 21:12
    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.



  • 3.  RE: How can I remove the add new choice on a conditional drop-down?

    Posted 08-24-2018 13:33
    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.


  • 4.  RE: How can I remove the add new choice on a conditional drop-down?

    Posted 08-24-2018 13:55
    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.


  • 5.  RE: How can I remove the add new choice on a conditional drop-down?

    Posted 08-24-2018 13:49
    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




  • 6.  RE: How can I remove the add new choice on a conditional drop-down?

    Posted 09-26-2021 13:59
    Anyone know a solution that does not require a Code Page?

    ------------------------------
    Don Larson
    ------------------------------



  • 7.  RE: How can I remove the add new choice on a conditional drop-down?

    Posted 09-26-2021 16:21
    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
    ------------------------------



  • 8.  RE: How can I remove the add new choice on a conditional drop-down?

    Posted 09-26-2021 19:51
    You nailed it.

    ------------------------------
    Don Larson
    ------------------------------