Discussions

 View Only
Expand all | Collapse all

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

  • 1.  Enable users to choose whether or not to use conditional dropdown logic

    Posted 02-22-2019 20:47
    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?


  • 2.  RE: Enable users to choose whether or not to use conditional dropdown logic

    Posted 02-22-2019 22:42
    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. 




  • 3.  RE: Enable users to choose whether or not to use conditional dropdown logic

    Posted 02-25-2019 16:31
    That makes sense, thank you