Skip to main content

Automations

Ask your questions about Airtable Automations here.

  • 5,191 Topics
  • 16,173 Replies
5191 Topics
T
Tobias108New Participant
posted in Automations
How to send data to a webhook url?

If a record is updated it would be awesome to sent the data to a webhook url. How would you do that?

243117
H
M
msw_SLPNew Participant
asked in Automations
Locating a specific, dynamic record and updating a field

Hi Airtable gurus,I am trying to create an automation that will locate a specifc record based on the record ID then update the Status field.It would look like this:Trigger: When a webhook is received (an invoice is paid in Stripe) I actually have the webook createdEvent: 1. Locate record (the appointment record that was created based on a Calendly appointment creation), 2. Update that record to reflect that the invoice for that appointment was PAIDI feel like I am close to getting the automation to work, but I can't figure out how to find that appointment record based on the record ID. Any help would be so appreciated! 

81
Eric_L
V
Viades-HNew Participant
posted in Automations
Cloner un enregistrement et ses enregistrements liés

Bonjour,Je suis en train de m’arracher tous les cheveux qui me restent sur un problème que je suis sur le point de résoudre mais je n’arrive pas à trouver le point qui blesse.Pour schématiser :J’ai un enregistrement d’une table COMMANDE, lié a de multiples enregistrements d’une table LIGNE_COMMANDE.(Le truc classique d’un entête de commande avec ses lignes de commandes).Je souhaite pourvoir “Cloner” via l’automatisation (Quand un enregistrement entre dans une vue spécifique par exemple) à la fois les informations contenus dans la table COMMANDE et à la fois le contenu des enregistrements liés de la table LIGNE_COMMANDE.Quand je parle de cloner, je veux bien sûr préciser que c’est une création d’un nouvel enregistrement de COMMANDE (presque à l’identique car il y aura affectation d’un nouveau n° de Cde) et la création de nouveaux enregistrements LIGNE_COMMANDE liés (identiques mais donc rattachés à ce nouvel enregistrement COMMANDE créé).

382
S
J
jonnoNew Participant
asked in Automations
Error: Field "fldxxx" cannot accept the provided value with automation scripting

I have an automation that is triggered when a user clicks a button in an interface. The automation is current set to simply create a new record in the underlying table, and fill in three fields:user = should be the Name of the user who clicked the button. This is a "User" or "Collaborator" field in the underlying table. I have the user who clicks coming into the script using the input variable selector.status = should be "Assigned" which is one of the possible values in the field, which is a single-select field.string = "string is string" this is obviously a placeholder, but this is just a string.Here's my code:  // Get the input variable let inputConfig = input.config(); let userName = inputConfig.userName; // Define the target table let table = base.getTable('Table'); // Get the list of active collaborators in the base let collaborators = base.activeCollaborators; // Find the collaborator object that matches the userName let assigneeCollaborator = collaborators.find(coll

712
J
cvoith
cvoithKnown Participant
posted in Automations
Multiple Email Recipients to find multiple contacts

Hey guys,I am trying to build an automation that finds a contact's record from an To recipients email address from a Outlook: When a new email is received trigger. This works when there's only 1 recipient, but when there's multiple it isn't able to find the contacts with the associated email address. This thread was helpful to pull the first email address from the string when I send the email address to a field and then parse out: https://community.airtable.com/t5/other-questions/extracting-first-email-in-a-field-with-multiple-emails/td-p/48020But my team wants to have all contacts listed on these interactions. Does anyone know how to get airtable natively (we can't use zaiper) to search for multiple email addresses from one field?Thanks!

21
Eric_L
J
Jeff_HladekInspiring
asked in Automations
Airtable is too fast! Help me throttle webhooks.

