Hey @Kim_Trager1,
Yes in my experience that would be more than enough!
Do new rows that are created via the sync count as 'created record' even though there is no human intervention in the target table?
I don’t think so, I vaguely remember having this exact issue of a synced table not picking up a new record because that base was untouched
---
The use of this table is periodic, as the nature of my business is seasonal. So to avoid any sync to stop working, will a periodically run automation, say a weekly automation will click a check box. Will that be enough to keep the sync running?
Yeap it would. Your workflow’s okay with working with one week old data?
---
It says the automatic sync will eventually stop being active. Does anyone know what time horizon this is? weeks, months, half a year?
I think it was a couple of days / weeks for me
No, creating records via sync is not treated as a user activity. So, you'll likely need to set up an automation to keep the base active.
I've seen bases go inactive within a couple of hours as well. Airtable doesn't clearly define the exact timeframe for inactivity, so you may need to experiment. Start by checking after 2 hours, then gradually double the interval to see how long the base stays active.
A better option might be to reach out to Airtable support for an accurate timeframe regarding base inactivity.
I've also written an article on this topic, which you can read here.
Taha, Airtable Advisor
Hi @Kim_Trager1,
Bases “fall asleep” multiple times per day, and they fall asleep in a relatively short amount of time. They will fall asleep in just an hour or so after they’re not being actively used.
So the solution is that you’ll need to wake up BOTH the source base AND the destination base whenever you want the sync to happen.
And you’ll want to make sure that you wake up the source base about 10 minutes before the destination base.
The easiest way to do this would be to set a scheduled automation in each base that runs on a schedule, such as once a day or once a week or whenever you need the sync to happen.
Hope this helps! If you’d like to hire an expert Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld
Thanks @Mike_AutomaticN , @TheTimeSavingCo and @ScottWorld for these inputs.
@TheTimeSavingCo, The idea would then, I guess, be a daily or twice-daily scheduled automation.
@ScottWorld Do you know if a Make automation would also count as an automation, or would it need to be a native Airtable one?
Yes, I believe that a Make automation will wake up the bases as well.
- ScottWorld, Expert Airtable Consultant