Hi everyone,
is it possible to set an automation to populate a link to a record field?
In brief, my base is made up of many tables (one general and others specific), all sharing the same ID for the same entity. I would like to set an automation to a link a specific attribute from the general table to one of the specific (given a matching ID). Entities may be present in all the tables and share the same ID number.
For example:
If the general and specific table have entities with ID 1, 2 and 3, I would like to automatically link the record with ID 1 from general to the ID 1 in the specific and so on...
Is it possible? could you share the steps?