Adding linked records by automations

[Christian]

Hello everyone,

I have a question about automation.

I have a table A with a single selection with the options variant 1, variant 2 and variant 3.

I also have the tables ‘Variant 1’, ‘Variant 2’ and ‘Variant 3’.

I would like to create an automation that is executed when a new entry is created in table A. The automation should do the following things:

1. if Variant 1 was selected in the single selection when creating the new entry in table A, a new entry should be created in the ‘Variant 1’ table. Same for Variant 2 etc.
2. the new entry in table A is to be linked as a link in the new entry in the ‘Variant 1’ table.

I can create an automation that solves my first task. To do this, there must be a column in the ‘Variant 1’ table which ‘can be filled’. For example, a column of the type ‘Text’. In this case, I have to enter a standard text in the automation, which is then entered in the automatically added rows in the ‘Variant 1’ table.

Is it also possible to create the automation so that the link is added to the triggering entry in table A? Is this possible using other/additional automations or a script?

Thank you very much for your feedback!

Christian

[rdb]

@Christian

Is it also possible to create the automation so that the link is added to the triggering entry in table A? Is this possible using other/additional automations or a script?

Absolutely!

This automation gets the job done when a user selects Variant 1 in the single select

Key is that you have a formula column in Table A that returns the row ID. In the first automated action, this row ID is copied to table Variant 1. In the second automated action, it is used to establish a link back to Table A.