Upload CSV for Column Referencing Another Table (list)

Prepify

In one of my tables I have a column that is a list. It references another table. How do I upload a csv and get it to correctly populate that coulmn.

Currently if the csv file has a given list like [1,2,3] for a particulat cell, I would expect those 3 ids from the refernced table to populate that cell. However, it just turns null.

What format do I need to put the id's in for them to correctly populate the cell.

Michael Udinski

Hi @Peter Nooteboom - CSV import does not support lists and objects. One workaround would be to upload the field as a text string. After bringing in the data, create the desired table reference list field, then use the function stack to migrate the data and update it to the desired field.