Automations

I am trying to create an automation that adds a multiple select item to a field but I don’t want to replace it with what exists. For example, if “Troop” already existed in that column, I want to add “Cookie” so that the multiple select field reads “Troop” “Cookie”. Currently the automation replaces everything that exists so when I run the automation, it simply says “Cookie”. Any advice?

Hello Airtable community,In my usage of Airtable, I extremely often find myself wanting to rerun failed automations after fixing some issues in scripts, but at the moment the rerun button only offers rerunning in the previous state of the automation.And the suggestion in the support documentation doesn't apply to my case as this often happens in cases when the trigger is a webhook. And rerunning things then is quite complex and time consuming...I'm therefore wondering whether anyone had insights on some upcoming option on Airtable automations to support rerunning using the new state of the automation, if others share the same troubles, or if the Airtable  team could share their viewpoint on that feature request.Thanks!BC

I suddenly can't add multiple sync sources to my table.I'm on a business plan I have under 20 sources syncing to my table. Does anyone know what that might be the case? I can do it in other bases.I can add other sources in other bases: 

i will be as spesific as i can with the intention and infomation i'm gathering:At a scheduled time, every day at 8am, i will run a script.This script below here fetches the JSON i need. (example: https://data.brreg.no/enhetsregisteret/api/enheter?)This is the output of the console.log so i know it works:As you see, each object under the "enheter" array represents a company.I want the automation to create records based on each object and fill it with the infomation given there. Anyone willing to help me here? &

I have a table in my online portal with a hidden multi-select "filters" field that is only accessible via a dropdown menu but not visible on the actual table. I want to create an automation that triggers when my existing records (or newly created ones) matches the conditions I setup."If Field1 is none of ... and Field2 has any of ... update record FilterField with 2 filter options"The problem I'm running into is that existing records aren't updated, only newly created or updated ones. Of those newly created/updated records, it overwrites existing options selected in FilterField so instead of adding a 2nd option alongside the 1st one that is already on a record, it overwrites it and only inserts the option with is listed in my automation trigger. I have hundreds of records and it would take too long to do this manually!Thank you.

Hello everyone,I am working on a script where I send invoice data from Airtable to the QR-Invoice API to receive a QR invoice in PDF format. I then want to store this PDF as an attachment in an Airtable table for a specific customer.My goal is to automate the entire process (sending data, receiving the QR invoice, and saving the PDF as an attachment) within a single Airtable script, without the need for another automation tool like Zapier or Integromat. The process I'm envisioning is as follows:Invoice data from Airtable: I fetch the invoice data from an Airtable table.Sending data to QR-Invoice: The data is sent to the QR-Invoice API to receive a QR invoice in PDF format.Saving and linking the PDF: Once I receive the PDF, I want to save it as an attachment in the same Airtable table for the corresponding customer.

Hi guys!!!I am trying to insert an image that I have as an attachment in my database within the body of an automated emailI wanted to ask you if you could help me understand why my HTML image is incorrect. The image appears crashed and I don't understand why. I would greatly appreciate your help.Thank you so much!

I'm creating an online portal to display my tables to users. The online portal I'm using doesn't display linked records on the table so I've had to find a workaround by adding additional fields to display the text from the linked records. I want to be able to create/update linked records field and have it automatically create/update the single select field (which display properly in my portal and has color options). What is the best solution for this?Here's my table setup:USERS (LINK) = linked username records from Usernames tableName (from USERS (LINK)): lookup field to display the username as textUSERS = single select field (this is how I want the usernames to be displayed)What I want:Whenever I update or create a record in USERS (LINK), I want it to automatically translate the

