Help

Autoadd date record

Topic Labels: Dates & Timezones
Solved
Jump to Solution
1330 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Patryk_Sulejcza
4 - Data Explorer
4 - Data Explorer

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
kuovonne
18 - Pluto
18 - Pluto

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
kuovonne
18 - Pluto
18 - Pluto

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.

Patryk_Sulejcza
4 - Data Explorer
4 - Data Explorer

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