I Have one varible which is select box having 28 choices but now user want it multi select.which is

[sonimore101]

I Have one variable which is select box having 28 choices but now user want it multi select. What is best approach to implement this without creating custom table.

[Ankur Bawiskar · Accepted solution]

@sonimore101 

Easy approach if customer is ok

-> create custom table and have 1 field which is name

-> create 28 records into that table and each record with that choice label as Name

-> create list collector variable pointing to this custom table and user can select multiple values

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏

[Ankur Bawiskar]

@sonimore101 

any help required for the above comment?

[Chetna_Aggarwal]

Hello @sonimore101 ,

Since the requirement has changed from a single-select to a multi-select, there isn't an OOTB way to convert a Select Box variable directly.

Instead of creating a custom table, I'd recommend creating a reference field on an existing table (if a suitable one already exists) and using a List Collector variable. This is a scalable and maintainable approach, especially if the list of values may change in the future.

While you could consider using sys_choice (for table field choices) or question_choice (for catalog variable choices), these tables are not intended to be used as business reference data sources. A proper reference table or an existing table is a cleaner design and makes reporting and maintenance much easier.

If no suitable existing table is available, then creating a small lookup table and using a List Collector would be the recommended OOTB solution.

Regards

Chetna

[sonimore101]

Hello @Chetna_Aggarwal 

We don't want to create a new table. Can we instead create 28 checkboxes so users can select multiple options?