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

Question

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
------------------------------

MarkShnierYou · Answer

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
------------------------------

Sign up

Login to the community