Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

InputBox - Predefined Values with Commas

Hi Everyone,

So I created an InputBox and chose to have predefined values with a drop down - it worked perfectly except a few of the values in Categories have commas in them so the drop down is separating them.

Any ideas?

Thanks,

J

Expression: 

=concat(distinct Categories,',')

Categories:

"Shirts", "Pants, short", "Pants, long"

What I'm getting in the drop-down:

Shirts, Pants, short, long

1 Reply
SergeyMak
Partner Ambassador
Partner Ambassador

Hi

Try to use other symbol in the Concact

OR replace ", with . like (=concat(distinct REPLACE(Categories,'",','".'),'.'))

Regards,
Sergey