Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Combining several Multiple Select fields into a new field

Topic Labels: Automations Formulas
Solved
Jump to Solution
4934 11
cancel
Showing results for 
Search instead for 
Did you mean: 
jaybushman
6 - Interface Innovator
6 - Interface Innovator

Hello. I'm struggling to find a way to combine the contents of several Multiple Select field into a new field, while retaining the value and color for each entry. Here's a stripped down version of what I'm trying to do: 

jaybushman_0-1679813054400.png

I've got 4 separate multiple select field, each with their own set of options. The field called "Combined Types (Manual)" shows what I want the output to be. How can I aggregate all that data while retaining the color coding for each one? Thanks a lot. 

 

11 Replies 11

Whilst not understanding your base schema/structure - yes, what you've posted in your screenshot is achievable with either the Script App or an Automation script.

LeandroHBayer
5 - Automation Enthusiast
5 - Automation Enthusiast

Thanks for your response Karlstens and sorry if I wasn't clear enough.

Basically I need to concatenate the data in the 3 columns in the order and lines as I have in the mockup. Is that possible? I tried modifying your code but didn't work.

Thanks,

L