Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Sep 24, 2021 03:54 AM
Hi everyone,
I have a pretty simple base and need some of the records to recur daily. Right now I just change the dates on all of them at the end of each day.
Is there a simple way to turn a few records into recurring records in Airtable without having to use another tool (such as Zapier etc.)? I’ve seen some solutions but they all seem a bit complicated and I hope there is a new feature that I am not aware of that could make my life easier now :slightly_smiling_face: .
If there isn’t is there a least a way to select a few records and change their dates all at once?
Thanks in advance and peace to you all,
Keren
Sep 24, 2021 06:42 AM
You could maybe use a Formula field with Today()
?
Sep 24, 2021 07:10 AM
Thanks for your response! @Per_Carlen
Is there a way to use formula in a specific cell?
If I use a Formula column, and set it for “today”, the whole column would be set for today’s date.
(Sorry, I’m new in this… :slightly_smiling_face: )
Sep 24, 2021 07:17 AM
What would the input dates be, and what would you like to change them to?
Sep 24, 2021 07:34 AM
@Per_Carlen, the input date is today’s and I want the same record to repeat tomorrow, the day after and so on.
For example a daily half an hour staff meeting at the same hour.
The other records in the same base are one-time tasks.
And there are a few weekly tasks and some monthly events.
I’m looking for a simple way to do it, something similar to Outlook calendar, if that exists.
Sep 24, 2021 08:40 AM
What do you mean with this?
If you use Today()
, the field will show 2019-09-25 tomorrow. Is that what you want?
Sep 24, 2021 08:57 AM
This formula will return current day and 07:00 am.
DATETIME_PARSE(DATETIME_FORMAT(TODAY(), 'YYYY-MM-DD 07:00'), 'YYYY-MM-DD hh:mm')
Sep 24, 2021 12:36 PM
Welcome to the Airtable community!
Do you want to create new records each day, or do you want to recycle existing records and give them a new date?
If you just want to automatically change the date of some existing records every day, you can use an Airtable automation that runs every day with update record actions. You can get the record IDs from a formula field. This may not be any easier than the other methods you have found.
Sep 25, 2021 05:40 PM
Hello Keren,
If you don’t want to deal with setting up an automation, maybe you can use this approach:
If (Periodicity = 'Daily', Today())
Periodicity = 'Daily'
This view should show the daily tasks automatically rolled over each new day.
(Not tested; try it on your own :slightly_smiling_face: )
Sep 25, 2021 10:07 PM
Thank you, everyone. I will check out all your solutions.
I really appreciate your replies :slightly_smiling_face: