+4Hi,
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!
Best answer by kuovonne
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.
+29Welcome 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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
