Feb 29, 2024 02:40 PM - edited Feb 29, 2024 02:41 PM
I'm super new to airtable and I've been searching for the answer to this and I can't seem to find what I am looking for- likely because I don't know the right terminology but I have a table in my base and I want the primary field to auto populate each new record with a number and the year the record was created so that if there are multiple years I can filter them easily later.
I figure it's some sort of formula because I know how to make the field auto number, but I can't figure out the formula to do it.
Thanks in advance Amy
Solved! Go to Solution.
Feb 29, 2024 07:38 PM
Try this:
Autonumber &
" - " &
YEAR(
CREATED_TIME()
)
Feb 29, 2024 07:38 PM
Try this:
Autonumber &
" - " &
YEAR(
CREATED_TIME()
)
Mar 01, 2024 07:26 AM
Thank you so much! That is exactly what I was trying to do!