CSV import issue for a table with a reference column

[Lou1]

Hello everyone, I perform a csv import action and the imported data is added correctly to the Data table of my Appsheet database but is not displayed in the corresponding view in the application, this is because my Data table which stores the imported data contains a Project column, reference to a Projects table which remains empty as this column is not contained in the initially imported csv file. To resolve this problem, I processed the csv file to add the “Project” header with the name of the project for all the lines of my file (this name is the same as that of the application where I wish to import the data by going through Projects > Project Name > Related Data) I don't understand why with the modification of the csv file the data relating to the Project column does not appear in the Data table while the others appear. Could anyone help me?

[AleksiAlkio]

There is no need to add an additional column to your CSV if you just want to add a specific value to all rows. You could write an initial value like.. IFS(CONTEXT("Host")="Server","YourValue")

[Lou1]

Thanks a lot. I finally found a solution (by defining an action that allows me to pass from Appsheet to a web app to process the csv and returned a csv compatible with the native import action of Appsheet and my database, while asking the user for the name of the corresponding project, and inserting it into the csv file for import.