I have records in one table, and when a checkbox is selected, I would like that record to be copied to another table in the same base.
The reason for this is that I am pushing information from Airtable into another app. However, because Airtable lacks the ‘trigger on update’ functionality, I can only trigger from a new record or a new record in a view.
These records may be updated a number of times, so even the new record in a view does not do what I need it to (because it will only trigger the first time).
So, what I am left with is to copy the updated record to a new table every time I want to push it to the other app.
I’d like to at least automate this so that I can just use a checkbox to trigger that action.
Is there a way to do this? A script, some hidden functionality that isn’t evident?