Automations

Hi Everyone,Looking for some help with improving an automation that I've used to create a variable amount of records in a child table and link it to the parent table based on inputs in the parent table.  Here is the code that has worked. let parenttbl = base.getTable('ListInfo'); let childtbl = base.getTable('List'); let {parentRecord,newRecordCount} = input.config(); let linkField = childtbl.getField('ListName'); async function createChildrenLinkedRecords() { // Airtable limits batch operations to 50 records or fewer. let maxRecordsPerCall = 50; let newRecords = []; // Part 1: Prepare the new records for (let index = 0; index < newRecordCount; index += 1) { newRecords.push({ fields: { [linkField.id]: [{ id: parentRecord }], }, }); } // Part 2: Perform the record creation operations in batches while (newRecords.length > 0) { await childt

Context Unable to create an automation in Airtable. The path is as follows: An update in the "Sleep" field of Table1 triggers a search for records in Table2 that share a common field (using the "Name" field as the link). The automation then uses a script to update the corresponding records in Table2 with the updated "Sleep" content from Table1 into the Table2 fields, that have the same name, "NewSleep."Automation Path Image Below:My script is producing an error "'recordtoUpdate' is declared but its value is never read.(6133)." I believe what this means is the script doesn't understand or have a value it interprets from Table1 "Sleep" and therefore cannot update the the field of "NewSleep" for the records that have the corresponding name. Script:let records = input

 We're trying to sync a list of contacts in Airtable to my Apple iCloud Contacts using the Make app https://www.make.com/enWe still don't have it working. (although we may be "close" to getting it to work)Are there any other apps or platforms anyone might recommend? (as an alternative to Make?)Thanks!– Bruce

I have an automation that triggers when data in certain fields is updated and outputs it to the console log in JSON. However, I need to get this data into MS SQL via SFTP.What are my options to accomplish this requirement? Thanks in advance for your kindness and help rendered.

Hi there! I have a question about AirTable automations and photos. For our company, our team members fill out a form through AirTable every time they complete a job. There is an automation set up where the answers to the form are emailed to 2 email addresses - the team member who filled out the form, and then a company admin email account. One of the fields in the form is to upload a photo of the job. For a while, the photos were sent as attachments to the email, but that no longer works. Is there any way to either attach or include the photos that are uploaded to the form in the email that is automatically sent with the form answers? I have not been able to figure out a way yet! Thank you!!

GG ☀️New to the community and to Airtable automations After hitting a brick wall all morning - linking the records of '⭐️ Associates'  and '🤝 Clients'  so they update each other when 'Associate' and 'Client' are added to the same row of a field in 'Project ▸ TRACKING' - I now realise I have a new issue, automatically deleting records!i.e. when I delete Client X from Helen the fields remain linked.The current automationwhen Associate, and Client are not emptyupdate Associate table ⬇️   note: to make Record ID be valid I had to selec

I have two Date fields. I need a third field that simply displays the date in the first field unless it's blank, then displays the date in the second field. Here is the formula I'm using: IF({Dev End} = '', {Deadline}, {Dev End}) The formatting options for both Date fields and the Formula field are the same:I'm having two problems. First, the output date in this new Formula field is coming back one day before where it should be. I assume I could just add a day to the result within the formula, but I'm not sure why this happens in the first place. I suspect they have to do with the Time Zone. If I display the time zone, I see GMT, but I can't seem to select my time zone (EDT) unless I also display the time. I'm not interested in the time.

Good afternoon! Tell me how to display the number of records from other tables in one table and then add them up

Sorry if something similar has been posted already - I'm hoping to figure out an automation where when a record on one lable is labled (via checked checkbox) as a primary contact, that record links to the "primary contact" linked record field on a different table. In a perfect world, this could coincide with an automation where if the primary contact changes (a record is unchecked), that record is unlinked, and replaced with the new record.Or - is this possible to do with conditional formatting at all? I can provide screenshots if that would be helpful!Thanks all!

My button works great, and I'm fairly good with automations, but I can't find a solution. I'm guessing the best way is a script, but I always have to find the script code I need online and I can't find anything related. Can anyone point me in the right direction? Thank you.

