Skip to main content
Solved

Insert this month in cell when adding new row

  • July 1, 2021
  • 2 replies
  • 31 views

Drew_Nemer
Forum|alt.badge.img+20

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.

Best answer by Kamille_Parks11

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")

2 replies

Kamille_Parks11
Forum|alt.badge.img+27
  • Brainy
  • 2679 replies
  • Answer
  • July 1, 2021

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")


Justin_Barrett
Forum|alt.badge.img+21
  • Inspiring
  • 4647 replies
  • July 6, 2021

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!