Skip to main content

Automations

Ask your questions about Airtable Automations here.

  • 5,190 Topics
  • 16,152 Replies
5190 Topics
L
Lucas_LandtwistParticipating Frequently
asked in Automations
Display error message when failed automation

Hello everyone,I created an automation that sends an email (gmail) at the click of a button. It uses some fields + attachment to create the email:Fields:Email addressSubjectBodyAttachment It works fine but it is very fragile: if one of those fields is empty, the email won’t work and the user won’t know.I set a warning message when clicking the button, it helps, but I’d like something stronger; like during the automation, if any of those fields is empty, to show a popup or error message to the user.I have looked around but cannot find anything like this. Any help?

295
TheTimeSavingCo
T
Terry_TNew Participant
asked in Automations
debugging - "Property 'id' does not exist on type 'string'.(2339)"

I am from a company selling STEM supplies to schools. I have three tables:A “Material List” table with a list of materials we have in inventory An “Activity List” table with a list of our STEM activities. Each activity has a linked record field which is populated with linked records in the “Material List” table   An “Activity Material” junction table with the quantities of each material for each activity listed.  Desired Outcome of the Script:I’ve written a script that is intended to: Retrieve an activity record from the "Activity List" table using a passed record ID, whenever the list of linked Material records is changed. Get the linked materials for that activity. Compare the linked materials with existing records in the "Activity Materials" table. Delete outdated records of materials no longer linked to the activity. Create new records for materials that are newly linked to the activity, including setting the Activity and Material fields with appropriate record references

101
TheTimeSavingCo
B
boppaNew Participant
asked in Automations
Automation to create a note when a tag is added or removed

Hi guys,The easiest explanation of my problem is this:I have an orders table and I have a “Tags” field in that table (multi select) - one of the tags is “Awaiting Payment” When a customer pays, a team member will remove this tag. When this happens, we want to automatically leave a note in our Notes table.We already create notes automatically in other automations so are confident with that part, but the trigger is more of an issue?I’m thinking that maybe I need a “Tags Previous State” field to copy to?Not really sure, I appreciate any insight anyone can offer. 

333
B
W
WanakaShowNew Participant
asked in Automations
Integrating muliple forms

Hi Awesome Airtable folks, I am a fairly competent basic Airtable user - basic integrations and data moving between bases, however not a full coder (so need an easy solution that is easily passed on to others please). I would love your advice on the best approach for this: -We have an event, and we have 2 different H&S forms that we require our various stakeholders to complete. Each area (trade, volunteers etc) has its own base in AirtbaleForm 1 - DeclarationA simple airtable form, no images. Built in Airtable, communicates directly back to base. Worked well last time.Completed by - trade onlyForm 2 - InductionNeeds to contain imagery. This is where we came unstuck last year as Airtable Business doesn’t have imagery in the forms, so we built with an integration in Jotform. This created data and sent it back to the airtable base, but we struggled to integrate it with existing data so had to manually audit it. We also have people attending who will complete this form that we do not h

516
W
M
MadzOBNew Participant
asked in Automations
Linking Request Form to Inventory Status

Hello all!I’m building an inventory database with an associated request form. I have two separate tables - one for full inventory and one for the request. In the request table, I’ve allowed people to link records from the Inventory to a requestor record. What I want to happen is that when an item is added to that requestor record, I want the associated item in the Inventory table to update its status to “Checked Out”.  Can anyone help me logic this one out?  Thank you!

339
M
C
csquared2511New Participant
asked in Automations
Best way to auto-populate linked field from one table to another and then be editable

Hi All.  What’s the best way to set up the automation below—either in Airtable’s native automations or in Make—to reliably populate the linked field with the Trade’s subcontractors (particularly struggling to get the list of record IDs), and avoid reseeding after manual edits?Base: Dupl Construction Project https://airtable.com/invite/l?inviteId=invh3YFKHVkgkcl8h&inviteToken=ebe29e4b636f906f9bde46e9282074acf77e1634caac54dee00c188723eac427&utm_medium=email&utm_source=product_team&utm_content=transactional-alertsThe goal:  when a record is added/updated in the Subcontractor Review table and Related TRADE is set, auto-populate Selected SUBCONTRACTORS (link to Subcontractors, multiple) with all Subcontractors linked to that Trade. It should seed once (only when empty) and remain editable and continue to be linked to the Subcontractor table records to create quote requests from the selected Subcontractors (which may be different to the initial allocation) later.What I’ve tri

332
TheTimeSavingCo
L
Lauren_KampanNew Participant
posted in Automations
Connecting stripe to airtable

Hello I am working to find a way to connect stripe to Airtable. The use case for this is to show when a customer’s account is paid, past due, or cancelled. We have a people base in airtable that is each individual user in our system. Name, company name, emails, etc In stripe we have subscriptions that are paid and automated there. All payments are through this system. Some stripe subscriptions are an ap or accounting email but pay for 10 users in our people base. I have tried zapier but it does not have the ability to connect the two in the way that is needed. I am thinking I need to connect the unique stripe customer Id to the user in airtable. Not sure if this is best done through the stripe meta data. Then I would need a script to connect this meta data to the users in the airtable base.

