I would generally aim to use a formula for this, though depending on how complicated the logic is, that may become very frustrating to maintain over time. Using good formatting/indentation in your formula can help with that.
Let’s suppose you have the following possible values in your multiselect:
“Apple”
“Banana”
“Caramel”
That means there are 8 possible combinations:
- A
- B
- C
- AB
- AC
- BC
- ABC
- Nothing
We could build a formula like this:
IF(FIND("Apple",{Subcategory}),
IF(FIND("Banana",{Subcategory}),
IF(FIND("Caramel",{Subcategory}),
"Caramel Apple Banana Split",
"Banana Apple Twist"
),
IF(FIND("Caramel",{Subcategory}),
"Caramel Apple",
"Plain Old Apple"
)
),
IF(FIND("Banana",{Subcategory}),
IF(FIND("Caramel",{Subcategory}),
"Banana with Caramel",
"Banana Only"
),
IF(FIND("Caramel",{Subcategory}),
"Caramel Only",
"NOTHING AT ALL"
)
)
)
Wow, that’s a lot of Nested If functions!
The benefit to using a formula is that the table will automatically recalculate the formula field values in more or less real-time as the Subcategory field is edited for a given record.
That said, a Script can certainly do this to and you can even trigger your script to run any time a record is updated. BUT, scripts tend to execute after a bit of a delay so it won’t feel as snappy.
