Help

Insert this month in cell when adding new row

Topic Labels: Scripting extentions
Solved
Jump to Solution
965 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Drew_Nemer
8 - Airtable Astronomer
8 - Airtable Astronomer

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
Kamille_Parks
16 - Uranus
16 - Uranus

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
Kamille_Parks
16 - Uranus
16 - Uranus

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!