1425
Andy_Cloke
Z
Zabee PashaNew Participant
asked in Automations
Multiple Record

Is there is way in airtable filling the form by quarter and once it is submitted it should create multiple record as per the quarter.

588
Alexey_Gusev
M
Mohsin_RazaKnown Participant
posted in Automations
How to get LinkedIn URL based on profile name?

I have Airtable base which contains persons name and their job title. I want to retrieve LinkedIn URL of person’s based on their name. How to do that?

1499
philmcp
Drew_Nemer
Drew_NemerKnown Participant
posted in Automations
Best way to integrate LinkedIn to AirTable?

Is there a good method where when I apply to a job in LinkedIn that it would trigger or gather the details of the job--company name, position, date applied, etc. and export/import the data into my AirTable base as part of my job search?  

203
philmcp
S
stevenjo57Participating Frequently
asked in Automations
Click Button to Send SMS to Multiple Numbers of current record

Hello. Thanks for any help on this.Can someone point me to a similar procedure that does the following:After a record is updated:User clicks a button to send a text with information from the updated record A SMS text is sent with this information to a constant, static list of telephone numbers.I’ve looked up several things on Youtube related to this, but they always seem to be too simple for what I’m looking for or too complex.I do use Zapier.  I did create a trial Twilio account.  I don’t mind sending with my own phone, this will only be 4-5 texts per week to 2 or 3 people.Just pointing me to a similar process I think I’ll be able to sort it out.Thank you.

242
TheTimeSavingCo
R
rfuldaNew Participant
asked in Automations
Formatting numbers in currency and percentage in markdown.

I have created an automation that sends an email with text and numbers. The numbers are pulled from two dynamic fields. One field is a percentage and the other field is a currency. However, the percentage and currency formats aren’t making it over to the email (sent by Airtable). Looking for input on how to format the numbers into percentage and USD currency. 

313
Tyler_Thorson
D
dix-hillNew Participant
posted in Automations
How to One-Way sync: AirTable >> Google Sheets

Basically, I want to import a Google Sheet into AirTable then I want to be able to edit fields in AirTable and those fields are automatically updated in the Google Sheet.Thanks for any help!

2464
GavinA
N
nelly91New Participant
asked in Automations
Autofill food-truck permit PDFs from Airtable

Hello community,I’m a coordinator for events around Cleveland, Ohio and we track food truck vendors in Airtable. Each vendor needs to submit a TFSO permit (Temporary Food Service Operation), which is a standardized PDF. Right now we export each record from Airtable and manually fill out the permit PDF, which is repetitive and slow. I just discovered Instafill.ai, an AI PDF form-filling service. They have a case study about automating Michigan STFU permits, which sounds like exactly what we need.Has anyone used Airtable automations to send base data to similar services? Or used Zapier to automate filling PDF permits from Airtable records? Any tips or examples would be a huge help. I can share the blank permit PDF if that’s useful. Thanks!

915
C
R
Ringthebells86New Participant
asked in Automations
When Email is Received Automation Attachments

I have setup an automation so when someone emails a purchase request, it makes a record and notifies me in Airtable, however it doesn’t look like there is away to email an attachment and have it populate the attachment field. Is this possible?

705
ScottWorld
C
CaitlenBergNew Participant
asked in Automations
Best practice for multi-step timekeeping?

I’ve set up a base that tracks a specific team’s incoming trouble Tickets. The main Tickets table has a single-select field for Status, which can be ‘Submitted’, ‘Needs further details’, ‘Queued’, ‘In Progress’, or ‘Done’. I’m now working on reporting and management would like to know the full time it takes for ticket resolution, but also how long a ticket remains in each status before progressing.I can’t decide which of these approaches would be preferable: Have an automation create a new linked record in a Reporting table with a time stamp when a ticket is created, and then create an additional new linked record on the Reporting table for each subsequent Status update. Then I’d need to do a little more work to compile all of the records on the Reporting table that link to each Ticket (I’m assuming via a bunch of rollup fields). I’m hoping that stamp can also include the name of the Status that’s being recorded Have an automation create a new linked record in a Reporting table with a

514
airvues
N
namaste374New Participant
asked in Automations
Make.com integration with Airtable and One Drive

Good afternoon,I am using Make.com to pull information from Airtable, generate a letter/timesheet, save this to One Drive then I need to import it back to Airtable as an attachment. The Make.com syntax is fine (and has been checked by the Make.com support team), and when I run it, there is a fleeting icon of a file appearing in the attachment field on Airtable, but then it disappears and the attachment is not in Airtable. If I run this through Cloud Convert to create a PDF, it works, but there is a 10 second delay in creating then uploading the document, which then means further iterations fail. What I need is for the document to pull in as a PDF directly from One Drive to the attachment field in Airtable. Any help gratefully received. It works fine when I use Google Drive, but I’m trying to avoid this as the company would like me to keep it all on the Microsoft subscription.Thank you, Jane

333
DisraeliGears01
S
SergiiParticipating Frequently
asked in Automations
error 422

