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.

Insert this month in cell when adding new row

Topic Labels: Scripting extentions
Solved
Jump to Solution
1073 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!