Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Insert this month in cell when adding new row

Topic Labels: Scripting extentions
Solved
Jump to Solution
281 2
cancel
Showing results for 
Search instead for 
Did you mean: 

Hello I would like to create a field where when data is imported into AirTable, that it would input the current month as written into a specific cell.

like “7/1/2021”, for any entries entered in that month, I want this one cell to enter 7/1/2021, and not update any previously entered rows.

1 Solution

Accepted Solutions

Try using a Created Time field. Or, if you want to display the name of the month a record was created, use a Formula field: DATETIME_FORMAT(CREATED_TIME(), "MMMM")

See Solution in Thread

2 Replies 2

Try using a Created Time field. Or, if you want to display the name of the month a record was created, use a Formula field: DATETIME_FORMAT(CREATED_TIME(), "MMMM")

Welcome to the community, @Drew_Nemer! :grinning_face_with_big_eyes: If Kamille provided the answer you were seeking, please mark her comment as the solution to your question. This helps others who may be searching with similar questions. Thanks!