Automations

Hey Team,Whilst i"m no stranger to formulas I am new to Airtable and would love some help with a project. First an automation where I can enter a number in one table and it will create that number in records in another table. To put it into context, I am a Dog Breeder, I have created a table for my Studs & Dams and also for their Litters (Projects). I have a column in the Projects referring to number of puppies and I want the automation to create Puppy Profiles for each puppy. So if they have four, I want four Puppy Profiles created. The automation I have used so far is "When a record matches condition" in which I have used 'if project name is not empty', and 'if DOB is not empty' then create Puppy Profile but i want to add script so it adds for example '4' records because their are 4 puppies.  Could anyone help me to write my first script? 🙏In my second screenshot I would ideally love for the Project name and DOB to populate as well, I'm still looking into m

Hi,I have a date column (contract end date), two months before this date there is an automation that sends an email to the tenant. The problem is that I'm afraid the automation will send an email at midnight. Is there a possibility that the email will be sent 60 days before the end of the contract at 9 am?Thanks.

Hi,I have two tables, one of tasks and one of tenants.In the table of the tenants I have a column of the end date of the tenant's contract.I want to automate that at the beginning of each month (on the 1st of each month) I will create a RECORD in the table of tasks with the task of renewing the tenant's contract only if the date of the end of the tenant's contract is a month later.For example, if today's date is October 1st, I want to create tasks for each tenant whose contract ends in November.Is it possible?

But I can't figure it out to make this happenIt's a registration form.  We use it for a specific location, every other month.  I'm trying to reduce some of the manual overhead by trying to auto populate each record as it is submitted with the current event - which is a linked field = from a sync table.Problem is - the automation doesn't seem to support this - like it does for select fields.How I am setting it in the form is kludgy Any suggestions - I'm open to hearing them

Hi everyone!I have a form for a warranty claim. Once customer submit it, the data is visible in table "RMA" for approval. I have another table named "customers" ("Stranke" in my language) which is linked to the table RMA and where I have a list of all customers (so that I can quickly see how many request or warranty cases specific customer have). I managed to automate that once the form is submited, it automatically create that customer in the table customer and link it to the RMA table. Now I stumbled upon one problem. If I have the same customer submitting the form multiple times, it always create a new one. So I have duplicated customers. Does anyone know how can I fix this? Thank you!

Hi, I have managed to set up an email automation. But after the email is sent, I want to update the AirTable record with the date and time the email was sent. How do we do this? I did see Kuovonne do this with a custom script in another example. But not sure how to do this for us. @kuovonne Thank you. 

I have an automation set up to add an event to my google calendar. It is working fine except, the end date it shows on the calendar is showing up the day before it ends. I have the events with no time listed because i do not want a specific start and end time for them. When i have the all day box checked in the automation It is showing on the calendar as ending a day earlier. When i make the "all day" under configurations in the automation dynamic and pick the end date it gives the start time and end time as 8AM in google calendar.  Is there a solution for this? Thanks in advance for any help!

Hi there, I have a script that collect a few records in my table, and I'd like to create a repeat action (to send a Slack message to each of these records). I used JSON.stringify to convert my array to a string and the output is something like: ["rec0aFuNHkPzxxx","rec2jGJ33iVxxx", …]When I try to use this script output as a list for my repeat group it says : "No valid nested options". I looked in the doc but haven't found anything about it. Did I miss something ?

Hi, I have a table where I add any investment into a company done. So, each row contains a field which is  linked record that link the investment to a record in table "company".But we can invest several times in one company. So I want to create a view that could display the last investment made for each company. I thought creating a new "single select" field called "active investment?", and having "active" option automatically selected for the latest investment made for a company. But I can't figure out how to do this double condition (having the "company" in the "linked field" and being the earliest date). Does someone know how to do something like this? Thank you,  Have a nice day 

For starters, I’m relatively new to Airtable and this is my first time asking for assistance. Please feel free to explain things to me like a 5 year old. I’m pulling data from multiple sources, Sheets being the main one. I’m looking for help with Airtable’s scripting automation for a field titled Contribution Amount. For context, this is for a freelance project for a company that offers cleaning service subscriptions. There’s three main tables- blocks, Subscribers, and Active Subscriptions (junction block of the first two). Each block has a cleaning Budget (Budget field) that needs to be achieved, subscribers on a block pledge an amount (Pledge Amount field) they are willing and able to pay, pledges are pooled (Total Pledge Rollup field) and the funding threshold (Threshold Milestone field) that the block has achieved is noted. When a block surpasses a funding threshold (Numeric Value of % Threshold field is used here so a percent is not) that value is tallied in the Pledge/Thresh

Hello, for the last few days we noticed that our scheduled per-day automations run on each Update (when we edit scripts and Update automation)Is it expected new behavior?

Hello!I would like your help to solve the following problem:We conducted a survey where people answered questions and received points. Now we need to filter the score value by colorThere are 3 colors for cells, which are colored when the following conditions match:Red: if a person scored a low number of points in 4 categoriesYellow: if there are no red blocks out of 4 and less than 3 green blocksGreen: There are no red blocks, more than two blocks are green out of 4Points: red if scored from 0 to 11 points in each categoryyellow if from 11 to 17 pointsgreen if from 17 to 25 pointsHow can automation be assembled so that colors are assigned automatically based on these formulas? Conditions in coloring are not suitable, since it only looks at 1 condition\Thank you very much in advance for your help

Hi there! I have a big table with business founders, and I’m looking for a method for new records to auto-complete the gender field by searching the same first name in the table and looking up the gender. How can it be done using automation?

