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

Forum Posts

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
  • 610 Views
  • 4 replies
  • 4 kudos

Autopopulate address field

Hi! 2 things…I’m trying to find a workaround so that when you being typing in the address field, the address starts coming up like in Google maps. I have the map extension installed and can not figure it out. From what I’m researching it’s not possib...

Debbiedis by 4 - Data Explorer
  • 201 Views
  • 4 replies
  • 3 kudos

Automation assistance needed : using formula on date

So, for learning purposes, I have a next review date I input when I create a field.I've set up an automation to email me the matter of the field when the review date arises. I also want to setup an automation to increase the next review date by 3 day...

EANA by 4 - Data Explorer
  • 247 Views
  • 1 replies
  • 2 kudos

Create a google calendar when event is created in airtable

Hi everyone,I would like to create 1 automation that starts when a record is created in airtable and that creates an event on google calendar. I used the "when recordmatches conditions" trigger specifying the conditions to make it activate (for examp...

Eugenia by 4 - Data Explorer
  • 184 Views
  • 1 replies
  • 0 kudos

Finding Dates between Start/End

I have a tab within a table, the tab is called PTO. the PTO tab has two different views I am working between for this automation. The PTO tab as a whole is populated from forms that are submitted containing requests for time off from employees. This ...

bexxmill by 4 - Data Explorer
  • 190 Views
  • 1 replies
  • 0 kudos

View assigned history

Hello,I have a Database that includes a table of Users and a Table of inventory (Computers , Monitors, Docking stations and so on).All of our inventory is mapped by serial number.When I give the user a device I assign it to the Air table.I want to ha...

tombon101 by 4 - Data Explorer
  • 226 Views
  • 2 replies
  • 0 kudos

Resolved! Save date/time of record change

Hello,I have a table. In the table there is a column named "Status" (single select field) with different selection possibilities. ("Property1", Property2",...).In the table is another date/time field.I want that when the status in "Property1" is chan...

KevinDax by 5 - Automation Enthusiast
Solved
  • 625 Views
  • 4 replies
  • 1 kudos

Send diferents results for each users

I am using Airtable as the backend for my app. I have a Table A for registering users and a Table B for registering restaurants. Through the Google Matrix Distance API, I am using longitude and latitude data to calculate the distance between register...

PauloPurcino by 5 - Automation Enthusiast
  • 221 Views
  • 2 replies
  • 0 kudos

Creating recurring staff duties

Hey y'all, hoping you can help me solve a thorny issue. We use Airtable in a big way across all of our teams, and we've built a Daily Duties board to give ownership and sightline to the must-happen daily needs of the business. Individual team leads a...

Resolved! Gmail automation triggered a day earlier

Happy Holidays everyone! I have a table that includes columns for both Start Date and End Date. Date format for both date fields is "Local". My gmail automation is setup so that when 'today' is 10 days from the End Date, the client will receive an au...

Nedra_Hines by 6 - Interface Innovator
Solved
  • 280 Views
  • 2 replies
  • 0 kudos

Resolved! 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 4 - Data Explorer
Solved
  • 694 Views
  • 2 replies
  • 1 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
  • 183 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
  • 368 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
  • 623 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