Automate add of rows values for a table

Hello,

I have a project table and a Data table which contains a reference to the project table, I would like to create an automation which each time a new Project is created adds data to the Data table, I manage to do it except for the project column ( of ref type) of the Data table where I would like to add the name of the project created (which triggers the automation) The table selected for Add row to this table is Data and I cannot find the expression which will allow me to insert the name of the project created in the Project column.

Thanks in advance for your help.

Solved Solved
0 6 406
1 ACCEPTED SOLUTION

Have you tried setting the expression simply to [_THISROW] or [_THISROW].[ROW ID]? Note though that this assumes a relationship as in Key Value from the other table vs just the name of the Project.

View solution in original post

6 REPLIES 6
Top Labels in this Space