Skip to main content
Question

I am trying to create a formula for a Multi-select Text Field

I have a question with a two part answer and want to give partial credit, how do I go about creating this formula? 
    This topic has been closed for replies.

    Your description doesn't give much detail - so I apologize if I'm misunderstanding the intent, but are you asking about a formula to parse the results of a multi-select field?

    If yes - you have to use a Part() function to split out the various response like so

    //Convert your multi-select value to a true text value
    var text multi = ToText([Multi]);

    //break out each response into each 'part'
    var text selectionOne = Part($multi,1,";");
    var text selectionTwo = Part($multi,2,";");
    var text selectionThee = Part($multi,3,";");

    "This is one! " & $selectionOne
    ...

    Chayce Duncan | Technical Lead
    (720) 739-1406 | chayceduncan@quandarycg.com
    Quandary Knowledge Base
    Terms & ConditionsAccessibility statement