Automations

So my goal is to automate image enhancing via form submission.When my table receives the form submission, most of the time, it will receive multiple images ("rawFiles").Once it receives the data, it will send a webhook to Make.com where it all goes through the automation.My issue is "rawFiles" only receives data as a string and not as an array. I would like to pass this data as an array so that my webhook in Make can process it properly.Here's my current script: let inputConfig = input.config(); let webhook = 'https://hook.us1.make.com/s3i0oapoqp08n8wxigxpv7jl826k24lw'; let queryParams = `/?Record ID=${inputConfig.recordID} &Raw Files=${inputConfig.rawFiles}` const returnedPayload = await fetch(`${webhook}${queryParams}`); And attached is a screenshot of my test in Airtable.I'm not good at coding/scripting, so any help or direction will really be appreciated.

I have an Airtable automation that uses the AI module to summarize text fields for each record in a view. A repeating group iterates through that list. In Make, those newly updated records are processed through a Word template to output a report. I'd like to figure out a way to trigger them with one button press.There are three ways I'm aware of for triggering Make, but I can't figure out how to make any of them to work.Webhook doesn't work (I think) because I need it to happen sequentially, with the Airtable automation running first.Record update: my original plan was to update the status of a report record that Make was watching after the Airtable automation looped through the whole list, but it doesn't look like you can add another action after a repeating group. So I also tried a script within the group that would count the loop iterations and compare to the list length, and at the end of the last iteration, would update the record. But I don't think it's possible to save the itera

