Hi, I have seen that automations involving lookup fields are currently not supported by Airtable (based on similar posts from 2020) but I am unsure how to work around my problem, if there is one, and am looking for some help.
I have 2 tables. When table 1 receives a new entry from a form an automation creates an entry in table 2. Currently I approve the entry in table 2 by checking a box. Table 1 is meant to look up table 2 and similarly add a checkbox, plus look up the name field associated with that record and also link the activities field across both tables.
Currently I am finding that I need to manually enter the lookup of the name in Table 1 for the other fields to update. I would like to automate this once the checkbox is filled in table 2.
Does this make sense and is it possible?