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?
Automation - Select "January" in a multiple select field when a date field on that entry is between 1/1/22 and 1/31/22
This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.