Enable users to choose whether or not to use conditional dropdown logic

  • 0
  • 1
  • Question
  • Updated 4 months ago
  • Answered
A multiple choice reference field called "Contact" on one of my tables is set up as a conditional dropdown field. 90% of the time this works great for our purposes. Sometimes however, users would like to select a contact that isn't covered by the conditional dropdown logic. Is there a way for those users to manually activate an option or something to ignore the conditional dropdown logic at need?
Photo of Alex Gale

Alex Gale

  • 1,430 Points 1k badge 2x thumb

Posted 4 months ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 69,572 Points 50k badge 2x thumb
The solution is to make a total of three relationship.  You already have one of them.
Make a new relationships and for this one do not make it a Conditional Drop Down.

Then make a new calculated reference field such as [Related Parent (final)]

if([CDD related parent] >0, [CDD related parent], [non CDD related parent])

Then make a relationships on that field and get all your lookup fields from that relationship.

That will mean looking for the usage of the existing lookups and replacing their usage with the new lookups.  Then deleting them. 


Photo of Alex Gale

Alex Gale

  • 1,430 Points 1k badge 2x thumb
That makes sense, thank you