Help
Automations
cancel
Showing results for 
Search instead for 
Did you mean: 

Forum Posts

Retrieving the most recent date

Hello! I am creating a field for event attendees. I have each attendee's name, the events they attended, and the dates of the events they attended separated into 3 columns. I would like to make a fourth column that retrieves the most recent date each...

Screenshot 2024-05-22 at 12.06.15 PM.png
ccody by 4 - Data Explorer
  • 57 Views
  • 2 replies
  • 2 kudos

Automation when DATE is Today - Change Time

I have a "Send an email" automation set up with the trigger "when {{Date field}} is one week from now."It's working great, except the emails are going out just after midnight. I'd prefer them to go around 9am. I have added a time to my date field, bu...

samlsflst_0-1715950957399.png samlsflst_1-1715950974691.png
sam-lsf-lst by 5 - Automation Enthusiast
  • 129 Views
  • 1 replies
  • 0 kudos

Resolved! Automated Google Calendar End Date ends a day early

I have an automation set up to add an event to my google calendar. It is working fine except, the end date it shows on the calendar is showing up the day before it ends. I have the events with no time listed because i do not want a specific start and...

Resolved! Updating Status After Time Period

Hi, I have been having problems with this for weeks now and cannot understand why my automation is not working. I work for a company that runs an appointment based service. I book the date it  is for and the status of it. When I put in the info, it i...

Noahbrown18_0-1713794369696.png
Anonymous by Not applicable
Solved
  • 962 Views
  • 14 replies
  • 0 kudos

update item status when expiration_date < today()

Hi, I have an item status field the contains the values active, expired, and delete. in addition, I have another calculated field that contains the expiration date of the item. I want to set an automation that will run daily and change item status to...

almogw by 4 - Data Explorer
  • 542 Views
  • 7 replies
  • 1 kudos

Sort existing information by date & time

Hi! I have a large existing google sheets I am trying to organize into Airtable. I own an events agency that books out talent for hundreds of events each month. This is a living document that is updated every day by people who fill out our form to bo...

automated calendar in my form I don't have to keep updating

Hi,I have a Comedy Club and I use an Artist Availability form I made, so that the comics can pick and chose the dates they are available, 3 months at a time.Is there a way to have automate a calender so I don't have to keep making a new form every 3 ...

Tony_240 by 4 - Data Explorer
  • 212 Views
  • 1 replies
  • 0 kudos

Tag a record based on date range

I'd like to create an automation to "tag" each record based on the date it was created. I have a table in the same base (let's call it Table 2) with "Start Date" and "End Date" fields, plus a tag for that date range. So when the new record is created...

jimmydaly by 4 - Data Explorer
  • 850 Views
  • 7 replies
  • 0 kudos

Resolved! Having trouble updating a date field with results from a formula

I'm having trouble updating a date field with results from a formula. Please helpMy desired outcome is the following: When the user updates the "last communication date" field, then Airtable will automatically update the "next communication date" to ...

Screenshot 2024-03-26 at 12.47.01 PM.png Screenshot 2024-03-26 at 12.46.54 PM.png Screenshot 2024-03-26 at 12.46.25 PM.png