Automations

I have a table in my base where I’m trying to set up a create record automation. I have a few sheets with around 40 fields in each but each one has a core set of 20 fields with identical names, type and formatting. I’m trying to set up an automation so that, when a certain value appears in any of these sheets (in one of the core fields), it creates a new record in a central sheet with the data from those fields carried over. This seems to work fine for free txt/number fields but, when I select a field from the originating table that’s formatted as a drop down, the automation builder makes me pre-choose one of the values from the drop down to populate in the new record. It’s the same with check box formatted fields, it seems to want me to choose whether it should be checked or unchecked in the new record. I just want it to bring through whatever is in the original. Is there any way around this? I’m relatively new to Airtable so I may be missing something fairly b

Is there a way that the greyed out more info tab can be hidden? or atleast not visable only when the type matches with the if statement? i tried something with BLANK() // " " but it did nothing…

I am trying to create a system for giving out registration tickets for a work christmas party. The idea is, have a base that records Full Name, Email & Phone number. Then a form that staff can submit to get a “ticket” to the christmas party. the tickets would be Free, no charge. But we have a limit of 180 people maximum for the party and we need to make sure that every submission includes a COUNTDOWN. So there would be a cell column for “ticket number” and each time the form is submitted, there would be a new ticket number generated, with only a total of 180 tickets available. I have Zapier so can achieve with that, but i’d rather keep it in house with airtable automations. any ideas?

’d like to use the automation action to send the same text to multiple recipients. So, on Friday at 9:00am, send the “Can you volunteer this weekend?” text to everyone in the volunteer table. I’m having trouble formatting the “To” line for multiple numbers. I’m using the “find records” action, and pulling a list into the “To” field and I get the same error message if:1)the field is text and includes +1 2)the field is text and only has 10 digits 3) the field is a phone number. Can I send SMS to multiple numbers using this action? If so, anyone have any ideas about how the data should put in the “To” field?

Hello! Does anyone know if it’s possible in the Airtable/Google Sheets automation to hyperlink one of the fields? Basically, I’d like to enter in the text of one of my columns and then hyperlink it with the record in another column.

I’ve created a table of scheduled trainings called “Schedule.” I’ve also created a “Registration” table that has a form that users can fill out and choose which training from the Schedule they want to register for. I know I can filter out the schedules that have already happened in the Schedule table, but that filter doesn’t carry through to the linked Registration form. How can I hide records on a table and have them be hidden on a linked form?

I have setup an automation to send an email when a record has had changes, but the auto saving of records is so quick that just changing a text field can result it many emails being sent as every character or two when typing, it updates and the email automation kicks in and sends another email. Can anyone think of a field type or setup in automation that can be change so that it only sends one email when a full change has been made to a record? Cheers for any ideas

Hi, I’m a newbie, and I didn’t find an answer yet… I would like to create a form and an automation : every answer to the form creates a visual illustration with all the answers. And I would also like to create graphics with the form’s answers (rating tool). After that I would like to send an automatic email with the visual illustrations. If anyone know how I could do that with Airtable, I would be very grateful. Thank you in advance !

Hi everyone! We’re excited to invite you to try one of our newest features - Twilio Automation Action. With Twilio Automation Action, you can set up automations that send text messages based on triggers related to connected Airtable bases. To sign up for the beta, fill out this quick form and click on the link at the end. The feature should be available within a few minutes of clicking on the link. If it doesn’t, try refreshing the page. Please note that this feature will only work if you’re on a Pro or Enterprise plan. If you are on an Enterprise plan, you’ll need to ask your enterprise admin to also enroll in the beta via the same link and enable the feature from the enterprise admin panel. If you have any feedback about the feature, please submit via

We are working in a Film festival, and it would be fun at the office to have a custom audio clip play whenever we receive a film copy. We have a field called Status Delivery, and would like this to happen when its changed to Received. Can anyone help?

Hello all wonderful AT’ers. Quick question. I have entries in Airtable that Box folders are created off from. 110122 - 203.02-Lighting - Cinematic Fundamentals 5.00 IS there a way to have Box folders created with the above format based on the date and course fields? Of course it’d have to create a main parent folder first of the Client name, THEN the individual date-course folders. I do have integromat/Make(r)?, in case that helps.

Hi, I want to create a new record in another table whenever a field in another record = X. I.e. If we add a record to table A, and within that record, one of the fields is marked as #1, then, a particular record should be added to another table. How is this possible using Airtable? Cheers!

Hello, I am building an automation to create a record when an email is received. Each of these records also need to include an attachment that is received with this email. Is there a way that I can import that attachment into airtable as well.

I’m not having success using Zapier Find Record. Is my Zap Find Search Value query format in Step 4 off? (see screenshots: ZAP query value and AT field value match) AirTable Automation Step 0: send a Slack Message that includes the RecordID (from field with RECORD_ID()) Zapier Steps Step 1: Monitors slack channel for New Messages Step 2: Filters to ensure it is sent by Bot and contains a RecordID Step 3: Formatter extracts the RecordID Step 4: using Formatter OUTPUT value to search the Record_ID() field, but tests return: # Failed to find a record in Airtable. Error from halted execution: Nothing could be found for the search. Thanks for reading, appreciate any assistance!