Hello guys, I need some help in editing the below code to integrate open ai api with airtable directly without any 3rd party tools. is there any way that we can make the script automatically run all records of a column instead of manually selecting each column every time.  const { table, promptField, outputField, openaiApiKey, maxTokensStr, } = input.config({ title: "Connector to OpenAI API - Using text-davinci-003", description: "", items: [ input.config.table("table", { label: "Table", description: "Where your fields are" }), input.config.field("promptField", { parentTable: "table", label: "Prompt Field", description: "Text you want a response to" }), input.config.field("outputField", { parentTable: "table",

This is for exports from a donor database. I have two columns Credit & Debit. Credit is for the donation amount and Debit is for the CC processing fee amount. Debit is a calculated column based on a formula. Each "Donation" (Record) has both credit and debits but I would like to have a separate record for each of them.I.e. 1 Record for John has his donation amount as well as the other misc. columns and 1 Record for his CC fee.I only know the term in PowerBi of unpivoting columns to achieve this. Is there a way to do this in Airtable?

Hey guys, super new to airtable and JS, still trying to figure out how i can embed my script in this first post of mine.I wrote a script that finds the largest number in a field, increments it by one and does some other formatting stuff (add a 'Q-' +(last two digits of the current year)+(current quote #))) then puts it in that same field for the record that triggered the automation. It sorts all records in Ref Max No(formula field to extrapolate a number from our quotes. The formula is as follows:IF({Ref No}, VALUE(RIGHT({Ref No}, 3)), 0)  e.g. Q-23089 turns into 89For some reason it keeps finding the largest number as 572 even though th

Hi guys!Im trying to create an automation that changes a single select field from one option to another. I have a record of a tour which has a start date. I would like to change the field of "Week" to "Last Week" if the start date is before today but not before 1 week ago. It is my understanding that I first have to 'Find Records' before, and then use those records in the Record ID field of the configuration, but it still isnt working! Can anyone help me understand what the issue is? Thank you

Hi,I have two tables:The first one is to manage people who fill in forms and then I want to send them an email with the appropriate PDF training. When they fill in forms they get different "roles" such as Prospect ticket as you can see. It is linked to my second table with the columns programmes and pdf.My second table (programmes) contains the pdf files I want to send themWhat i would like to do is that when on my first table they are for example prospect ticket, they get THE programmes and the pdf associated with the program using an automation. So for example: For Prospect ticket I want ticket and the pdf associated (as it is in the picture), prospect boost get boost and the pdf....I have been trying for a long time this afternoon

I want to create a script that will automatically open links inside of a specified field, search for an element inside of the links ex. another url, and perform an action based on the existence of the element or lack thereof. I want the script to be activated every time that field has another link added to it as I have an automation continuously adding more data to the table and I want the script to keep up. If anybody has any tips on how to create this script it would be greatly appreciated. I got a script from eden ai but I don't know how to code and don't really understand it. Here it is import jsonimport requests# Function to search for specific elements within the links in the Airtable databasedef text_search(api_key, texts, query):headers = {"Authorization": f"Bearer {api_key}"}url = "https://api.edenai.run/v2/text/search"payload = {"providers": "

Hi, I have created a Typeform survey and a Airtable to record all the answer. However, if a user using a same email. It will create a second record with same email. How can I have AirTable filter by email and update records accordingly? Is this achievable? Please look at 1st Survey table. Airtable

Hello. I have 5 tables with the name of the sections, I need to output 2 fields from each table into one common table. Preferably so that they are filled in themselves, every time a new entry is created in one of the sections. Thanks!

I have created an automation with two conditions.The trigger has three conditions.The first conditional action has two more conditions.The second conditional action has two other conditions.Both conditional actions are to send an email, however neither action is generating an email after running for over a week.You can see in the attached screenshot that when I run a test on the first action, there is an error that reads: "The expected group of conditional actions was not selected after evaluating the conditions."Also, further down on the test page, it says the output failed, but it does not indicate why it failed.I'd like some help figuring out why the first action is failing, and why neither action is sending the expected email.  I can only assume that they are related.UPDATE: I believe I figured out the reason why the emails are not sending — the Date fields

Hello, I'm trying to formulate a triggered response, based off the fields value.For invoicing, I want it to send out an email if the record's field value is "Invoiced". I currently have 3 options for this field: Not Invoiced, Paid & Invoiced. IF the operator selects "Invoice" from the drop down of that record - it should automatically send an email to that contact. I have a field in that record as "Billing Contact" and it links to the customers DB table. I also have the PDF attached to this record as an extension for the customer to see once emailed. Any way I'm able to go about formulating a triggered response in automations?Thanks

I want to send an automated email that includes a formula field/token (it is called "6-month historical average"), formatted to 0.1 decimal place (this formula calculates an avg of the numeric values in 6 other fields, all of which are to 0.1 decimal place).Although the "6-month historical average" field is formatted to 0.1 decimal place, when I test the automation, this value always appears with a long string of decimal places e.g. instead of 4.6 it will show as 4.6437449559. Why is this happening?! I want the historical average to show with only 0.1 decimal place.  Thanks for your advice!

Hello everyone,I would like to run an automation to keep track of the previous values of a cell so that I can see how inventory is being withdrawn from the database and have a correct running tally of inventory items.Currently my airtable is set up like this.The quantity removed field is constantly updated as product is removed. I would like to have the sum or some record of all the values ever written into this field in the previously removed field. I have tried formulas but I keep running into circular references. Therefore I am trying to create an automation which will add the new the new value entered to the quantity removed field to the previously removed field value.For example: on the first day Quantity removed is entered from softr and now has the value 15 for a particular product. Therefore previously removed should be 15. On the

I am trying to create an automation that updates all records in a table at a specific interval. The automation needs to look a single select field and based on what it is set to update another single select field.The automation works when the trigger is update or create, but the time interval trigger is eluding me.The automation is set to run every 15 minutes, and it looks for specific records. But How do we tell it to update individual records from the list it found?

Hi there. I have a event table full of info for scheduling a bunch of different types of "events."One of the pieces of data is the frequency these events need to occur in weeks. So some happen every week, some happen every 2, some every 4 weeks, etc.In a planning table, that assigns specific information to each instance of the event (primarily location), there is look up fields for the event table info, and look up field to a location table. Since all the events have different frequencies, I would like to automate the creating of the next events somewhat. Is that possible? So if I create "Event 1" assigned to "location 1" on the 1st of July 2023, and "event 1" repeats every week, can I have it automatically create "event 2" on 8th of July 2023? This could ideally b

I want to send an email every day at 12:00 p.m. to each record that matches a specific criteria. Trigger: At a scheduled time Actions 1: Find Records Actions 2: Send Gmail When I run the application with the above settings, the email addresses of the target users are included in the cc and the email is sent all at once. How can I send each email individually?