Automations

// Async function to process the scoringasync function processScoring() {// Revised scoring guide structureconst scoringGuide = {"Question1": {correct: ["$5,000,000 - $10,000,000", "$10,000,000 - $20,000,000", "$20,000,000 - $50,000,000", "$50,000,000+"],partlycorrect: ["$500,000 - $1,000,000", "1,000,000 - $2,500,000", "2,500,000 - $5,000,000"]},"Question2": {correct: [">500 employees", "350 - 500 employees", "150 - 350 employees"],partlycorrect: ["10 - 50 employees", "50 - 150 employees"]},"Question3": {correct: ["Financial Management, Time Management & Organized", "Construction Estimating, Organized & Risk Management"],partlycorrect: ["Communication Skills, Leadership & Team Building"]},"Question4": {correct: ["Directive", "Democratic", "Commanding", "Pacesetting"],partlycorrect: ["Visionary", "Laissez-faire", "Coaching", "Transactional", "Affiliative", "Transformational"]},"Question5": {correct: ["Client Satisfaction"],partlycorrect: ["Quality Assurance", "Safety Com

I am trying to get set up a task system with sub approval stages that update dynamically if they are done early or late. Check out my video for more details.https://www.loom.com/share/c2033ce26af54a62b5d4cc53c8e3c5ab?sid=bec94e89-54e0-4d89-a231-06bfa8872361

Hello, I have an issue in my company where different departments are sending incorrect clarifications to my department. Now, I want to create a form using Airtable where colleagues can describe their concerns. Once they submit the form, a clarification will be automatically sent to my department in Salesforce (with the correct values). Is this feasible?

Scenario:As a club manager, I need to organize recurring and one-off events with different ticket types. My goal is to use Airtable to input event details, including frequencies, ticket types, and relevant information. To simplify planning and coordination, I want to visualize these events in a calendar view within Airtable.Problem to Solve:How can I efficiently set up Airtable to manage both recurring and one-off events with various ticket types and present them effectively in a user-friendly calendar view? I'm looking for advice on structuring the base, utilizing fields, and best practices to achieve a clear and organized calendar display of upcoming events. Templates or step-by-step instructions would be greatly appreciated. Thank you for your help!

I am very new to airtable and just learning. I am building a base for a company that delivers pet food (B2C). and each record in the base is a client with some specific info like (the date of the first scheduled delivery, the day of the week that deliveries should be made and also if he should have a delivery made every week, every 2 weeks etc. I would like to build a calendar in which I could look any given day and know all the clients I should be delivering that day. Any help helps  I am stuck in how to build the calendar part using the client's info, how to automatically set all the future delivery dates based on the client's info.

I am using a date field to gather reservations. I need to exclude or block the weekends from choice. Anyone know how I can do this?

Happy Holidays! I've read a couple of posts where a solution was provided regarding inserting a logo into a gmail automation and I tried to follow it a few times, with zero success.It's not explained simply to a non-tech person, hence the back-and-forth correspondence between the 'solution provider' and others who were attempting to follow their process.Is there anyone who can explain this to a non-tech person? I have my 'Images' table with attachments field and attachment url field with formulaIF(Attachments, REGEX_EXTRACT(Attachments, "(?:[^(]*\\()([^)]*)")) I also have 1 tag structure and when I enter this into the gmail automation template, nothing comes up. The processseems simple and it's not working. What am I missing?     

I am looking for the best way to query a record from a table and to mark it as Assigned and avoid a different thread of the same automation from picking that row -- something like a select-for-update or distributed locking. In the example below, I don't want 2 simultaneous runs of the automation to pickup gtin3.From what I can find there is no native support for something like this. The best way I can think of is to read an unassigned record and in the next step of the automation to update it as assigned before doing other steps. And later revert it back if the subsequent steps runs into failures. Looking to learn how others might have worked around this.The automation is run in Make.com 

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 after the queryResule line, it's not logged. If I hover over the fields, all the fields of the linked table are shown. For context, in case this could be the root cause: I am in the free trial. Any help is highly appreciated, thanks. 

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 found, create a new customer with the data from the API call. If customer f

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 many months in a format: 24/01, 24/02, 24/03... and for every of this individual month in the newly created challenge a service should be created,

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 their quantities, but I'm not sure how to do that. 

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() + 3) / 3); // Get the current quarterlet year = today.getFullYear();// Calculate the prior quarterlet priorQuarter = quarter - 1;let priorYear = year;if (priorQuarter === 0) {  priorQuarter = 4;  priorYear--;}// Calculate the date for the prior quarter's last daylet priorQuarterLastDay = new Date(priorYear, priorQuarter 

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