Forum Discussion

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

Conditional-Dropdown

Relationships

MarkShnier__You

Qrew Legend

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

Qrew Commander

3 years ago

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
Qrew Legend
3 years ago
I think it would be a pretty easy excel import to create the 50 records.

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
- MikeTamoush
  Qrew Commander
  3 years ago
  Well, my example was with states, but my use case has about 300 records that would need to be created. Of course, not too hard to make the 300 records so it is possible, but then I would also need a pipeline to create the other record when new records are created.
  
  All of it is not too bad of a solution, but the necessity is minimal and probably doesn't warrant it. I'll add it to the 'maybe ill do this later' list.
  
  ------------------------------
  Mike Tamoush
  ------------------------------