Automatic numbering & calculating dates

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. :+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’


Regards
Victor

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.