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

Forum Posts

Date error in copy-and-paste automation

Hi all,I'm working on building a base for my team, and am having an issue with automating a copy-and-paste function.I have a formula which calculates the due date for tasks based on a set number of workdays from the start date. However, sometimes we ...

Screenshot 2023-12-08 at 1.28.46 PM.png Screenshot 2023-12-08 at 1.30.34 PM.png Screenshot 2023-12-08 at 1.30.23 PM.png Screenshot 2023-12-08 at 1.31.00 PM.png
ajewell by 1 - Visitor
  • 25 Views
  • 0 replies
  • 0 kudos

Automations using a number of days ago record conditions

I have email automations that are sent out when a record matches conditions. When a date is one day ago an email is sent. Overnight this has not worked, emails have sent even though the field date that triggers the email was not one day ago. What cou...

Jwatson1 by 4 - Data Explorer
  • 52 Views
  • 0 replies
  • 0 kudos

Resolved! Automations to remove calendar entries?

I use Airtable to track and schedule vaccinations for the animals in my calf barn. Using the birthdate of the calf, I have formulas in the due date fields to calculate the appropriate date to give each vaccine to each animal. Then I have a field with...

Lulabirdy10 by 4 - Data Explorer
Solved
  • 152 Views
  • 2 replies
  • 2 kudos

Sorting Record Grid Returned by 'Find Records' Automation

Hi all,I'm using the 'Find Records' automation to get a grid of records to email to other people. Though my table is sorted by date, the records are being returned in a completely random order (see attached, specifically the Overtime Worked Date colu...

user_533 by 5 - Automation Enthusiast
  • 375 Views
  • 2 replies
  • 1 kudos

Resolved! Automation to convert text timecode string to a duration field

Hi All, I'm trying to use a linked record to pull up the TRT of an asset that's listed out as a full timecode, extract just the hours and minutes and put that into a duration field. I've gotten so far as to pull the hours and minutes but when I set t...

trt.jpg

Resolved! Automated Email is sending in correct time and date

Hello,I am reaching out to see if anyone else has had this problem and knows how to fix this.We use a form that is to file reports at the end of a shift, which includes the time stamp of when the form is being filled out. This form is then sent out t...

Resolved! Inserting date in a field

Hello everyone,I need to insert the current date in a filed when a second field is updated (Yes or no) in the record updated.My need is that the first field is a "Date" because it could be modified inserting a different date in the case of any modifi...

Status Dictates a Date

I want to have my status column auto fill a date in the Actual RFP Date when the status is set to RFP. But then there are more status changes that will happen after that, and I don't want the Actual RFP Date to disappear once the status is change to ...

cdarroch by 4 - Data Explorer
  • 164 Views
  • 0 replies
  • 0 kudos

Automatically Change Date Based on Another Field

I have 4 columns that affect each other for our woodworking shop tracking: Status, Actual RFP Date, Required RFP Date, and Manufacturing complete date. Manufacturing complete date is just a date that is entered as an ideal completion date. Manufactur...

cdarroch by 4 - Data Explorer
  • 194 Views
  • 0 replies
  • 0 kudos

I have a problem with Outlook Calendar on automation

So, I have created a booking system exactly like this How to make a simple booking system with Airtable! - YouTube , but I want to make an automation whenever the form is submitted, it will create a new event on Outlook. The problem is, the video doe...

Auto Create Weekly Calendar Entries in Advance

Hi,I need some help auto creating weekly calendar entries a few weeks in advance.Currently my automation is set to create 8 calendar entries every Sunday, which shows on a Calendar view for one of my tables. For instance, if my automation ran on 9/3,...

jinnyma by 4 - Data Explorer
  • 144 Views
  • 0 replies
  • 0 kudos

Resolved! How do I set a date field to NOW() in automation?

I want to set a Date field to the current date time in an automation. I tried using a formula field (with NOW()) from a previous step in the automation to set this Date field but the automation fails with the error;Field "Date" cannot accept the prov...

Ruchika_Abbi1 by 6 - Interface Innovator
Solved
  • 1613 Views
  • 5 replies
  • 5 kudos

Automatically Link Based on Date range

Can I create an automation (or formula field) to do the following?When a record is created in the "Deals" table,  if the Move-in date of that record is within the range of the start & end dates of a record in the "Payments" table,  link the new Deals...

vshammah by 4 - Data Explorer
  • 365 Views
  • 2 replies
  • 0 kudos

Trouble displaying Custom Buttons in Interface

Hello Airtable communityI've been diligently working on a time-tracking solution in Airtable for a nonprofit organization. Inspired by a YouTube video from Dan Lehman, I aimed to craft a system where volunteers could easily log their hours during a p...

UWTSAVITA_0-1692209070556.png UWTSAVITA_1-1692209150980.png
UWTSAVITA by 4 - Data Explorer
  • 267 Views
  • 0 replies
  • 0 kudos

Resolved! Trigger Email After 7 Days Contact

Hi Airtable Community!I want to be able to send an email if 7 days has passed since they last received an email.I have set a date field in my database to be populated with today's date when an email is sent from my automations.I now want to create an...

Gavin_C by 4 - Data Explorer
Solved
  • 400 Views
  • 6 replies
  • 1 kudos