0

Importing data into a multi choice field

In the sample for the Intermediate training the field for State is a Choice field.  But when you import the table the State is empty?

What step did I miss?

3replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
    • Sean
    • Sean
    • 2 yrs ago
    • Reported - view

    Hi Keith,

    The values in Choice and Multiple Choice fields can“t be added or removed by import or code. These fields can only be modified that way through the Edit fields... UI. You can update the values using code or during import once the fields have been created and populated.

     

    The other option is to use a Reference field which will popup a table with your imported data. This option lets you add, modify and remove items from the list.

    Like
    • steph
    • steph.1
    • 2 yrs ago
    • Reported - view

    there is no option for reference field upon import? 

    I am in the same boat. I tried importing as “text” and converting the field to a choice field, but no way to change the field type once it is established. I tried to change field type using “edit fields” is there a simple way to do this?

    Like
    • Sean
    • Sean
    • 2 yrs ago
    • Reported - view

    Simple is relative 😉. You can“t ”convert“ a field, but you can copy the value of one field type to another field type and then delete the original field if you like. I think using ”Update multiple records...“ to do this is simple.

    Like
Like Follow
  • 2 yrs agoLast active
  • 3Replies
  • 720Views