Calculated field that shows multiple values from checkbox field | Community
Skip to main content
Kiesner10
Kiesner10
Level 2
February 21, 2023
Solved

Calculated field that shows multiple values from checkbox field

  • February 21, 2023
  • 1 reply
  • 874 views

Is there a way to set up a calculated field that would return multiple values (separated by a comma) from a multi-select checkbox field?

 

In our current state, we have a radio button field with various locations listed. Each location has a unique location ID. Whenever someone submits a request through the form, the calculated field provides the location ID based on the location that is selected. We would like to allow someone who submits a request to select more than just one location (via multi-select checkbox), but I'm struggling with attempting to separate out the values (locations IDs) that are returned.

 

Any help would be appreciated!

 

An example of the current set-up (which provides one output based on location selection):

IF({DE:Location Name}="Location 1","12345",IF({DE:Location Name}="Location 2","23456",IF({DE:Location Name}="Location 3","34567")))
 
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Doug_Den_Hoed_AtAppStore

 

Hi Jack,

 

I replied to this similar thread with a screenshot showing a formula you could use to create such a comma delimited (where I used the | symbol) in consistent order (meaning you can also group by and chart the various combinations "sensibly").

 

Regards,

Doug

1 reply

Doug_Den_Hoed_AtAppStore
Community Advisor
Doug_Den_Hoed_AtAppStoreCommunity AdvisorAccepted solution
Community Advisor
February 21, 2023

 

Hi Jack,

 

I replied to this similar thread with a screenshot showing a formula you could use to create such a comma delimited (where I used the | symbol) in consistent order (meaning you can also group by and chart the various combinations "sensibly").

 

Regards,

Doug

    Kiesner10
    Kiesner10Author
    Level 2
    February 22, 2023

    Thank you for your help @doug_den_hoed__atappstore! The formula recommended allowed me to separate out the values from a multi-select checkbox field. I really appreciate it!

     

    I used the following example you provided in your other post below and tailored it to my scenario.

    CONCAT(IF(CONTAINS("Swimlane Portfolio",{DE:AtApp Swimlane Tag}),"Portfolio | ",""),IF(CONTAINS("Swimlane Program",{DE:AtApp Swimlane Tag}),"Program | ",""),IF(CONTAINS("Swimlane Project Owner",{DE:AtApp Swimlane Tag}),"Project Owner | ",""),IF(CONTAINS("Swimlane Project",REPLACE({DE:AtApp Swimlane Tag},"Swimlane Project Owner","SwimlaneProjectOwner")),"Project | ",""))

     

      Terms & ConditionsAccessibility statement

      Loading footer...