Automations

I've created a task list. When 'Done" is clicked, the "Date Completed" is updated and the "Next Due" is updated based on a formula dependent on the 'Freq'. All this works fine.I then have an automation that runs to create a new record with a 'Due' date populated with the previous records 'Next Due'The automation runs fine except in the evenings where it adds a day? During the day it is fine. You an see in the attached, "IG New Messages" was clicked 'Done" on 1/10, 'Date Completed' was 1/10, 'Next Due' was 1/11 but then the automation changed the new records 'Due' to 1/12It is like there is a time zone issue somewhere but I can't figure it out so any help is greatly appreciated.

Hi guys,As of now, I use both filtering views and conditions on records as automation triggers. But in your opinion, is there some best practice to follow on that topic? I assume there must be some pros and cons to both options. I’d be curious get the take from experts out there.Thanks for your help.

Context: I am a trader and I have a base that tracks trades that I take. I can take many trades on one day. I am attempting to create daily reports for myself, and have created an automation to add trade to my daily report. However, whenever I add a new trade (record created) and the automation runs, it deletes any other trades previously added to that day. Anyone know what I should look at to fix?

I have a table with records with two fields, 'Start Time', and 'End Time'. Both of these are date fields, and need to remain date fields, i.e. they can't become formula fields.The issue is that if 'Start Time' is changed, e.g. I change the day, the 'End Time' field does not update. Is there are way to ensure that the 'End Time' field shifts relative to the 'Start Time' field? Importantly, I don't want this to happen in reverse, e.g. the 'Start Time' field should remain where it is when the 'End Time' field is changed.Hope that all makes sense,Andy

I am fairly new to airtable and have gone back and forth on whether this is an automation or a formula. I would like to create a field where when two conditions are met, it auto numbers. For example, when records have the same "created date" and "account name" this field would auto-number. If there are no records with matching "created date" and "account name" then it would auto-number to 1.   

Greetings, Airtable community!I wanted to reach out to ask for your ideas and assistance with a road block I ran into:I have a Fillout "SignUp" Form that allows clients to schedule themselves for an appointment at the specific appointment time they choose. I've successfully customized Fillout form to show ONLY "unfilled" appointments (based on an Airtable view) when the client loads the form.The problem is that if 3 people load the form at the same time, then they can all 3 "Sign Up" for the exact same appointment. Since they all loaded the form at the same time they have the same options given from Airtable. And since the form doesn't update in "real time" unless they refresh the page, then there's no way to keep them from all 3 selecting the same Appointment time.On the back end, this means I received 3 SignUps for the same appointment and a "Something Went Wrong..." email from Airtable. I then need to manually go back and remove the extra signups and have 2 of th

I have a project table and a client table. I need to use automations to have the client related information auto populate into the projects table. I have created a very basic example to show what I am trying to do but the real situation is way more complex with hundreds of rows and we are unable to use the linked field type to do this without a huge amount of effort. Since the client name is a common and unique value between both tables my understanding is there is a way to use automation to populate the information in the project table with the corresponding information (Notes and Status) from the Client table. The Trigger and Find Records action do as I expect but I keep getting an error with the Update record action and am unsure of what to do to fix this issue.            

Hello everybody,I would like to add the date and topic in the body of the message that will go to the email, reminding the person to do the work for the day DD/MM/YYYY.

Hi I wan't to create automation where:1. when the record is created in table "Base"2 find record in table "Mollie" with conditions (Mollie - column "Date" is the same as Base column "Date")3 update record in table Mollie column LOGO with data from Base column LOGO but i cant find the right condition - i can't compare two fields with the date type record.Can you help me?

I haven't been able to figure out how to pick a specific value from a synced field when I have a form submitted.  (Aka I want to set several fields specific values)I have a form that I have created for adding a new event for the Virtual event team.  Since I know several of the standard fields, I am auto populating them on submission; The Program Team (HHH) TIJP Type - Program.But I can't get any values for State to show.  It is a Linked Field from the Sync table (States)in the Events Base.  What am I missing here to get the value like I have in the two other fields to populate on submission?     

Hello! I have been using Airtable for a long time, with a Zapier integration, and ran into some issues recently that I hope someone can help me solve. I am using Airtable to collect appointments. The client's appointment time triggers Zapier to send an email reminder the day before at 9am.  This happens when the appointment moves into the "Reminded" view, using the filter to only show appointments that are scheduled for tomorrow. Since this would trigger to send the email at midnight the day before, I had to add a delay of 9 hours, to make this properly send in Zapier at 9am. Essentially, the day before an appointment at 9am, I want to send an email to the appointment subject to remind them.This worked properly for a couple of years, but suddenly the emails would go out all different times. I investigated this, and found that Airtable moving appointments into the view at inconsistent times were likely the culprit. That said, I want to build something better, that doesn't

Hi.  It's my first day. I'm trying to create a maintenance log for my laundromat. I created a base with the following tables: Washers, Dryers, Maintenance Requests.  The Maintenance Request table is populated by a form I created for my staff to request maintenance. On it I created a field called 'Machine Type' where you select washer or dryer. The next field is 'Machine ID' and if you select washer under 'Machine Type' I'd like it to give a drop down menu showing the Machine ID's from the 'Washers' table and if you select 'Dryer' I'd like it to pull the machine ID's from the 'Dryers' table.  Can I do this?

I would like to set up an automation so that every Monday at 7am, any checks under my "completed this week" checkbox field will reset and be unchecked again. How can I do this? I have tried a few things and continue to get input errors. Step-by-step instructions (As I am a beginner!) would be very helpful. Thank you SO much!   

