Hi Gareth, if I may, could I use this approach to retrigger an action on every same day of each month? So if we are the 28th today it would retrigger the 28th of september. Reason here is that if I work with « days », the task retriggered could appear on the 27th or 29th next month depending on number of days in month. THANKS! Luc
Sure! To do this, instead of adding a number of days on the formula, instead add a number or weeks or months. In this case, add one 'month' and it will keep it to the same date every month. 💪
This one feels a bit complex to set it up. I've setup a similar automation using At scheduled time trigger. Are there advantages of setting it up like this?
Hey Ben, the scheduled time trigger is great and I use it a lot. The thing to remember with the scheduled time trigger is that it is inflexible. If you want to change the frequency in the future, you have to get into the automation and reconfigure it. With the approach I demonstrated in this video, you only need to adjust the frequency select field and your automation will now trigger on the new interval (without reconfiguring the automation).
Hi Gareth, i am a newbie at Airtable, and i don't have coding experience, English is not my first or second language, so I am struggling with the formulas as they are all in English. I want a trigger that triggers every week, I have done that in airtable, and that works fine by your example; SWITCH(Frequency,'1-week',7, but I also have a trigger that is at 6-months. I don't know how to get that in the formula, as it only counts days, and 6 months isn't explainable in days. so I have this ;SWITCH(Frequency,'1-week',7,'6-months', and then? can you help me? 😟
You can make a change here to count in weeks instead of count in days. So your formula can say: Switch( {Frequency}, "1-week", 1, "6-months" 26) Since 6 months is half the year, 26 weeks should work well here. Then for your last formula... Dateadd( {Last Ran}, {Last Formula}, 'weeks') Hope this helps!
Grab my *FREE TRAINING* that teaches the building blocks of automation: www.garethpronovost.com/webinar-registration 👈👈
What a great idea!! Loved this!
Many thanks for your amazing and useful content
Happy to be able to contribute! 🙌
Hi Gareth, if I may, could I use this approach to retrigger an action on every same day of each month? So if we are the 28th today it would retrigger the 28th of september. Reason here is that if I work with « days », the task retriggered could appear on the 27th or 29th next month depending on number of days in month.
THANKS!
Luc
Sure! To do this, instead of adding a number of days on the formula, instead add a number or weeks or months. In this case, add one 'month' and it will keep it to the same date every month. 💪
@@GarethPronovost GREAT! THANKS!
This one feels a bit complex to set it up. I've setup a similar automation using At scheduled time trigger. Are there advantages of setting it up like this?
Hey Ben, the scheduled time trigger is great and I use it a lot. The thing to remember with the scheduled time trigger is that it is inflexible. If you want to change the frequency in the future, you have to get into the automation and reconfigure it. With the approach I demonstrated in this video, you only need to adjust the frequency select field and your automation will now trigger on the new interval (without reconfiguring the automation).
Hi Gareth, i am a newbie at Airtable, and i don't have coding experience, English is not my first or second language, so I am struggling with the formulas as they are all in English. I want a trigger that triggers every week, I have done that in airtable, and that works fine by your example; SWITCH(Frequency,'1-week',7, but I also have a trigger that is at 6-months. I don't know how to get that in the formula, as it only counts days, and 6 months isn't explainable in days. so I have this ;SWITCH(Frequency,'1-week',7,'6-months', and then? can you help me? 😟
You can make a change here to count in weeks instead of count in days. So your formula can say:
Switch( {Frequency}, "1-week", 1, "6-months" 26)
Since 6 months is half the year, 26 weeks should work well here. Then for your last formula...
Dateadd( {Last Ran}, {Last Formula}, 'weeks')
Hope this helps!