Help

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.

Formula in primary field To create id: Autonumber-year

Topic Labels: Formulas
Solved
Jump to Solution
1281 2
cancel
Showing results for 
Search instead for 
Did you mean: 
AmyM
4 - Data Explorer
4 - Data Explorer

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

 

1 Solution

Accepted Solutions
TheTimeSavingCo
18 - Pluto
18 - Pluto

 

Try this:

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

Screenshot 2024-03-01 at 11.37.51 AM.png
Link to base

See Solution in Thread

2 Replies 2
TheTimeSavingCo
18 - Pluto
18 - Pluto

 

Try this:

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

Screenshot 2024-03-01 at 11.37.51 AM.png
Link to base

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