I am trying to learn to use automations to update 2 summary tables so I do not have to keep copying and pasting every time I update a table.Table for new record:  Donations.  Summary Table: Donation Totals Yearly Summary Report.The two table are linked by the Donation Date primary field in the Donations table. The summary table linked field is called Donation Table.Let me summarize what I think I need to do to accomplish this. I need to create a trigger that says When a Record is Created in the Donations table. This tests fine.Then when I create that record in the donations table I need to have an action happen. I have chosen the Update Record in the action. That action is to update the Donation Totals Yearly Summary Report table/Donation Table field with the contents of the Donation Date field in the Donations table. To do that I need to choose the Update record choice in the Action type field of the automations screen. Then choose the Table in the configuration section

Just yesterday my automation set up to send a text out through Twilio stopped finding the phone number and putting it in the TO field (see image).Here is what I have already tried:I verified that the user had a number in the field of the failed automation. I made a new field that added the Country code to the phone number and selected that field value (at least I think since I didn't see the "Value" image appear where the last one was.I don't know what else to try. Suggestion please!Thank you

Hi,I am trying to figure out a way to copy data from one record to another in the same table. In the example Ordrenummer primær should be the key and I want Navn and Mail from the record with values to be copied to other records with the same value in Ordrenummer primær.Thanks for your help./Michael   

Hi all,Firstly, apologies if this has been asked / answered before, I had a search through and couldn't find it.I'd like to import a number from an external website and automatically update it when it changes.  Also would I need their permission for this?The website is transfermarkt.com it gives an estimated market value for individual football / soccer players.  I have a database of players, and I'd like the estimated value for each one in a column.Is this possible?Many thanks in advance Barry

Hey all,I recently needed to switch an email automation from "Send email" to "Outlook email," to fix a spam filter problem. Previously, when it was being sent as "Send email," a link at the bottom of the email led all recipients to the record detail view of the submitted record on a particular interface - even though interface links are not currently insertable, and I had to assemble the link myself, it still worked fine.They look like this in the Automation message body, where the parenthetical is the inserted dynamic record ID:https://airtable.com/appxxxxxxxxx/pagxxxxxxxxx/(AirtableRecordID) But now, with the Outlook email automation, the links are broken. Something in the chain is adding two BOM bytes into the link, so it goes to this link instead:https://airtable.com/appxxxxxxxxx/pagxxxxxxxxx/%uFEFF%uFEFFAirtableRecordID Is there a fix for this, or something I'm missing? The only other thing to note is my org uses urldefense, which wrapped the links when the automations were s

I have created a fillout for a registration form. I have a table of people I am inviting, and would like add the fillout button to an email so that most information is pre-filled, and then the registration info updates in the existing line in the table.Please see below - the token is not working - either inserting a formula field or using the button field in the database. Can you help me correct this please to add into my automated email?<a href="(token)" style="background-color: #4CAF50; color: white; padding: 10px 20px; text-align: center; text-decoration: none; display: inline-block; border-radius: 5px;"> Register Here </a> 

I tried to create an automation within Airtable's automations in a trigger that matches a condition,and the action to update a field in a record, which is linked to the trigger's record, but I get an answer that the record of the linked recordis not foundWhat did I do wrong?Attaching a photo.https://airtable.com/invite/l?inviteId=inv93POmHoU5Kla4z&inviteToken=6e1aac633bc71d476a2130dac08e0ce26f3343359e4eae2d6536f033b082b60d&utm_medium=email&utm_source=product_team&utm_content=transactional-alerts

Hi All!I have about 10k records in my airtable base, and each have a specific link to a webpage that I regularly check for certain data.  I would love to be able to scrape those pages for the info needed and automatically put it into AT.  Is this possible?  I assume I will have to run a script of some sort, but don't know exactly how to go about that. We are currently updating the 10k records manually, and using some sort of AI would save SO much time!TIA!

I'm sure there is a way to do this, I just can't think of the way the write the "logic" for it in automations... Hopefully someone can help me understand 🙂 My rows have a date as the primary field. I have a long text field columns called "Notes for next training" and "Notes from last training". When I create a new row (new date), I'd like the text from "next training" of the most recent date (in the past) to be copy/pasted/imported into the "last training" column in the new entry.I did it manually for this screenshot, just to illustrate what I would like to happen automatically. 

I cannot use the " Run Script " function under the Automation Tab, even when the team's plan is activated. It's asking me to upgrade to a Business Plan. Please help

I am trying to create an automation that updates a record when certain conditions are met:Let's say I am evaluating my retail inventory and want to identify inventory boxes requiring certain follow up tasks: I created a Box Flags field to aggregate a few different record fields into 2 flags: boxes that need to be replaced, and boxes that need their contents separated. I have created an automation to update records for the first flag, but am struggling with the conditions for the second. I only want the "separate contents" flag on boxes with more than one field value. "Has any of" retrieves all boxes, "has all of" requires a tedious number of conditions to capture every combo of values, "is exactly" and "is/is not empty" don't apply. In other apps I've worked in, I could write a condition like Box Contents contains A,B,C,D,E AND (Box Contents is not equal to A OR Box Contents is not equal to B OR...) to filter out the single value records, but I can't seem to wrangle thes

Hello,So I basically have a table for candidates and a table for job adverts. I have a make.com automation set up that when a candidate applies to one of my job adverts it automatically feeds them into my candidates airtable and will also create a new record in my job advert table if one doesn't already exist (first person who applies for the job). I am running this for 3 different offices each with its own make.com scenario to distinguish which office they are applying for. It will automatically feed the candidate into the candidate table and adds the correct office field that it is linked to.Where I am having the issue is I also want it to update the job advert office field automatically. It seems that it cannot be done within a make.com module. I was wondering how I can set up an automation so that when a job record is created it will find the candidates record that triggered the creation of that job advert and grab the office that candidate is linked to and automatically feed