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

Forum Posts

JSON/Object Error Automation Between Airtable and Circle

Hello everyone,Goal: When new or updated Record in Airtable --> Create Event in CircleAirtable: https://airtable.com/app2Ndd4eV463aOsy/shrbaX4IOs9mGkQoPCircle API: https://microconf-de57a9.circle.so/settings/api?page=1 There are 3 required fields to ...

sonialeu by 4 - Data Explorer
  • 752 Views
  • 6 replies
  • 0 kudos

Resolved! Conditional step triggers too early because of GMT

My automation has a conditional step that runs if these conditions are met:{Date Assigned GMT} is on or after 10/01/2024 AND{Date Assigned GMT} is on or before 10/31/2024I am located in the Eastern Time Zone. I am aware that automations do everything...

Jean_Thoensen by 6 - Interface Innovator
Solved
  • 412 Views
  • 4 replies
  • 1 kudos

Extrapolating Week Number from Dates

Hi! On my table I have three fields, "Start Date", "End Date", and "Week Number". I am trying to make an automation that extrapolates the week number from the date range. I know there is a formula that does this but I'm looking to have the field be a...

ivy by 4 - Data Explorer
  • 566 Views
  • 5 replies
  • 0 kudos

Resolved! Copy + Paste Automation

Hello!I'm new to automation and trying to figure out how to copy data from one field to another when one field is not empty and the other is empty.I have a Tasks Due table and a Reminder field that is a Dateadd formula which calculates a date from da...

marig by 5 - Automation Enthusiast
Solved
  • 828 Views
  • 5 replies
  • 2 kudos

Resolved! Script to create and attach .ics file?

Wonder if anyone has something that works for this... I'm creating discrete events in a base, and I want to automate the process of turning the data points into a .ics file and attaching it to the record in an attachment field. It's a bit like this w...

Update Completed Date Field When Status is Done

Hi! I have a task table with a Status field and a Completed Date field. I'm trying to create an automation to update the Completed Date field when the Status changes to Done. Wondering if there is a way to add the date that the status was changed to ...

reem_dream by 4 - Data Explorer
  • 2589 Views
  • 4 replies
  • 0 kudos

Resolved! Automation for updating date

Hi allI have an Orders Table and an Order Line Items table.I have a Date Required field within the Orders Table which is linked to my Order Line Items table.I want to have an Updated ETD (estimated time of departure) field against each line item so i...

FPX_0-1722225990888.png
FPX by 6 - Interface Innovator
Solved
  • 555 Views
  • 2 replies
  • 0 kudos

create automation to auto update workback schedule

Hello! I have an event workback schedule set up with a formula column to auto-generate a due date based on what date I specify in my date column (see ex. formula below). However, I would like to have the formula column auto-generate a list of due dat...

meg1 by 4 - Data Explorer
  • 1008 Views
  • 1 replies
  • 1 kudos