Okay, a bit of context for clarity.I have a base that I am using for tracking inventory. We send out the packages of items. Sometimes we have some of the items in stock, and sometimes we need to order more before the package is sent. I am using an interface that lets the end user select the items that they want to add to the package. Then they have the option to click a button to trigger an automation.The automation looks in the table and finds all items with a check box. Then, using a repeating group, it send the relvant infromation for each item to Make via a webhook. Make then checks to see if the qty needed is less than or equal to the qty in inventory. If it is, Make creates a new record in an Inventory Change Log table to remove that qty of items from the Inventory table. The problem I am facing is if two items with the same name are sent at the same time, the webhooks are sent to make faster than make can process through them.For instance:Say I have 1 trashcan left in stock

210
Sachin_191
S
sarahjbcNew Participant
posted in Automations
Need help with group by and average on 2 column table

I have a base with a table: Scores that has 2 fields in it. Field 1: TeamName, Field 2: QuizScoreWhat I would like to accomplish is to generate a leaderboard where the Average QuizScore per TeamName is displayed. There may be several TeamName records with differing QuizScores.  I do not want to show the detail records in the Interface. Just the summary records. I'm not sure the best way to do this. I managed to link to table: AvgScores, where I calculate the average. But, I cannot figure out how to do an animation, where when a new record is added to Scores, how to I update AvgScores. The TeamName is created in another application, so, I can control how it is spelled/formatted. So, I can match a field in AvgScores. But, I can't figure out how to do that either. I'm an old SQL hack...

62
S
S
Simon_MalaretNew Participant
posted in Automations
Typescript updateOptionsAsync() error

Hi all,I am trying to update a select field options, as mentioned in the documentation.It would seem that I can not update the options of a selectField within my automation 'Run a script' module.Documentation :Errors :Code:    // Create new entries if necessary const uniqueUpdateOptions = sortedRecords.map(record => record.fields['Price Wave Number'].name); const newOptions = getNewOptions(uniqueUpdateOptions); const selectField = priceWavesTable.getField('Price Wave Number'); await selectField.updateOptionsAsync({ choices: newOptions }) // typescript is not sure this will be of type singleSelectfunction getNewOptions(updateOptions) { // Get the existing options for the "Price Wave Number" field const selectField = priceWavesTable.fields .filter(field => field.name === "Price Wave Number" && field.type === "singleSelect")[0]; if (!selectField) return; const selectFieldOptions = selectField.options?.choices || []; if (!selectFieldOptions)

101
Alexey_Gusev
C
cath123New Participant
posted in Automations
Automation: Linking Multiple Application Records to a Single Personal Info Record

I’m working with two tables in Airtable: "Application Data" and "Personal Info". Here’s the setup:Application Data Table:Contains records for each application a student submits.Students can submit multiple applications, so they may have multiple records in this table.Has a column called "Full Name" (used as a unique identifier to match records in the Personal Info table).Has a checkbox field "Reviewed" to indicate when an application has been reviewed.Has a linked record field called "Personal Info Link" which should connect each application to the corresponding personal info record.Personal Info Table:Contains one unique record per student.Has a "Full Name" column (used as a unique identifier to match records in Application Data).Has a linked record field called "Application Data Link" to link back to all applications a student has submitted.Goal:I want an automation that, when the "Reviewed" box is checked in a record in the Application Data table, automatically links that record to

32
Alexey_Gusev
D
Damien_BASTINInspiring
asked in Automations
Liste de choix dynamique

Bonjour,Je souhaite créer des listes de choix dynamiques. C'est à dire que si je choisi une "Catégorie" dans un menu déroulant, ça limite le choix dans le menu déroulant du champ de la "Sous-catégorie" aux sous-catégories associées à la catégorie sélectionnée.Est-ce bien possible (j'ai trouvé aucun script, même avec chatgpt) ? auquel cas comment ?Je vous remercie pour vos retours, c'est un sujet basique mais récurrent qui me pose problème sur quasiment toutes mes bases...Damien

242
D
L
lp1New Participant
posted in Automations
Automation turned OFF but the automation still ran