Hello airtable scripting experts. I am building an automation using a script to update a single select field in a table from a form in another table. For context, this is a CRM, and the form is updating the lead stage after an interaction occurs. I want the updated lead stage in the form to update the single select stage in another table (accounts table). It seems the only way to automate this is through a script in an automation. With some troubleshooting, I’ve written some code to send the ‘NewLeadStage’ to the proper record, but am receiving an error that the field is not accepting the provided value. Can anyone help me troubleshoot my code? See screenshot below:

I have a button that runs a script to select a record in a different table and change a field in that record. Whenever i run it I get a warning: Can’t use record from button field This script is set up to use records in the “Farm Details” table, but was opened from a different table. Is it possible to prevent this warning or edit it in some way as i know the button is running from a different table. Thanks very much!

For the following simple database example: Table called EMPLOYER with the following fields: EmployerName, Employees, Country. Table called EMPLOYEES with the following fields: EmployeeName, Employer, Country. Required AirTable automation: When EMPLOYEE/Country is Empty, copy the EMPLOYER/Country value to the Employees of each EMPLOYER. How would you setup the automation?

Hello! Apologies if this is a repeat question, but from my initial searches in the community threads I haven’t found a great answer as of yet… I have three near-identical automations that are meant to send an email through Gmail to contacts, and they all include a hyperlink to a pre-filled form that was created within Airtable. The difference between the three automations is the language used in the email itself, as they are sent to contacts that are either 1) currently in our database but need to update some of their information, 2) are currently in our database but need to update a lot of their information, or 3) are not currently in our database and would need to complete the pre-filled form from the beginning. I first created the automation for the third group, those contacts that we need brand new information from. I have since sent out the emails via this automation and it looks like 1000+ emails sent correctly, with the hyperlink pre-filled form being pulled in

Hello, i had comisioned some dude on Fiverr to make this script automation for Airtable but he is facing this error and is unable to resolve it, can somebody help out?

So I have 2 bases, let’s say A and B. Table 1 in Base A is synced to Base B. When 2 records with the same name lets say X are created in base A table 1, they enter a view on the synced table on B. When they enter this view an automation runs to create two new records in base B table 2 with the same name (dynamic field value). However when X and X are created in base A, I only want one new record to be created in base B’s table (when the name is exactly the same). What would be the easiest way to have the automation only create 1 new record named X? And it would be a bonus if I could have the new record in base b’s version field number to fill out as 2 when there are 2, 3 when there are 3 records with same name in base A and so on. Thanks!

I have two automated emails that are failing to run. When I test the automations, they work just fine on trigger and action, and the preview loads fine. But when they run, it comes up that the email has no “to” input. The input I’m using for the first automation is the outcome of a formula that finds an email. The other email is two email fields with a comma separating the emails. Help!!

When they say - Image 2022-09-20 at 6.36.31 am - 19th - what they reall mean is 20th lol… well that screwed up my whole follow up strategy lmfao - how do I tell AirTable that all dates are MY dates - Brisbane time! Lol - when it comes to automations - I don’t know what the heck format AirTable is following - but I know I made the automation to send me an email when a record falls into the “current day” - any input much appreciated. Thanks! Edit 1: Because look the automation says when it falls into Today - Image 2022-09-20 at 4.34.12 pm … and the date is… Today! - Image 2022-09-20 at 4.38.04 pm - so why is it coming up one day late? :thinking:

Hi all, I am seeking help with a base that records football data that I am a coach for. I currently have a Base with two tabs. One is for all the players names, positions, address and general emergency contact information. The second tab is the ‘Games’ tab. Here I record the team playing, Date/Time, Location, Type of Game (Tournament/League), Home or away option, who was in the team (Attendance) score and who scored. I am having huge issues trying to get the data to add up the goal scorers when they score more than 1 or 2 goals and how to best record that so it can show a total on an interface. Is there anyone able to help please, happy to jump on a teams call to discuss if this helps. Airtable support are scratching their heads at this one at the moment or would seem to over complicate the system. Thanks in advance

I’ve created a couple of automations using trigger events - if a record is created in Table A, create a new record in Table 1 populating a subset of fields. When I test the automation it works fine. Yet, in practice, it appears to be adding blank rows in Table 1 vs populating the actual data. Any thoughts on how to fix?

Hello, When I use an AirTable form to upload an image attachment via web search , the subsequent image URL does not come with a file extension (e.g. https://dl.airtable.com/.attachments/231bcb7e4fc58c1ddd69fa9f2cf112f2/894c6793/What_animal_welfare_problems_are_associated_with_dog_breeding_… ). This causes issues when I try and use this URL to upload an image into Woocommerce via Integromat. Any suggestions?