Hi all, I'm trying to create an integration between Airtable and Typeform.On typeform, when connecting with Airtable, I can select the base and the table but when I select the table, the matching fields do not appear. (whereas it appears for my other tables).Do you know what can be the issue? Many thanks,

When someone calls through RingCentral and their name, or number match an Airtable record, is there anyway for that record to pop up?

Hello everyone, I work at an NGO and I’m trying to put together a booking system so people from a specific program can set up a meeting with someone from the team through a form. I did everything, but I’m having problems with the Google Calendar automation. It works, but I don’t know why it creates the event two hours later from the time on the date field. I’m guessing this has to do with timezones? but I haven’t been able to figure it out :disappointed_relieved: can someone help me ? Thank you!!

Hi, community! I'm sure you'll be able to give me some ideas to figure out the best way to accomplish what I'm trying to.I have a base with 6 tables: Check-in, Market, Business, Operations, Traction and Finance.Forms with data will arrive in Check-in table. Since is a lot of data for the customer to fill in one time, we had to split fields in 5 forms which collect the real values of customer business and 5 forms collecting projection values.Customer will answer this every month, so we have an Evaluation Month field in every table. Also, and that's one messed up thing, they need customer be able to send data in more than one form. So this would work something like, on first month, customer knows 4 of the 8 questions, he will send a form with these 4 answers; then, when he gets the other 4, he will send another form with the other 4 answers. Please, consider we can't ask our customer to send only one form per month, despite this was the easiest way to solve the problem.After that, we nee

Hey everyone. I have a public URL link that I'm trying to use to upload to an airtable attachment field with airtable scripting. This is my code (the URL is obtained from an API call response): "let existingAttachments = recordA.getCellValue('attachmentsA');let updatedAttachments = existingAttachments ? [...existingAttachments, { filename: fileName, url: responseData.pdf }] : [{ filename: fileName, url: responseData.pdf }];await tableA.updateRecordAsync(recordId, { 'attachmentsA': updatedAttachments});"My issue is that sometimes this works and sometimes it doesn't, without any aparent pattern, and I know that the URL from my API call is always correct. When I go to the airtable record and see the activity it shows me that the attachment was uploaded and deleted, but I don't delete it in my code.Does anyone know how to solve this problem? Thank you! 

Hello all ! im trying to send automated messages to whatsapp when a record is matches conditions. Ive been trying to do it via Twilio, but having a hard time, any suggestions? 

Can anyone figure out why im getting the following? My goal is when a record is updated with a CSV file, I want to convert the CSV file into a list of records that I can then use elsewhere. This is in conjunction with an automation.CONSOLE.LOG"Script started"CONSOLE.LOG"Record ID from input config:"undefinedCONSOLE.ERROR"No record ID provided in input config."CODE BELOW SHOWN BELOWconsole.log('Script started');let tableName = 'Fabrication Package Members';let attachmentFieldName = 'Assembly List';// Function to parse CSV text into an array of objectsfunction parseCSV(csvText) {    const lines = csvText.split('\n');    const headers = lines[0].split(',').map(header => header.trim());    const records = lines.slice(1).map(line => {   &n

Hi. I've bumped into an issue when I want to send an automated email based on a field containing an email address. I've got two fields, one lookup that shows me the email address based on a selection from Email-Committee List. Help articles suggest using this formula -->> CONCATENATE({Committee's email (from Email-Committee List 2)}, "") but when putting --Calculation-- field in the --to-- field in the automation it comes back with the message that "The "To" input is empty" and I don't know what I'm doing wrong there.

Hello, this is an airtable newbie question:I have searched here, watched videos, and am completely failing with the following problem:I want to create an automation that sends a mail to ALL mail addresses contained in table 2 when a data record is added to table 1.I have the trigger, it works, it's simple.In the actions, I only have access to the data of table 1 in the To: field (where the mail addresses should go), not table 2.How can I access the data of table 2 at this point?Does anyone have a comprehensible tip for me?Many thanks in advance for your timeBoris

 Hi there, I hope I'll find a smart head here that will help me tackle this issue. I have two automation working on the same basis, we get an import from G Sheet, there are numbers there and we want to make the specific fields into a unified table, to create a 'clear' view with all crucial data in one place.One automation takes the numbers and places them like it's asked, but the second one keeps on screaming at me "Field cannot accept the provided value: Could not parse number." This is really confusing as there are no operations run on both of them, just simple data, and one works, whereas the other is just being difficult. Any idea what can be causing that? I thought that it just can't do numbers but one works so it's not that, both are done the same way and the issue still occurs. 

Hi Community, Relatively new with Airtable (6 months or so) and struggling to create an automation that in theory seems quite simple, but I've tried everything and can't seem to crack it...ContextI have a table for invoices, where each invoice can be set as either an "Invoice" or "Additional Invoice". the invoices table also has fields called "Original Invoice" (Linked to other records) and "Additional Invoice" (Linked to other records).Desired Automation/ExampleI create a new record in the invoices table (Record B) and set it as an "Additional Invoice", and then, in the "Original Record" field, I link to Record A. (In other words, I am setting that Record B is an "Additional Invoice", and it's "Original Invoice" was Record A) When Record A is linked to Record B as above, I want Record A's "Additional Invoice" field to be populated (linked with) Record B automatically. - Rather than having to go into Record A, and linking it with Record B manually.If anyone could work out the

Hello there, I would like to know how make an automation of daily record updates to the Spreadsheet? I've read some posts in this forum and all of them were asking to use a third party which needs to pay more again. How to do it just in airtable?In my thought, it should be like this- At the end of the day- Check which records are created today- Send every record to spreadsheet- DonePlease help, thank you!