Im an airtable newbie with very light coding experience. Having several challenges setting up the bases for my team, but there’s one in particular that I cant seem to figure out.
I’ve created an automation that triggers record B to be created on table B whenever a new record (record A) enters the view on table A.
Table B’s purpose is to aggregate information from table A and table C and provide a top level view of many different scheduled communications. The problem that I have now, however, is that whenever there are updates to record A or C—like a date change, for example—the updates arent passed along to record B. I tried to create an automation triggered when record A is updated, but am unable to link it to record B.
Are any of the below possible through a script or automation?
1- when record A is updated, the now outdated, record B is deleted and a new, updated, record B is created
2- when record A is updated a new record B is created, script runs to remove older record by searching for duplicated names
3- when record A is updated, record B is updated
Any help or insight is appreciated!