Changing the dropdown menu to match cell content

Tags: #<Tag:0x00007efc647a55f0>
#1

Have a CSV file with 2 columns (name, preferred colours)
Alice,“blue, purple”
Bill, “red,green”
John,blue

When I load the data into a table the dropdown menu of the “preferred colours” column allows me to select only from the following options :

  • blue, purple
  • red,green
  • blue
    Is there a way to customize the options of the dropdown menu of the column to get
  • blue
    -purple
    -red
    -green

Instead ?

Thanks in advance for your feedback.
Vincent
PS: I use pure javascript

#2

Hey Vincent.

The set of option for a dropdown menu is set in the ‘source’ of a cell. Example https://jsfiddle.net/AMBudnik/jdfz3ry2/

But then you will be able to choose only once value from the dropdown (we do not have a cell that supports multiple choice).

#3

Dear Aleksandra,
Thank you so much for your quick response.
Have a nice day.
Vincent

#4

Have a nice day.

Same for you. Stay safe.

#5