I have a base and different tables. I am working on scenario in Make.com. the logic is watch records ( rsvp table), get a record from ( rsvp table), get a record from presentation Topic, search records( Summit speaker), update Summit Speakers, zoho email, search records( affiliate interest) and then update affiliate interest. When I use id it gives me 200 but no field updated it is clear but when I map data from watch records and get a record (rsvp) to update affiliate interest I get an error 422 it says can not fine such collum. But all collums are there, cache was cleaned, reconnecting was done, tried upsert module. Nothing helps I think problem somewhere in Airtable but where? Will be glad to hear any suggestions? Thanks for help.

5112
TheTimeSavingCo
C
CarolineNew Participant
asked in Automations
Updating records from a form

I have a form that someone may fill out multiple times using the same email address. I want to use that email address to update the original record created with the new information (if it is new). Can someone guide me through the automation to do this?

1194
MargeM
Edward White
Edward WhiteNew Participant
asked in Automations
How to fill PDF form with an airtable record

There has got to be an easy way to fill an Adobe PDF form with an Airtable record.It honestly sounds simple to me and I can’t find a solution (so I guess it’s not simple LOL).  I should be able to map fields from airtable to the fields on the existing pdf form and press a button to put the airtable data on the pdf form. Done. I’ve been messing with this for days now looking for a simple solution.  Fillout offers a complex solution and I’m struggling to overcome the learning curve.  Fillout forms are max two columns and it just doesn’t look good to me.  I like the way airtable forms look, the the functionality is limited.  For example why doesn’t a button exist to “SUBMIT and email a formatted copy of the data”? Currently, our staff is using an airtble form to enter data into the table.  Works fine.  But thennnn, someone has to physically enter that data from the airtable table into an existing pdf form.  Very time consuming and mistake prone.  Cut and paste or retype 50 fields.  We dea

1664
MargeM
J
JoacoNew Participant
asked in Automations
How to use Airtable inside a Docusign Maestro workflow?

Hello, I’m trying to use for the firs time a Airtable table inside a Docusign Maestro. At the Airtable workspace I created a table called Clients. Now, using a Docusign Maestro step called “Read from Airtable” I would like to select that table then read the records.A picture where I’m trying to config the step: How to do that? Thank you,Alexandre

263
Taha-Jiruwala
C
CaitlenBergNew Participant
asked in Automations
Prevent underscores from converting to italics in the middle of concatenated field

I’ve set up a marketing base and part of what I’m using it for is creating UTM parameters. There are a few fields that are inputted via form, like campaign name and start date. Each of those has a secondary field in the base where the data from the first is made lowercase, special characters and spaces are removed, etc. Then those reformatted fields are all concatenated together into one field called ‘Calculated UTMs’. As is standard with UTMs, several of those different sections are separated by underscores.I’ve set up an automated email to send these generated UTMs to someone on our GA team, and I’m pulling in the ‘Calculated UTMs’ field, but it’s displaying the final UTMs incorrectly - instead of showing with the underscores, it’s removing them and using them as indicators of where to make the text italicized. The field is also shown in an interface, and the underscores are correct there. I’ve tried using asterisks and backslashes around that field name in my automation, but it’s no

617
C
D
DavidtInspiring
posted in Automations
Automatic Backlinking of Records - Can't get it done

Hi there. I have a table "business partners" with records of type "supplier" and "brand" which are linked between each other. a record of type "supplier" can be linked to multiple records of type "brand" but a brand can only be linked to one supplier. i always want the links to be two way. i.e. if i add the record "Gmail" to the table and link it to the existing record (of the same table) called "Google", i want airtable to automatically identify that there is a missing backlink (ie. record Gmail has "Google" in its "link" field, but record "Google" does not have anything in its link field) and link the record "Google" to "Gmail" automatically. i have an automation that can trigger based on view conditions correctly. i want the automation to trigger, then "find" the linked record (i.e. Google) by ID and then copy whatever existing links are in the "link" field and add "Gmail" to that. However automations refuses to find a record in a table based on the values of a "link" field. ev

184
X
P
Paul_NaraineParticipating Frequently
posted in Automations
Best Practices for Managing User Licenses and Access Governance in Airtable

Question:What are the best practices or automation options in Airtable to manage and proactively govern user licenses and access?Details:We're currently reviewing our Airtable usage to optimize license management and access control. Our goals are:Reduce the number of licenses to under 50 (e.g., a user like Stevie B. currently has two licenses).Convert some Editors to Viewers where appropriate.Remove access for users who no longer need it.Identify unknown users with access and resolve their status.We would also like to develop a governance process to prevent this from being a recurring issue.For now, our model involves each admin monitoring Editor licenses whenever adding a user and reaching out to teammates if any license changes are needed.We’d love to hear:How other teams handle license management efficiently in Airtable.Recommendations for automation or tools to track and alert admins about license usage.Any governance frameworks that have worked for similar access management needs.

653
J
R
rfuldaNew Participant
asked in Automations
Word document automation

What are some good software options for automating generation of word docs using data from a record in Airtable? I would like to be able to trigger the automation in an Airtable interface (as opposed to an extension on the data side).

1566
Mahlab

Badge winners

Show all badges
Terms & Conditions