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! Go to 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.
User | Count |
---|---|
16 | |
11 | |
7 | |
3 | |
2 |