Forum Discussion

Qrew Cadet

3 years ago

Pipelines - Addressing a Multi-Select option containing commas

Setup I have an application with two tables (really more than two but the issue is surrounding two specific tables), and each of those tables contains a multi-select field with the same options. I...

Pipelines

PrashantMaheshw

Qrew Captain

3 years ago

HI Michael,

You can try the following formula , assuming your field name is Comment

Create a Multi Select Formula

var text a=Part(var text b=Part(var text c=Part(

Split(List(" ; ",$a,$b,$c))

Don't worry about a messy formula , multi select can display upto 20 options max , so fire away as many parts you need

------------------------------
Prashant Maheshwari
------------------------------