Hey there,First of all I wanna thank anyone who answers, I often come to community for some of my issues and it's always very helpful !So, I want to be able to duplicate in a "dynamic way".I've got a tab "Projects" which is linked to a group of "activities" within another tab. A chosen project has several activities, which are created for each distinct activity day.Activities of the same project share many infos (partner, location, vehicule used ...) but they always differ in terms of date (start date & end date (ie : 12/7/24 2pm & 12/7/24 6pm)Sometimes we have to create 10+ activities for a project, and using the duplicate record function seems suboptimal because we can only do it one by one.So I'd like to know if using automation, extension..., it is possible to create all activities of a project in one click, if you create an activity template and input all the start & end date (where ? idk)Thank you for your

So I am working on automating some workflows to help my team out when they report on projects. I figured one less step they can do is to only update their project stage. There are certain tasks that get automated when moved to a specific stage and I would like to automate the previous Stage's tasks to be marked as completed when they move to the next. I am getting this invalid inputs error and I don't know how to resolve this.  I attached a picture but when using a specific record, this project has two associated tasks with it and I would like it only mark the previous stage's task (Assessment) as completed but it looks like its picking up both. 

Hi allMy base allows users to create both single item and multi items inquiries (There is a parent table for supplier/customer details) and child table (for line item details) and another table for products.If the user is inquiring against a specific product (from products table) then I seem to only be able to create one record within either the child (inquiry items) table or the parent (customer/supplier) tableI want to automatically create a parent record to this child record for these instances. Otherwise let me know if there are other workarounds?Thank you!

Hello, So I have an automation to trigger when a checkbox is checked (in screenshot). It works when I test it, but it's not working on it's own. Meaning, when I add a new record and then at the end I check the checkbox, it doesn't add a new record to the programs calendar. I'm not sure what the issue is. Any help would be appreciated.Take care,YSDT

Hi all,I'm trying to setup an automation that updates a record when an events is scheduled that matches users in the database to confirm that they scheduled and when. I can do this with Zapier but I'm trying to do it directly in Airtable.The main problem is that I need to use Attendees to Find a Record where e-mail contains "guest email" but this field is grayed out and says "No valid nested options".Any ideas / suggestions?

So I'm running into an error that I can't seem to fix. Whenever I try to set a condition based on a linked record or a formula field, I get that an unknown error has occurred.My first table, products, have a linked field to a record inside the main product master where the product's vendor is linked. So I've created a lookup field for the vendor record id and stored it inside my products table. The value for that record is "recSdTazTLqgiGtBb".My second table, Vendor IDs, which contains all of my different Webflow IDs, is also linked to the vendor in the table. Here I get the exact same field value "recSdTazTLqgiGtBb".Now I want to run automation that temporarily puts a webflow ID into my products record that I'm trying to edit. The trigger is an update to the action field, which works fine.The next step is a conditional logic group that asks

Hello everyone,I come to ask for your help. I created a Google calendar event creation automation from Air Table records. Everything was going very well until recently. Unfortunately for a few days, the automation has stopped working and I end up with the following message: "Unable to parse datetime".I saw on the community that this problem came up often but without a real solution. Could someone tell me how to solve this problem?Thank you so much.

Hello,@ScottWorld, after watching one of your videos, I set up a Make scenario to automate a csv export from an Airtable view:I used the CSV "create csv advanced" module and it works fine.My problem is that all fields in the exported csv are surrounded by double quotes:Do you know how I can remove them?Thank youPascal

I'm trying to pull data directly from linked record in an Automation by using the Find Records action with a Condition to match the Record ID which i added to the main record via Lookup field. BUT when I try to reference the Rec ID field it says "no valid nested options"?? I am using the gear icon to match and find the recordIs there some way to lookup a linked record and pull data into Automation directly, ie without adding fields manually to the main record?

I mistakenly clicked 'unsubscribe', and now I can't receive any emails from Airtable Automation (noreply+automations@airtableemail.com). Since my email provider is not a common one like Outlook or Gmail, I don't have the option to add 'Safe senders' or 'domains'. Is there any solution to my problem? Thanks a lot!

We have an Airtable business account – it's our slow season so we're trying to save some money so I'm working on changing up our base design to be more forms-based.One thing I'm curious about though – say I make an interface with a button that triggers an automatic, then I have a user with read-only access and an unpaid account.  I assume that they would not be able to push that button to run the automation, is that accurate?

Hey Airtable community,I've got an automation where I need to create multiple task records when an episode is marked as "received". Here's my setup:Tasks List table: Contains template tasks linked to specific showsEpisodes table: Where I check "received" to trigger automationTasks table: Where new tasks should be createdCurrent automation:Trigger: When "received" is checked in EpisodesFind records: Looks up matching tasks from Tasks List based on showCreate record: Tries to create tasks in Tasks tableProblem: The "Create record" action creates one record with all tasks combined, but I need separate records for each task found. Quick example: The "Tasks list" table has entries for Task List    | Show |Transcode | Show A Show B |Send to A  | Show B |

Hello 👋We are trying to create an automation which allows us to review membership applications before sending invitations or creating membership accounts.We can get the Webflow Form data to Airtable but are struggling with how to get the data into Memberstack 2.0 and have it create membership accounts once approved in Airtable using a status update in the table and then have Memberstack send email invites to approved users.The intended process works as follows:A user fills out a native Webflow Form on the websiteThe form submission triggers a scenario in Make to send the form data to an Airtable BaseAn Airtable Automation triggers an email to notify the team of a new membership applicationThe team review the pending application and approves the submission in Airtable, setting the status to approvedThe newly approved submission is filtered into an approved-only view within the Airtable BaseThis

Hello,I am trying to figure out how to create a form to add attachment to an exciting record.I have a form that updates  any field including attachment in exciting record but problem is it doesn't keep attachments that was there prior.My main idea is to share a form with anyone online so that anyone could only upload files to an existing specified record and not be able deleting files that were uploaded by others.  Thank you.

Hey everyone! I’ve set up an automation in Zapier that sends signed agreements from our service to Airtable. I’ve gotten everything to work as I want it to, but not all of the PDF:s are attached in airtable. I can’t really see a pattern to why the documents wouldn’t show up. From what I can see in the version history of the rows that aren’t, the PDF has been there but then instantly removed. It seems the problem lies with Airtable as the document shows up, but I can’t figure it out. Here’s what it looks like in version history: Any ideas on why the document gets deleted?

HI,  I run a real estate agency and woud love an easy way to create a PDF from images in an attachment field.Basically the way we do inventory is by images and it takes agents too long to drag and drop images into a doc file. Woudl be great if they can upload all images to an attachment field and then the PDF is created with the all the images.  Whats the best way to do this? Preferably free or very cheap. We usually need about 60-100 inventory documents per month. Thank you in advance!

An automation of mine that usually runs fine started throwing this error and failing sporadically. It's for a webhook automation that brings in orders from Shopify. In my attempt to isolate the issue, I've deleted every field from my "Create Record" action, except for Name (single line text) field where I attempt to enter the Customer First & Last name, but it still fails. 🤔 🤔 There are no roll-ups on the table where I'm trying to create the records. There are some formula fields on the table, but I'm not trying to write to those fields. Any ideas? The other threads related to this error message in the community forum did not contain an answer.