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?
Forum Discussion
1 Reply
- 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
