Automations

Hi, I am trying to get selectRecordsAsync() to work. I looked up some older posts here and know that the old version was depricated I have to add an array of the field values, however it's still not working.Here is my code:async function updateCompanyDomains() {   let table = base.getTable("MyTableName");   let queryResult = await table.selectRecordsAsync({fields: table.fields})} Script runs through without an error, but it queryResult remains empty. If I put a console log

I am a bit confused. This might not be complicated. I have two ppl submitting a form and I want to be able merge some of the data. How would I do that? Can I use an automation to update one of the records? But then, how do I match the two entries so it knows what to merge?

Hello, I have an automation that is being run when a webhook is received. I have noticed that the automation is being run multiple times for some records; it does not run multiple times for every webhook. I cannot manually recreate this issue. When I manually send a record, it works as intended. I have reviewed the logs of the booking service sending the webhook, and only a single webhook is being sent each time. But, when I review the automation history, every once in a while it is running 5 times. Every time that it runs incorrectly, it is 5 times.Any thoughts?My automation in question can be viewed below: Webhook Received from booking website. Booking data contains booking information and a customer ID.Booking is created with booking data.Script takes customer ID, and makes an API call to booking site to obtain customer information.Find step to search Customers table for customer ID.If customer not fou

When inserting a Date field in an Email Action, the Date and Time format I’ve set within the table does not get used. Instead, I get the default formatting, something like: 2020-06-07T01:00:00.000Z. I’d like the date and time to be outputted in a more readable format in emails, something like 6/7/2020 at 1:00am.

Super simple question...I have an email action automation that runs when certain conditions are met.  I need to update a date field (excluding time) when this automation runs.  There isn't an obvious answer to this in the forums.  Any ideas?

I have a summary table that is comprised of a single row with a linked field (projects) containing multiple values, then a series of rollups with $ calculations based on project status back in the project table.I would like to automate the addition of new projects to the summary table linked field when projects are created in the primary table, and also automate the deletion of those linked field values when projects are completed.I'm unsure how to best accomplish this in an automation. Are there any suggestions?

When we enter a listing name in one table, the same listing should automatically appear in another table. We set an automation, but when we enter the listing name in one table, that same listing should go to another table. But filed is creating in another table, but the data is coming to that table.Help us here!

Hello! My company may be no longer allowed to use Zapier so I'm trying to figure out how to recreate my Zap using Airtable automations. I need to be able to upload a batch of image files somewhere (our company uses Box), have Airtable match the filenames of the images to existing records, and upload that image file to the attachment field for the matching record. I've seen posts about bulk uploading images to new records but can't find specific info about matching images to existing records. Is this possible?

Hey all,I am trying to use the 'search records' module in make to search for a record in Airtable based on an email field (see below).The error I am getting is: [422] Invalid request: parameter validation failed. Check your request data.I feel like I've tried every iteration of structuring the formula (with and without ' ' or " ") with no luck. 

Hello! I share my Airtable calendar view to my Google calendar so that I can see dates for different clients. A few days ago, I changed a date for a few projects and they're not reflecting on my Google calendar. I've refreshed and unselected the "Sync" button on my Google calendar app and it's still showing the old dates.  Do you know why this is happening? The dates that are showing in Airtable, I need them to show on my Google calendar correctly.

I am trying to use Zapier to publish airtable records as cards on Miro. It works fine, but the link back to Airtable is broken. Zapier needs the record URL and it's not being made available. I wondered if I could work around this by making the record of the URL a field in the record, so that Zapier can use it. Is this possible? Any tops would be much appreciated!

Hi! I have two related tables - Challenges and Services.In Challenges I have records with sports challenges and their characteristics - e.g. ID number, name, months in which they take place, pricing. For every challenge I should have a service(s) (e.g. organizing the event / creating promo materials) in a Service table.I created an automation, which should work like this:1. Trigger: A new record is created in the Challenges table2. Condition: If in the newly created record (challenge) "Pricing" field is "Standard Pricing 2023" -> the automation should continue, if not -> nothing should happen3. Action: If the above condition is met, the action is to create a new record (service) in the Services table for EACH month of the challenge.The "Months of the challenge" field is a multiple select field in Challenges table, where you can select

Hey there! I have created an automation on my Airtable to send an SMS to my customer when they made a purchase. My customers are 2 tables : on the "Users" table and on the "Clients" table. I have their telephone numbers and also a formula field to convert their number in the French standard format : "+33678332729"When I type manually a telephone number on the field 'TO', the automation works and the SMS is well send. But, when I choose my specific formula field with the French standard format, It takes the source of the data (0678332729) and not the content (+33678332729)Here is some screenshot in attachment. Thank you in advance for your help!Seren

