Automations

Hi! I've been doing some scripting with the script extension, and managed to get it to a great working state when running manually in my base. I now want to put this in an automation sequence to trigger on a daily schedule. However, when running the script through automation, any API call I try to make is met with a 403 response. I've reached out to the company hosting the APIs I'm trying to call (Aha!), and they seem to believe the call doesn't even reach them (they can see my successful attempts from the manually triggered runs, but no blocked attempts), indicating something is being blocked by Airtable before the fetch call goes out.For example, dumbing it down to a very simple call, the following works in the base when running manually (200 status response with expected JSON response), but fails when running automatically (403 status response, even gives me syntax error for 'unexpected end of JSON input'):  let apiToken = 'WORKING_KEY' let response = await fetch(`https:/

Hi there,It seems a simple thing but I can’t figure out what is wrong…I have sales table and another table for totals by category , I try to make an automation to update the total sum with the new sale I tried to use find records but it returns a list and no matter what I do it tells me I’m giving wrong inputs…if someone can help please 🙏 

Hey there! I’m having this issue when trying to create a record into another table within an automation. I have creator permission in both tables and a paid plan. I’ve tried everything on this link Error in Automations and i’m now figuring out if that last comment is what is happening to me, though that would mean i cant create records if im leaving lookup or linked record field empty. In that case, Is there any way of doing both of them?

I'm having an issue with my automations where the specified conditions are being completely ignored. I have a filter set to only send emails to records where the "60-day group" field is empty. This applies not only for the initial Trigger Conditions, but also every single step. However, the automation is still sending emails to records where this field is clearly not empty.I've double-checked my conditions multiple times and can't find any reason why this would be happening. It's like the conditions I'm setting are just being disregarded. This is also occurring to other fields such as "Automation Test Subject" being checked and Profile Last Updated being more than 180 days ago.Has anyone else experienced this issue of automations ignoring explicit filters? Is there something I'm missing? Any help would be greatly appreciated!

Hi all! Over the past few weeks, I have worked to update and improve my database and have several forms that I currently have “disabled” and put a message with the link to the new form. My problem with that is of course that ideally I would like to improve my user experience by automatically redirecting them to the new form when the page loads.There are a lot of people that have access to the old links and/or won’t update their records. is there a way to accomplish this?

Is it possible to make an automation to send out an email every third Monday of the month? I was only able to find ways to send out the email every certain day or time of the month, but not a specific third weekday. Thank you!

Happy Day to all, can't wait to see the group support for something I'm missing.Info: I have created an automation to post to Facebook. I have trigger set to run once a day, with conditions = 1 based on formula in field.I need help on the Actual Message to post.I hit the blue + and added Copy field and it only posted the actual field ID on the text post.Not the "Contents" of Copy field.I also am getting an error on the attachments field when adding the ContentImage field to send over the "picture".I have scoured through the forums and on youtube, but I seem to be missing one important step of HOW TO ADD to the message content in Actions Section.TLDR: Need help with the Message Section of Post to FB action.

Hi,I was wondering if it is possible to create an automation that uses Airtable's own notification system. We use the interfaces for working all the time and it would be nice if we could get a notification if a certain cell reaches the date of today.

Hi Guys,Our staff submit invoices to airtable page and Airtable generate the form with Xero id however currently Xero submission Id is empty hence please guide us how to sync the data connects with Xero.If there is no direct connection/integration we can find with Xero and Airtable please guide steps to fix it.ThanksRegards,Being

I have a single select drop down field, and use an automation to copy that dropdown field into a linked record field anytime it is updated (see below). I have the system to clients can use the dropdown in forms, but I use the linked record in the backend for my own uses.There are actually two of these, one for Federal and one for State electorates. Each have their own single dropdown field, that automates over to their own linked record field. Both linked records link to the same table, but obviously different columns.However, in the table where the linked records resides that are multiple cases of records with the same name. For instance, there is a Federal electorate called Adelaide AND a state electorate called Adelaide. Each record has a number of other fields (such as state, level of government, etc) and I use the Group function, so that it's clear and easy to not get confused between the identical names.My problem is my automations (from above) cannot tell them apart. Frustrating

Hi,I am running network managing research participants for my organization. They have two options for signing up, which are in separate tables. One is the 'Full Sign Up', which is in my main participant table, where I am linking other information not related to the form. The other is a 'Sign Up Later' form, used when recruiting partipants who don't have time for the full form (fx in person at a conference). They sign up with their name and email and I have created an automation to send out a link with full form. I'd like to create an automation that sends out a reminder email those who have completed the 'Sign Up Later' form, but not completed the 'Full Sign Up' form, to do so. This means I need an automation that removes those who have completed the 'Full Sign Up' form, from the 'Sign Up Later' table, but I am unsure how to do that, since the tables are not linked.  Any help is appreciated 🙂

Hi there, New to AirTable and was wondering if there is a quick way to convert rich tex to html in AirTable. Is there a script that will do that? Or any other solutions? Thanks.

Is there a way to have the Google Doc automation create documents from a pre-existing template? I want to set up the new automation to generate letters, however, I need them to have a specific header and footer. If there was a functionality to select a template that would be great. But if anyone knows of a way to generate that on Google’s App Script end that would be super helpful!

Hi everyone! I am trying to automate a repetitive task to save time for my team, and I'm stuck.Here is what I need this process to look like:Student completes post-course survey (via Airtable form)Data from form populates in Airtable baseData in base is used to create a PDF certificate using Page Designer (native Airtable extension)Automation emails PDF to student to email provided in form.i have figured out how to do everyting above EXCEPT the last step, and I just don't know how to program an automation to send an email with an attachment from page designer based on a record.Please note that I am using an enterprise version of Airtable and ALL third party extensions are disabled. That is non-negotiable, unfortunately.Is there anyone who can help me figure out how to do that last step?Thanks in advance!Jennifer 

I have a form using Fillout that accepts submissions of repair service requests. The results populate a dedicated table and I use an automation to distribute the response data among multiple other tables, such as People and Repairs.When someone submits a request, part of the automation looks to see if the same first name–email address pair exists on a record in the People table. If so, it creates a Repair record and attaches the existing Person record as requestor. Otherwise, it creates a new Person record, then a Repair record, and attaches the new Person record as the requestor.Currently, first part of this is not working at all. It fails tests, logging "Could not find matching rows for string." How can I troubleshoot this?Additionally, when the automation does work, it correctly fills the new Repair record with the existing Person but also removes this Person association from any prior Repairs connected to them. I can't figure out why it does this.How might I proceed? Is there a bet

I have created some automation emails that include a link back to view an interface record, where someone can edit and update it, I have the email set up using the "page record URL" under the "Insert a link" dropdown in the Message box of the automation email.It was all working fine up until the beginning of this year, now when you click the link in the email, it brings me to the interface, but not to the exact record. Furthermore it brings me to the interface and all the information is greyed out, if I physically go into the interface and find the record from there it works fine. But I need it to link directly to the record, which it was doing earlier, and I didn't change anything and it stopped working, for all my bases and interfaces. I've tried on multiple devices and I get the same issue. Wonder if anyone else is having this issue. 

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?