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

Automatic numbering & calculating dates

411 1
Showing results for 
Search instead for 
Did you mean: 

I am looking to create a table of the cat population of my sanctuary. I would like the first column to be a number that automatically populates that is not necessarily attached to the record. I want to be able to order the records alphabetically by name but always need the records to be numbered 1-?? so I know how many cats I have.
I also would like to have a Birthdate column and an Age column that is automatically calculated so I’ve always got an accurate age for them when I go to look at their record.
Any help on this would be appreciated. :thumbs_up:

1 Reply 1

Hi There,
You can Use the first column to create the auto numbers by customizing field type and select “Auto number”, use another field to then enter Cat names.

Add a column for birthdate and select Date as the format type

Asuming your date column is named “birthdate”, use the formula below in a new column to calculate age

DATETIME_DIFF(TODAY(),birthdate,‘years’)&’ Year(s), ‘& MOD((DATETIME_DIFF(TODAY(),birthdate,‘months’)),12)&’ Months’