I know this issue has been discussed before, but there doesn’t seem to have ever been a solution discovered, so I’m bringing it up again in case anyone’s found an answer in the last 1.5 years. The problem: occasionally/often, when an attachment is uploaded to Airtable via a Make.com automation, Airtable will immediately delete the file after upload. In the record history, it will say that the user who created the record also deleted it, but that’s not the case. Here’s a Loom video illustrating. Important notes: I’m using the Share Link Google Drive module to get the share link. The automation itself doesn’t seem to be the issue. Airtable will occasionally keep the attachments, but less often than it seems to delete them. The files being uploaded are all “accepted” file formats, like jpg, pdf, etc. Anyone have any ideas?

  Hi folksI am fairly new to automations so plz excuse my lack of expertise.I am working on an automation that requires copying some data from 1 table into another table in certain circimstances.One of the columns (DISCONNECT_PROMPT) is of single select type - both in the source table as well as destination table.I am using the below code to insert the data but the it fails when the single select column is empty/blank in the source table.Can you please help me identify a way to insert a nothing if the source field is empty?Thanks in advance await tabChangeHistoryLog.createRecordAsync({ 'ROUTING_PROFILE': airTableKey, 'PRIMARY_Q (Mandatory)': strPRIMARY_Q, 'PREFERRED_ROUTING_ELLIGIBLE (Mandatory)': {name: airTableRecord?.getCellValueAsString("PREFERRED_ROUTING_ELLIGIBLE (Mandatory)") || "TRUE"}, 'PREFERED_AGENT_SCORE (Optional)': intPREFERRED_AGENT_SCORE, 'LC_EXPIRATION_THRESHOLD (Optional)': intLC_EXPIRATION_THRESHOLD, 'IN_Q_REFRESH_RATE_IN_SECONDS (Mandatory)': intIN_Q_

I am working on a form that has conditions. For example, if a person is filling out the form and they have 3 options1. Enhancement Request2. Update3. General SupportIf the person clicks the 'enhancement request' I'd like for that person to be redirected to anothe rform for a different airtable that asks all the questions about enhancements. Thank you for any help!

Hello,I'm using your form as an embedded form in my landing page. I would like to redirect to different URL based on my landing page environment (production, development).Is there a way to do this using window.postMessage() similar to Calendly? https://developer.calendly.com/api-docs/ZG9jOjI3ODM2MTAz-notifying-the-parent-window

Depending on the data inputting into the form, I want to redirect to a specific link. I have three links, depending on the form data I want to be redirected to one of those links. window.location.href = URL and location.href = URL do not work.

I am building a client portal.The journey starts on Fillout where the clients will answer questions based on the service they wantAll the answers will be saved on an within a "Response" table on airtable  I added this Response table to the Softr's client portal template which includes other tables such as Projects, Tasks, Company, Users, etcNow in order to build a new client portal I'd have to manually enter relevant records into such tables, which can be time consumingWhat I'd like to happen is:After grabbing/analysing all the replies within the Response table either have a button or an automation that allows me to pass the relevant data to the different tables egAdd email details to Users tableAdd company names details to Company tableAdd client details to Projects tableIn order to then have pre-populated data for the actual client portal.Hope I am making sense but happy to do a loom video or zoom call if neededThank you all!

Hello fellow automation experts.Need help in updating a filed but this automation has kept me up all night.The senario is simple.I have a task table called " Email Task" where i want to update status of that task from "not started" to "in progress" based on its date.My automation is as followsHere is the condition to find the records:This step is working fine as seen below:now here is what i need help with. do not know what i am doing here but final step wont run.Thank you

I would like to have Airtable email each respondent after a form is submitted showing the form questions and the respondent’s answers. I see how to send a pre-formatted email but not how to include data from the Airtable record and how to create a Google doc which would be fine if I could then get Airtable to email the doc.

I see I can set up an automated email response like “thanks for filling out the form” but ca I set it up to include their responses so they have a copy of what their answers were?

When using a simple Send Email Automation action, it is very easy to insert of "List of Records" and select which fields to show. I have this setup for an automation that is sending a confirmation email when a form is submitted, and I want them to receive a confirmation email with their form submission details integrated into the message. Once those forms are submitted, various other actions are done to a status field to indicate the applications path through our processes. For those applications that are still pending an approval from an outside client, their status is "Still Pending". I would like to create an automation that on a certain date/deadline resends the original message that is sent to the approver. I have built a second automation to trigger on that date, and "Find Records" that are "Still Pending". Once it creates that list, the action should "Repeat for each record" in the list, and send a custom email. I wanted to just duplicate the original message. This wor

Edit:Airtable response: Our engineering team has successfully deployed a fix for this issue (which arose from a recent update to our code) and any automations referencing an attachment should now run as expected without error.It's working again. Thank you all.---Hello.I've been using the Send Email action in automations for more than a year. Always worked great. In the Send Email action, in the Attachments section (Bottom) I selected the column that contained the file, and that file was attached in the email.3 days ago, my automation worked fine. But today, when the automation triggered, there was a problem (An attachment url is disallowed):I already turned off and on the automation, changed the trigger, changed pdf file for jpg, and always the same error.I tried the automation with records that already triggered a few days ago and worked fine (My trigger is a Single select column, so, to trigger it again, I deleted the value in the single select field, and select it again). Same

Hi,I'm looking at abstractifying our e-mail contents to streamline the process. E-mail content is now stored in the automations itself, but I'd like to move it to a dedicated table. Our automations use a fair bit of dynamic content, such as <first name> in the opening line, derived from various "Find Records" steps.I tried to construct the desired e-mail content with a "List of <first name>" token and just copy/paste it to a Long Text field with formatting turned on. Airtable changed the variable to @Unknown and threw an error "Invalid data - you have to refresh the page", and didn't store anything of the pasted text.Is there way to build the whole e-mail content including variables into a template stored in a table?Rgds,Björn

Hi,In our CRM we started with building stuff for a workflow for one customer area, say "nature". Knowing from the beginning there'd later be a need for other areas too, I put a categorising "tag" in place. So we have the leads and some other key data labelled with tags like "nature", "sports", "food" and "music".There are a lot of email automation built in for this workflow. The other areas will largely have the process steps and hence hopefully very close to the same workflow.Starting looking at adding the other three areas to yet only simple email confirmations and reminders (there are more complex automations also) I got a bit stuck. I guess I could build Conditional Logic steps for each of the cases. However, as I now understand it, this would require to also hard code Find Records steps for each case.As there may need to be some updates and other actions too, I'm afraid I'll run out of steps at some point. It also bothers me to hard code all the cases, since there may be more area

Hi Airtable Community,I’m facing a challenge with importing large CSV files (10000+ records) into Airtable and would love some guidance. Specifically, I need to automatically detect and delete duplicate records upon adding or updating via CSV import.Currently, I’m using a script to handle duplicates, but due to Airtable's 30-second execution limit, it times out when processing high-volume data. I’d appreciate any suggestions on:Optimized duplicate detection and deletion methods that can handle large data volumes quickly and efficiently, potentially in batch processing.Alternative automations or built-in Airtable solutions that would automatically identify duplicates at the point of import, or shortly thereafter, to help with overall processing speed and accuracy.If anyone has successfully managed similar high-volume imports or has insights on achieving faster processing, I’d be grateful for your advice!Thanks in advance.

Hey, I want to set up an automation, that will be triggered when the form is submitted and it will send the filled-out information to make.com so I can then use the submitted data in make.com. I couldn't find make.com in the supported apps that are available when setting up automation in Airtable. I also couldn't find the option to create a custom webhook. I saw that some people did it in the community, but I couldn't find how. So, Is there a way to create automation that sends submitted information from airtable to make.com triggered when the form is submitted? 

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

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! 

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 userName let assigneeCollaborator = collaborators.find(coll

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.For instance:Say I have 1 trashcan left in stock

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