Here's the challenge I need to find a solution for. I have a table of "Orders" placed by Girl Scouts in my troop. Their orders are for Girl Scout cookies they've sold.There are 9 possible cookies someone can order, and there's a number column for each cookie that contains how many packages they are ordering.Say an order comes for 3 Adventurefuls, 0 Lemonups, 4 Trefoils, and 10 Thin Mints, and 0 of the remaining cookies Do-Si-Dos, Samoas, Tagalongs, Toffeetastics, and smores.  I need to create a record in another table, called Order Lines, for EACH cookie they ordered. In this case, I'd need 3 new records in the Order Lines table: Order Line 1: Adventurefuls, quantity 3Order Line 2: Trefoils, qty 4Order Line 3: Thin Mints, qty 10How do I create an automation that will create as many order line records as I have cookies ordered? Looping could work if I knew how to create a list of the cookies where quantity >0 and thei

Hi there! I have a table containing my product in airtable. Also, my products on my website that build on WordPress. How I can update my product status on WordPress based on availability in my airtable base using Integromat?

I'm trying to update a field name in a table using the script below, but getting this error: "Cannot update field name from scripting automation at main on line 22".  Has anyone else run into this problem?  let table = base.getTable("tblxxxxxx");let field1 = table.getField("fldrxxxxx");let today = new Date();let quarter = Math.floor((today.getMonth

posting on Facebook date and time from my table doesnt get me the same format on the post (2020-12-17T06:00:00.00)this is the outputthis is my input 

Hi, I need help on the automation that I'm currently building. The section where it says "From name" on the Airtable Automations is not working. The email being sent is still the actual email address used, I want it to be the exact name of a person and I have linked the value on the section correctly, but still I'm having issues.. Hope you guys can help me figure out. Thanks in advance!

Hello, I need some help to find a solution for this task:I have two tables, on contain a columns called small, tall and month. The second table contains the columns small_december and tall_december.I need to write a script that looks for the record month of the first table and names of the columns if they contain the word, in this case December. if the condition matches the data will be copy from table 1 and bring it for table 2. 

Hi everybody!I managed to sent emails from linked table. But now I ran into a problem. I have two linked tables, one for RMA requests from customers and another for a list of repairers with their emails. When I want to send a product to the selected repairer, I want it to be sent to an email that is entered in another table of repairers. This works, but many times it sends the same email to other emails that are in the same table (so it sends an email to the entire list of all emails in this table). When I was working on automation, I used lookup field of the email address of the srepairer from the second table and sent the email from the first table (customer requests, because it is related to a specific product and customer). In the automation for the "to" field, there is no way I can select anything other than a "list" of emails.. could this be the cause of my problem?

I have two tables that are linked to each other: Candidate Table and Position TableEach candidate record has contact information (email) and is linked to a specific position record which also means that each position record may be linked to multiple candidate records. Each position record also has a status: Active, On Hold, Lost, etc.I would like to be able to send automated emails to all candidates linked to a position that has changed its status from Active to On Hold to update them on what's going on. What would be the best way to go about this automation?

Hi all,I am curious to learn more about what linked and un-linked data can be used in the 'Find Records' action in Automations. This happens frequently, and I am fairly sure that it is related to field data types. Linked record fields can only be used in certain instances, and lookup fields can only be used in others. Sometimes I have had to create 'String' fields through formulae to lookup other records. My ask: does anyone have any links to learning resources or documentation where i can learn what the limitations/benefits of certain field types are. We are managing the database through a front-end, and no fields are updated manually, so the vagaries of these data types and their capacity/limitations is quite a challenge!An example of my issue is included in the screenshots attached:For reference, I am working with 5 tables:

I'm working on a project involving the 'Schedule Campaign' table in Airtable and need advice on implementing a specific logic.Problem Statement:In the 'Schedule Campaign' table, users can add an investor and link multiple startups. This data is then used to create a Mailchimp campaign based on a template that only accommodates data for up to 6 startups. The challenge is ensuring that no more than 6 startups are added per campaign, as the system currently allows adding more linked records than needed.Current Ideas:1) UI Prompt: Add a text note in the Interface requesting users to add only 6 startups. However, this relies on user compliance and doesn't prevent the addition of more records.2) Airtable Automation Script: Implement a script to check each row for more than 6 linked startups. Excess startups would be moved to a new row with duplicated investor details. This approach involves scripting, which deviates from a pure no-code solution.3) Ma

Hello,I want to make an automation to send an email at a specific time. When I choose the trigger "at a scheduled time" and go to write the message of the email, I can write a message, but I cannot input any data from the base. When I click on the blue plus sign in the upper right corner, the only options are "actual trigger time," "expected trigger time," and "next trigger time" (pictured below). How can I pull data from the base, such as "dear [insert name]"?Thank you.  

Hello everyone, Please I need your help I would like to send out an email with two answering options referenced from my table in my base and the user should just be able to pick one option in the email with just one click and automatically the value are being transmitted into the base directly without opening the form. I don't want any form to be seen after pressing the button I just want it to be submitted automatically.What i have done is to create a form and write a prefill url formular that prefills the form with the option and an extra field that will also be prefilled that works only in the base but when i reference it in the email and preview it doesn't appear at all in the email.Would it be also possible for the form to be submitted automatically once the button is pressed ?I would really appreciate any suggestion or insight Thank you.