I turned off an automation as I wasn't ready for it to run. The automation was set to go off at a certain date. When this date was reached the automation ran even though it was turned OFF. Should automations run if they are turned OFF? 

132
ScottWorld
M
marcuswonderNew Participant
posted in Automations
Script Updating Multi-Select Fields: Cannot accept the provided value

Hi all,Having a really rough time trying to update a (User) record through Script.I am trying to update multiple fields, names and types below:Leads: Linked Field"Source": Multi-Select"Marketing Consent": Multi-Select"Landlord of Properties": Linked Field"UTM Source": Multi-Select"UTM Medium": Multi-Select"UTM Campaign": Multi-SelectI have checked my personal reference, and the scripting docs, and I can't for the life of me figure out what's going on... I have double-checked that the multi-select field options are present before trying to update the record, but my issue highlighted in the issue below:Example Log of Values: Example Multi-Select // uniqueLandlordProperties (2) [Object, Object] 0: Object name: "0001271" 1: Object name: "0001262" Example Linked Field* // "uniqueLandlordLeads" (3) [Object, Object, Object] 0: Object name: "rec3WbJ2Xb3rTpj2q" 1: Object name: "rec9VnDniSERZkyIo" 2: Object name: "recjbDvZZtGh3YCih" *please note that (stupidly), the record Name/

171
TheTimeSavingCo
uitholland
uithollandNew Participant
asked in Automations
Script error linked record

Hi, I want to create a new record and link it with the right assets.Creating the record goes wel, but linking the assets won't work.I get this error. I am a bit new to airtable, maybe it is a beginner mistake.Thanks in advance.Greetings,Robin   const inputData = input.config(); const { txt_name, txt_files } = inputData; // Specify the tables let postsTable = base.getTable('Social media posts'); let assetsTable = base.getTable('Assets'); // Create a new record in the 'Social media posts' table and capture the ID let newRecordId = await postsTable.createRecordAsync({ 'Naam': txt_name, }); // Update the record in 'Assets' where the ID matches txt_files, setting "Social media posts" field to the new record ID await assetsTable.updateRecordAsync(txt_files, { 'Social media posts': [{ id: newRecordId }], });   

53
TheTimeSavingCo
W
Wendy_YelsikInspiring
asked in Automations
Tracking Emails Sent using automation in Airtable

I send emails using Airtables automation.   You can see when an email is sent from inside the automation setup.  Is there a way to put a field in a table that lists the last date an email was sent to easily see email history? 

800
TheTimeSavingCo
T
TonieboschNew Participant
posted in Automations
The To is empty

In my base i have made an automation that sends mail ( gmail) but whatever i tried it keeps giving messag " the To" is empty, there are nog blank fields in the row ( email) i ve made a roll up with the fix ( found on another thread ) .. after days of testing i didnt solve the problem.. can anyone help me please??A link to the loomvid https://www.loom.com/share/d497132a3ddb47c9a6ce93030e103e4b?sid=131789ac-7d4b-4f19-b43c-871452ce6fda  

104
TheTimeSavingCo
R
rbeasonKnown Participant
posted in Automations
Filter Linked records field to text in another field

Struggling to figure this out.  Is there a way to filter the results from a Linked Table so that it only shows items that match a term in another field? In this case, for eLearning Access Code, when you press the + to add a code from this linked table, it should only show values that match what is in the Course field of the table.  Is this possible?  

152
R
M
Martin952New Participant
asked in Automations
Create same record in two tabs

Hi Everyone, I have a base with 3 different tabs. Fist Tab is a Project General where I'm adding new projects. The second Tab is for a specific task (Scanning) and we are creating rows by floors, and it is linked with a specific project. The third tab is for the last task (Modeling), it needs to be tracked by floor as well. I would like to have an automation when a new floor is created in the Scanning tab, create a new record in the modeling tab with the same name, and if it is possible with the same project already linked. Could someone help me with that? Thanks!!!

