how can i import a multi-select value?
# administrationk
KnotKnick
02/26/2020, 9:56 PMhow can i import a multi-select value?
g
Gregory Jones
02/26/2020, 10:00 PMImport to a record that has multiple values selected?
k
KnotKnick
02/26/2020, 10:05 PMa csv import to a custom record that has multiple-select field
g
Gregory Jones
02/26/2020, 10:07 PMgotcha - values need to be separated by a pipe character in the csv
Gregory Jones
02/26/2020, 10:08 PMthere is also an option you can set during the import to change to a different character under advanced options
Gregory Jones
02/26/2020, 10:08 PMmessage has been deleted
k
KnotKnick
02/27/2020, 1:55 PMcan comma work?
g
Gregory Jones
02/27/2020, 2:51 PMHaven't tried that.
Gregory Jones
02/27/2020, 2:51 PMnot sure if that would mess it up since it will be in a CSV to begin with
k
KnotKnick
02/27/2020, 3:15 PMright now, i’m running into the issue where when i export the data, my multi-select fields’ values are truncated… is there a way to get everything?
g
Gregory Jones
02/27/2020, 3:25 PMYou could try a Formula (Text) and put the field name in as the formula.
Gregory Jones
02/27/2020, 3:26 PMI'm guessing this field of yours has instances where there are a lot of different selections for one record?
k
KnotKnick
02/27/2020, 3:46 PMyes, there are lot of items in the multi-select field
n
Nicolas Bean
03/08/2020, 3:18 PMthe comma works, just change the pipe delimiter to a comma in the CSV advanced options
2 Views