Automation - Select "January" in a multiple select field when a date field on that entry is between 1/1/22 and 1/31/22

Topic Labels: Dates & Timezones
828 0
Showing results for 
Search instead for 
Did you mean: 
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi Airtable community! I’m new here and am building out a budget table for work. I’m trying to create an automation that updates an entry to say a certain month in a field when the date in the field next to it is within that month. For example, if money was spent on a “photographer” on 1/15/22, we will enter the exact date in one field (with a date field type) and then I want the field next to it to automatically change to “January” (with a multiple select field type). Can someone help me figure out how to automate this?

0 Replies 0