I am running an automation from a view in a synced base. The trigger is at a scheduled time which has been set and the actions are “Find Records” + “Send Email”.
Emails are sending at the scheduled time but are included outdated records that do not match the view from which the automation is derived.
Any ideas what I am doing wrong?
Welcome to Airtable Community !
From the little context we have I would say that this is a Timezone issue. Correct me if Im wrong.
Why not just trigger the automation from the view? “When Record Enters View”. What I sometimes do is add a field with a time trigger to do so
Synced tables are only periodically updated. If no-one is using the base, the sync can be very infrequent.
How out of date are the records, and how long has it been since the last activity in the base?
If it has been a while before the last activity, you can try a two automation system. Have one scheduled automation several minutes before your regular automation. The purpose of this automation is to “wake up” the base. Have this automation docs it’s own “find records” action in the synced table to wake up the base and resync. You may need to play with the interval between the two automations.