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

Forum Posts

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
  • 842 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
  • 461 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
  • 185 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
  • 756 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

Prevent Milestone Dates from moving

Hey all,I'm working on setting up a tracker for my team, but I'd like to set it up so that our final milestone in the Gantt chart is a fixed date that cannot be changed. The milestone date represents our client delivery date that we cannot pass, so i...

emking by 4 - Data Explorer
  • 267 Views
  • 1 replies
  • 0 kudos

Resolved! Calculate a date for an automated task

Hi,I'm trying to set up an automation that generates tasks with due dates. For example, when I create a project with an overall due date in a "projects" table, I plan to create a record in the "tasks" table with individual tasks and due dates calcula...

Sarah_Krutz_0-1685729597696.png
Sarah_Krutz by 5 - Automation Enthusiast
Solved
  • 804 Views
  • 4 replies
  • 4 kudos