Formula in primary field To create id: Autonumber-year

Question

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

Page 1 / 1

Try this:

Autonumber & 
" - " & 
YEAR(
  CREATED_TIME()
)

Link to base

Try this:

Autonumber & 
" - " & 
YEAR(
  CREATED_TIME()
)

Link to base

Thank you so much! That is exactly what I was trying to do!

TheTimeSavingCo · Accepted Answer

Try this:Autonumber & " - " & YEAR(  CREATED_TIME())Link to base

AmyM11 · Answer

Try this:Autonumber & " - " & YEAR(  CREATED_TIME())Link to baseThank you so much! That is exactly what I was trying to do!

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded