Automation with csv import

Hello, I perform a csv import action and the imported data is added correctly to my Appsheet database but is not displayed in my application view, I think this is due to the fact that my Data table which stores this data contains a Project column of reference type and this remains empty because this column is not contained in the imported csv file, I would like to create an automation to retrieve the name of the project where the import was made to add automatically set this value to the project column for all rows added to my database after import, so that this data is displayed correctly in the correct project.

I created an automation with a Data change of type Adds as a trigger event for my Data table, I chose as a process to execute a set row values โ€‹โ€‹for the Project column of my Data table, I tried several expressions like value ( [Project].[Project Name] or THISROW) but I could not solve my problem. Thanks in advance for your help.

my Projects viewmy Projects viewmy Data view : Projects > Project Name 1 > Datamy Data view : Projects > Project Name 1 > DataMy project Data in my DBMy project Data in my DBmy Data Table with a ref type column name Projectmy Data Table with a ref type column name Project

0 0 103
0 REPLIES 0
Top Labels in this Space