Discussions

 View Only
  • 1.  Multi Select List Formula

    Posted 09-29-2020 16:57
    I can't seem to remember or find the correct syntax to make a multi-select formula field. My goal is to make a formula field, and then use a dynamic rule to fill choices in a multi select text box. I've done it before but can't find it in my own app lol. I need to add it to my tips table...

    ------------------------------
    Mike Tamoush
    ------------------------------


  • 2.  RE: Multi Select List Formula

    Posted 09-29-2020 17:05
    Split function!

    In case anyone stumbles upon this, its simply using Split("text1;text2;text3")

    ------------------------------
    Mike Tamoush
    ------------------------------



  • 3.  RE: Multi Select List Formula

    Posted 09-29-2020 18:20
    Also, I believe that when you have a muti-select formula fields, the Dynamic Filers are really smart as they allow the individual choices to be filtered as opposed to every unique combination.

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------