I want to create a certain automation. When the row is added in the Table1, I want to add a new row in the Table2 and automatically create a relation field between. For now adding new row in Table1 adds a row in the Table2, but when I pass row ID from Table1 (which is a number) to Table2 (via modify row automation), Table2 sees it as a number, not as proper ‘relation’ value thus I can’t get information from Table1 to Table2.
View from Table2:
Proof that for example field with ID 108 exists:
did you consider tot put the column on ‘relation’ and next select the table you want to talk to?
give it a try and let me know how it goes, cheers, Christiaan