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.

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

posted Mar 18, 2022 1:54:43 PM

Topic Labels: Dates & Timezones

0 1006 0

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

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

Update a multiple select field using Airtable API

Script - multiple select update error

use single select field values in input select

Write To Multiple Select Field

Select Multiple Records and Update