Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

How to create a field where each record is a consecutive date

Solved
Jump to Solution
660 4
cancel
Showing results for 
Search instead for 
Did you mean: 

Is there an easy way of creating a column (field) in Airtable that includes consecutive dates (ie. each record shows the next date on from the record before)?

The only way I find I can do this is to manually insert each date.

Another way would be to select two of the dates and drag down or up through empty records (a la a spreadsheet). But unlike Apple Numbers you cannot create new records as you drag. Therefore you have to pre-create the empty records. The problem is that the empty records are not adjacent to the most recent date (and I want to add dates after the most recent date). The empty records always appear at the other end of the list of records.

I assume I am missing something basic?

Thanks

1 Solution

Accepted Solutions

If you want to pre-create several records with consecutive dates, you can turn off auto-sorting, create the records, and then turn sorting back on.

Airtable is different from a spreadsheet in that row order is very flexible. When auto-sorting is turned off, you can easily drag rows into different orders. You can also create different views with different sort orders.

See Solution in Thread

4 Replies 4

Hey @eyrebabel

Yeah, you’ll need to create new records using Shift+Enter and hold it down to create them quickly. Then, enter in a few consecutive dates, highlight them, and drag it down so it automatically fills with the next dates in order.

I’m not sure of a better way, except maybe a script. And that’s out of my wheelhouse.

The idea on my head was to use an Autonumber field, and create a Formula field using the DATEADD() functión, adding the Autonumber of days. So every new record is a day after the last one.

Captura de pantalla 2022-01-24 a las 22.48.49

Note: If you delete a record, the autonumber value does not recalculate (see the missing 6).

If you want to pre-create several records with consecutive dates, you can turn off auto-sorting, create the records, and then turn sorting back on.

Airtable is different from a spreadsheet in that row order is very flexible. When auto-sorting is turned off, you can easily drag rows into different orders. You can also create different views with different sort orders.

Thank you for the great suggestions. They make it much easier for me!