Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Autoadd date record

Topic Labels: Dates & Timezones
Solved
Jump to Solution
286 2
cancel
Showing results for 
Search instead for 
Did you mean: 

Hi,
How can I add formula which autoadds date field to be +1 day to date field in previous record?
I am working on content publishing base and want to automate publishing date field.

For example: in record 1, my date field is: 10/13/2021 and I need formula which gives date 10/14/2021 in record 2 and 10/15/2021 in record 3.

Thanks in advance!

1 Solution

Accepted Solutions

Welcome to the Airtable community!

As much as Airtable looks like a spreadsheet, it is not a spreadsheet, and cannot do some things that come easily in a spreadsheet. This is one of those things. Records in Airtable are not aware of which record comes “before” or “next” because the order of records is not fixed.

In the user interface you can use the drag handle on the date field to fill in increasing dates. Just select multiple cells with increasing dates before you begin the drag.

You can also use a scripting automation to calculate the next date and fill it in. However, this may be overkill for your situation a d too slow.

See Solution in Thread

2 Replies 2

Welcome to the Airtable community!

As much as Airtable looks like a spreadsheet, it is not a spreadsheet, and cannot do some things that come easily in a spreadsheet. This is one of those things. Records in Airtable are not aware of which record comes “before” or “next” because the order of records is not fixed.

In the user interface you can use the drag handle on the date field to fill in increasing dates. Just select multiple cells with increasing dates before you begin the drag.

You can also use a scripting automation to calculate the next date and fill it in. However, this may be overkill for your situation a d too slow.

Thank you Kuovonne for your reply!
Now it seems more clear to me.