Help

Re: Formula in primary field To create id: Autonumber-year

Solved
Jump to Solution
1119 1
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!