103
DisraeliGears01
P
pranabgohainNew Participant
asked in Automations
Add Text Input When Others Is Selected

Hi,I am new to Airtable.I am trying to create a simple form. In which, I have a multiple-select field.I want to pop up a text input box, when "Others" is selected from among the choices. How do I achieve that condition?

30
Mike_AutomaticN
S
smf1989New Participant
posted in Automations
How to create records into a new table when the email data table doesn't change?

I am trying to create records to a new table when the email table data table records doesn't change.

92
S
M
mhaulmarkNew Participant
posted in Automations
Update existing record via form without creating new record

Hello, I am trying to update an existing record with a form without it creating a new record.  I have attempted this several times using automation but I am having no luck. Any suggestions?

2634
B
H
HannahSKnown Participant
asked in Automations
Automations to create new records in a new table

I'm a literary agent and I'm trying to create a way to track my submissions of clients work to publishers. I have a client table, a titles table and an editor table. It's tricky to do this in any of these because some editors will see multiple projects and keeping the feedback etc separate is giving me a headache. In the titles base I have an area where I add editors to a list when I've pitched to them and want to put them on my eventual submission list - at the moment this is a linked field with multiple select capability. What I'd like to do is have another table which essentially creates my submission lists and enables me to then go on an record submission dates, responses etc...I've tried to set up an automation so that a new record is created in the tracking table when I add editors to the multiple select field in the titles base so that I end up with a record that is basically TITLE X Editor A and the next field TITLE X Editor C... so that each one will be unique -

3713
H
P
PeezyNew Participant
posted in Automations
Shopify Make Airtable integration

Hey guys!I’m looking for a Shopify+Make+Airtable expert for a little quick project I have…?

102
Théau12
J
JayjayhuiNew Participant
posted in Automations
Automated file uploads upload with wrong filename

I have a script running that has been working well, but 2 days ago it stopped working.Where it used to take a file from 1 column, rename it, and reupload it to a next column, it now:1) Takes the file2) Renames it3) But when it uploads on airtable, the filename becomes a string of gibberish like "70d5b867" and doesn't use the filename I had specificed. The puzzling thing is, in the record edit history I see that the file with the right filename has been uploaded. But when I actually find the file, it's not named right.Here's the script:  // Dynamically retrieve the record ID from input let recordId = input.config().recordId; let table = base.getTable("Agenda"); let record = await table.selectRecordAsync(recordId); // Define an array of sets with their respective WIP tray field, output tray field, and naming format let sets = [ { wipField: 'WIP IF Session Banner (Automated)', outputField: 'IF Session Banner (Automated)', namingFormat: 'if24_session

52
TheTimeSavingCo
B
beebad2New Participant
posted in Automations
Sales Campaign & Email Templates

Looking to create one or more sales email campaigns leveraging email templates. Campaign could be triggered against criteria in a project table.I was thinking the email templates might reside in their own table, potentially with the identified campaign name, subject, body, sequence number, cadence etc.Assume 3 emails in campaign with the cadence as follows: Email 1 sends on startdate, Email 2 startdate+2, Email 3 startdate+5For example, "Campaign Name" = "Lost Deal", "Email Campaign Status" = "Active", "Email Campaign Startdate" = 2024-10-24Project table contains the primary contact name, but no email info. Primary Contact Email address is contained in the contacts table associated with the project. Subject field and Body field along with Campaign Name in "Email Templates" table. Is it possible to reference these fields  and automate sending the 3 emails using the referenced fields on scheduled dates based on their cadence?  

132
TheTimeSavingCo
E
EaglerNew Participant
asked in Automations
Forms

Hi AllI created a form for my drive team.  The form information has start time, end time, etc.  The form information goes into my master spreadsheet.  The team members do not have a paid AT account - Only I do.Is there a way that the information on the form that goes into my spreadsheet could be automatically emailed to the user that submitted the form to me?

123
E

Badge winners

Show all badges
Terms & Conditions