The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.
Sep 17, 2017 08:21 PM
I’m trying to create recurring records, the logic is as follows:
I have a table with Field A and Field B
Field A is a date.
Field B is a calculated date one week from Field A’s date.
When a record’s Field A is older than NOW(), I want to create a new record with Field A being populated with the date from Field B.
Is there a way?
Please note I’m not trying to update records, I need to keep the previous records and just create new ones based on the above rules.
Sep 25, 2017 10:02 AM
Have you tried using zapier? sounds pretty simple.
Trigger: record enters view (view is defined as date>now)
Action: create record (in which date is original record date + 7d)
Cheers,
Aug 03, 2018 05:05 PM
Hello Emilio_Lopez_Romo
Can you break down the instructions for exactly how to do that? I’m not familiar with Zapier or how to use triggers…
Thanks,
Sara
Aug 03, 2018 11:33 PM
Here are step-by-step instructions to create the Zap @Emilio_Lopez_Romo described.
Make a Zap
.Airtable
New Record in view
Airtable
Create record
DateA
in the new record to be equal to DateB
in the original.That should do it! I tested on a scratch base and it works fine. (I configured the view to show records where {DateA}
is equal to Today
.)
Oct 02, 2019 09:52 AM
Finally cracked this! if anyone wants to stay inside of airtable…
Mar 14, 2020 10:17 AM
I’m new at airtable, and need some help along the same lines as above. I have a column of tasks tin a to do list. I have due dates. Some of the tasks occur weekly, some monthly, some quarterly. I made a column for Repeat date, and put in a formula to repeat every 7 days. However, I want different formulas depending on when task has to be repeated. Is there a way to do that?
Mar 14, 2020 11:32 AM
Okay, I have a thought. My calculated field is this:
DATEADD({Due Date}, 7, ‘days’)
Can I add another column that has an integer and change the formula to this:
DATEADD({Due Date}, 7*{# of weeks}, ‘days’). In the column “# of weeks” I can put 1 for weekly, 4 for monthly, 12 for quarterly, etc. Would that work? Then can I use Zapier to make recurring tasks?
Jun 03, 2022 08:29 AM
Does anyone know how to do this without creating new records? I’m trying to create recurring dates (every 6 months) based off an original date without creating a new record each time, just replacing the date every 6 months.
For example - if the date is set for Jan 1st 2022, I want the recurring date of June 1st 2022, then Jan 1st 2023, etc all in the same record.
So far I have used: DATEADD({Start date}, 6, ‘month’) but this only gets me one date and I’m not sure how to go beyond that.