Updating Junction table with new record

Hi. Would appreciate some help here.

I have a Junction table (Table 3 - created from the “Create junction table” app) combining Table 1 and Table 2.

Just realised that if I run the app, new records or deleted records in Table 1 or Table 2 will also update Table 3 (:+1: :+1: :+1:).

Challenge is, can I do this automatically (without pressing “RUN” and agreeing whether to “Proceed?”)

Can this be done in the background (as an automation, triggered upon new record) or can we schedule the app to run at a certain time?

Thanks for any advice.

regards
jamesquek

Unfortunately apps can’t be triggered via automations or scheduled to run at certain times. It’s a great idea, though. I recommend writing to Airtable support to suggest it. In the meantime, manually running the app is the only option.