Forum Discussion

MikeTamoush's avatar
MikeTamoush
Qrew Commander
3 years ago

Possible to add an 'Other' Option to a conditional dropdown?

I know this isn't a native capability, but sometimes we can trick QuickBase into certain things. I was trying to come up with a slick way to use formula fields so that I can add an 'other' option to my conditional dropdown.

For example, if I had US States as my first selection, then cities as my second, could 'Other' be listed with the cities?

------------------------------
Mike Tamoush
------------------------------
  • You would have to add 50 more cities called Other. One for each state.

    You were down to just the sort on the report used to drive the drop-down list to base it on a formula field that makes sure that the city called Other  sorts last.

    ------------------------------
    Mark Shnier (YQC)
    mark.shnier@gmail.com
    ------------------------------
    • MikeTamoush's avatar
      MikeTamoush
      Qrew Commander
      Yes I was afraid that was the only way. I hoped you had come up with some super sneaky creative work around :)

      ------------------------------
      Mike Tamoush
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        I think it would be a pretty easy excel import to create the 50 records.

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