The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.
‎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!