How to turn a csv list into choice component options?

Ask for Help
1

Is there a way to turn a comma separated list of items into a set of choices for the choice component (the chips/tags)
Typically your choices would be in separate rows within a column, my choices are in a single cell in csv format.

2

Yes you could do that with a helper table.

  • create New table

  • Add an Index Column where you hard code the values E.g 0,1,2,3,4,5

  • Add a Single Value Column and target your comma separated list of choices

  • Add a Split Text Column and target your new Single Value.

  • Add another Single Value Column and target your Split Text Column where the From Start → Row is your Index Column

Just remember to start your Index Column with 0. Because the first position in an array is actually 0.

2 Likes
3

Thanks for that, i’ll try this now👍

4

Sounds good :+1:

Actually reading a little closer what you wana do is in your helper table use a single value column to grab your comma separated list and then use a split text column which targets the single value. I updated the original post.

2 Likes
5

Works great, thanks for that.

1 Like
6

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.