Automations

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

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

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? 

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/

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 }], });   

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? 

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  

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?  

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!!!

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?

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

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?

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 -

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

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

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?  

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?

Hello,I am pulling out the few hairs I have left over a problem that I am about to solve, but I can’t find the sticking point. To summarize:I have a record in a COMMANDE table, linked to multiple records in a LIGNE_COMMANDE table. (The classic case of an order header with its order lines).I want to be able to “Clone” via automation (when a record enters a specific view, for example) both the information contained in the COMMANDE table and the content of the linked records in the LIGNE_COMMANDE table.When I say clone, I mean creating a new COMMANDE record (almost identical, as it will have a new order number assigned) and creating new linked LIGNE_COMMANDE records (identical but linked to this newly created COMMANDE record).

Hello Airtable Community:I need help with my automations. I run a tutoring company and I use Airtable to schedule lessons and events.I have two automations in my base - "Cancelled Lesson" and "Cancelled Event". These automations update lesson and event status to "Deleted" so I know when to take action when a student or parent changes times/dates of the lessons.Today I received an email from Airtable stating that I am approaching the limit of my automations, hitting 11,000 runs midway through March! I know this is impossible as I don't have this kind of volume. I look into the Run History and I see that there hundreds of failed runs occuring each day. Clearly this is not correct because parents and tutors only change their schedule once in a while. We may get a handful of changes a day.I look into the trigger for Google Event "when an event is cancelled" and I see that the triggers are based upon all Status: "cancelled" events as identified in the Google API(?). I find out that aut

Hello,I have a schedule table with multiple records that are linked as work to be repeated. When a checkbox is set I want each of these records to be recreated using a repeat group automation. When the automation is complete I would like to send a single email with a summary of all the records created. Currently, it appears that Airtable severely lacks this as a native function to add further automation steps after a repeat group.Thanks!

Hi everyone, we would like to create some script into Airtable in order to integrate in Automation processes and send data (or collect) between Airtable and Shopify. Our need is to use Airtable as backend and send data to Shopify based on some conditions (managed by Automation processes into Air) We have some draft code but my question is if someone has experience to create these Scripts and plugin and activate into Automation.

Hi, I have been trying to do this all day with no luck so I'm hoping someone can save me from my oncoming rage 😂. I have a base with 2 tables, one is a Master List and the other is a Sapphire Customer List.In the Sapphire Customer List I have a single select field for "promo?" which is set to yes or no.  In the Master List I have a multiple select field called "Promo team" with product names as the options. If a record is set to "yes" in the "Promo?" field of the Sapphire Customer List I want the "Promo Team" in the Master List to automatically add "Sapphire" to the field. I have linked both records and have a lookup field in the "Master List" showing the "yes" from the Sapphire Customer List.So basically, if a customer agrees to promo a product, I want to be able to see that for each product they've agreed to in the master list multiple select field. I hope that makes sense! Please help me (Obi Wan Kenobi, you're my only hope) 

Hey, sorry if it's a newbie question but I just can't get this to work. I have 2 tables : one with a list of activites, most of them are repeating so the name is the same but date, participants etc changes. The other table groups activites based on their name so I know for example how many people participated in X activity this month.What I want to do is an automation that adds activity X after it is finished to the other table, in the record which lists all activites of this month for example.I just can't figure out what to put in the configuration fields of the update record step of the automation, I always get "received invalid inputs"Thanks !

I want to create a form with pictures in every question. From what i can see this is not currently an option in airtable forms. What would be the best, ideally free, way to do this? I need the data to end up in Airtable - I know i can build the form in Google Forms, but I am not super tech savy when it comes to automations>Any advice welcome!

 Every line created in the gmail integration adds a paragraph, so when the email is sent, it created huge lines between paragraphs and adds space in between lines. You can see in the inspect tool screenshot attached, it's added <p> without me doing it in HTML inside the extension, so I can't see a way to turn this off. Has anyone had experience with this? I'd also like to add a signature with a photo, but that seems too much to ask at this point! Is there an extension that allows text rich emails? I've spent 4 hours + searching for a solution to this.Things I have tried- Zapier / Make - same clunky HTML email field, and cant seem to insert responsive personalised fields into the email.- Looked for an airtable extension in Gmail- tried to paste the email copy as long text in another table, but can't get responsive fields and it's clunky. Also cant do signature.