Skip to main content
Solved

Formula in primary field To create id: Autonumber-year

  • February 29, 2024
  • 2 replies
  • 45 views
A
Forum|alt.badge.img+3

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

 

Best answer by TheTimeSavingCo

 

Try this:

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


Link to base

1 Attachments

2 replies

TheTimeSavingCo
Forum|alt.badge.img+31

 

Try this:

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


Link to base

Adam, Airtable Consultant - thetimesaving.company
pressGO_design
A
A
Forum|alt.badge.img+3
  • AmyM11
  • Author
  • New Participant
  • March 1, 2024

 

Try this:

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


Link to base


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

TheTimeSavingCo
Terms & ConditionsAccessibility statement