Automations

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éé).

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

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!

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.Fo

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

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

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

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 // uniqueLandlor

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,

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 e

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 Sessi

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" ev