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 view
my Data view : Projects > Project Name 1 > Data
My project Data in my DB
my Data Table with a ref type column name Project
User | Count |
---|---|
17 | |
11 | |
7 | |
5 | |
5 |