Automations

I want to set an automation that duplicates a record every time the original record is updated to status DONE. But I’m finding trouble. How could I set for TOMORROW the DATE FIELD of the new record created by the automation?

Hi guys I’ve got a quick question as you know the Single Select Order of the View in Kanban Boards is determined by the order of the Single Select. My use case is that I have a copy of my chat from my chat app to in which every single chat have a single select field of the name of the person I’m chatting with so that every board in my kanban board represent a chat window. Now the last piece of the puzzle to make my chat copy automation work is to have a script where it would automatically reorder the order of the single select name as new record of chats come in via API it would have the latest chat on the left side of the kanban board. I’m familiar with javascript but I’m new to airtable scripting & I would like to have some input if single select reordering is possible or not. Thanks!

Hello everyone… I have two tables, the KPI table and the Months table. Each row in the KPI table has a month that is in the Months table. I want every time there is a change in the status column to ‘A’ in the month table, the month column in the KPI table also changes. I have tried to use automation, step 1 ‘when a record is updated’ then step 2 ‘find record’ on KPI table which is stsrec is N and ‘Update records’ KPI table based on automation step 1 but the result failed. Any suggestions on how to create an automation to change multiple rows based on a single row change? Thank you for the response Pic Table KPI Pic Table Months Pic Automation

I want to create an automation that runs on the 2nd and 17th of every month to send each employee a personalized view of their reimbursed expenses that were marked paid for the day before payroll (if they had any). I want to send a link to a view that will only show the expenses that meet that criteria. The link should not be structured in a way that would allow an employee to change something in the URL to see other employee’s expenses.

Trying to build a tracker to keep track of new features being released and which client/groups have been notified of the new feature. Table 1 is called “Features” which will have all new features added. Table 2 is called “Client Groups” which have all the clients added. I ideally want to link Features and Client Groups in a way that every time I add in a new Feature, all of the Client Groups would be nested/grouped beneath on a separate row. Looking like this: Feature 1 Client 1 Client 2 Client 3… Feature 2 Client 1 Client 2 Client 3… That way I can set up columns that I can check off for each client that received a notification of each respective feature Ideally, every time I add in a new feature, that nested grouping of Client Groups beneath would just automatically happen

I have a single base and two tables. Within each table, there’s a linked field that points to records in the other table. For the sake of simplicity, let’s call them: Table A Table B Both tables have many, many linked fields. For example, 1 record in table A has let’s say over 950 linkages to other records in table B. Now, I’m in the process of updating an Automation with a script that updates a single record in table A using the updateRecordAsync() function, like this: await table_A.updateRecordAsync(record_id, { “linked_field_to_records_in_table_B”: array_of_record_ids }); ^ When the array_of_record_ids is small (like between 1 and 5 entries), this call works fine. But as soon as the array_of_record_ids is size 30 or larger, I keep getting these sorts of errors: Error: network timeout at: https://api.airtable.com/v2/bases/app.../tables/tbl.../records/update at main on line 47 I suspect the problem has to do with the fact that Airtable is attempting to update all the back-links from

Hey everybody, big Airtable fan here, we are managing a lot of processes for a concert venue with this awesome tool. Now we’re stuck with the following problem: People send data (some text fields, some attachments) via a form. This information is written into it’s own table (let’s call it “updates”). It can happen, that several people send different data to the same fields, for each submitted form a record is created. From “updates” this data is transferred into our “main table” via Automation UPDATE RECORD on trigger WHEN RECORD IS CREATED. We’ve also built a way to always keep the existing submitted informations if more is submitted to the same field by another form submission. So far so good. Uploaded Attachments can be JPG / PDF or similar, those shall be saved to the “main table” as well in the equivalent field. Now it’s getting tricky. As far as i have read it’s not possible to move the attachments from one table to another with an automation, so instead we are working with URL

Hello Guys ! Trying again, I’ve set up this script founded on this forum ! My goal is to input the company logo automatically when the user puts the website url. The problem is, when the website’s url isn’t recognized, the automation keeps running and running and consumes all the automations :frowning: What can I add to my script to stop the automation run after a minute for example (meaning that the website isn’t recognized) ? Here is the script : console.log( Hello, ${base.name}! ); let table = base.getTable(‘Expériences’); let query = await table.selectRecordsAsync(); for (let record of query.records) { // if the attachment field is empty if(record.getCellValue(‘Logo’) == null && record.getCellValue(‘Site internet’) != null) { let recordId = await table.updateRecordAsync(record, { ‘Logo’: [ { url: ‘[https://logo.clearbit.com/’+record.getCellValue('Site ](https://logo.clearbit.com/’+record.getCellValue('Site) internet’)} ] }) } } Thank for the help Agathe

Hi! I have a script that someone here in the community generously helped me with about a year ago. I’m hoping to extend its capabilities by either triggering it to run via a webhook or an Integromat scenario. I have no coding experience, so I’m hoping someone here could help me figure out how to re-format the script to be able to do this - it is currently written to allow the user to pick a record for each script run via a button field. (unfortunately, the person who built it previously is no longer active) It is a unique numerology script. All things will remain the same, but I hope to be able to “feed” the script the First Name, Middle Name, and Last Name fields via an automation. If someone can help me with this, I’m more than happy to chat privately to explain more and compensate for the time and efforts spent. :slightly_smiling_face: Here is my current script: current script let twoLettersToNumber = { "ah": 5, "ch": 8, "wh": 16, "tz": 18, "sh": 21, "ta"

Perhaps old news to most of you, I’m still recovering from a crazy week and catching up on some of the news items. Yep - with the announcement of Integromat’s acquisition the consolidation of no-code integration platforms (aka, glue-factories) has officially begun. We can soon expect others such as Tray, Parabola, Boomi, KissFlow and maybe even Zapier to get swept up by the likes of big tech and some very strong enterprise platforms which will have us saying - Wait! Who? It’s only a matter of time and honestly, these companies have got to see the writing on the wall. With every automation feature Airtable adds, you have to imagine the aftermarket of process automation demand has got to be seeing a few dents. Google Tables and Microsoft Lists both emerged with bot-like features on day one and the inherent ability to roll your own integration - albeit through script. But isn’t Airtable the same? The no-code platform offers so many script options I refer to it as the #not-only-no-code mov

Hi Everyone! I’m trying to send an email based on conditions. However, my condition grabs multiple records. I would like to input information indivually as opposed to to an array of matching values. When building the email in Automation, I can only select all of the matching values as opposed to acess then in a “forEach” style loop. You will see in my attached screen grab that I would like to input the three variables - business name, dates, and an amount. The automation seems to only allow me to input all of the matching values. Is there a way around this or should I use a script? Cheers

I randomly get this error on an automation that creates a new record from a web hook. In my automation I am not trying to put anything into the “Record name” field. Does anyone have an idea about this? Thank you!

Use case : “I want to automatically add options in single select. These options need to get updated automatically when a new ‘unique’ value appears in a column of different table. The value of option added automatically in single select, should be the new unique value that appears in the column of different table.” Problem : I haven’t been able to get a solution for this. I have tried to solve this through airtable scripting. I have repeatedly got a issue in the following code for simple testing ( I may add values of different column in the script later) : // query for all the records in a table let table_uploader = base.getTable("Data Uploader"); const selectField = table_uploader.getField("Location-select-script"); await selectField.updateOptionsAsync({ choices: [ ...selectField.options.choices, {name: 'London'}, ],}) I could print through console.log and see that “Location-select-script” is a single select option, but when I was typing code to update

Use case: at 8.00am every weekday check table to see which records in a particular view (view pulls records that meet the following two conditions: 1) Status = SCHEDULED 2) Email to KAE sent (scheduled) = false) Trigger works Find action works I then send out an email to a list of people showing the records in that view Action works Then I want to update the records to mark them as processed (which will also take them out of the view) Action does NOT work I have tried everything, just cannot get this to work Screenshot here:

I’ve set up an automation that consists of a trigger (which works), a script to get the automationTime (which finally outputs the current date in ISO format), and an Update Record Action (which should capture the outputted Date—from the script—and input it into an empty Date Field of the same format). I don’t know why it’s failing, and what invalid input it’s referring to. Some assistance would be greatly appreciated. Please see screenshot attached for reference. Thank you!

Hello, I have an automation that is running as expected. I would like to add a few more trigger words to my Conditions, is this possible? Currently the trigger is when the target field contains the word TEST. I would like it to trigger for TEST, TEST1, TEST5, TEST8, etc. Is this possible? I do not see any OR conditions, only AND. The field that contains the trigger work is a plain text field in the AT. Thanks!

I setup my first automation and it seems to have worked according to the ‘history’ but when I look in the table where it supposedly created a new record, the new records aren’t there. I don’t have any filters on, I searched and sorted in various ways with no luck, and just can’t figure out what it could be. Can anyone help? thank you!

Hi, I’m selling some digital products that exist in the form of codes, emails, accounts,… I want to connect my website to Airtable. When an order appears, the system will automatically send the order, get the code from the warehouse and send an email to the customer. I have tried many ways but am still having difficulty. If you can help me please contact and quote me.

Too bad, I was excited about the addition of Hootsuite integration. While it does allow post text messages to social accounts like twitter or instagram, it doesn’t allow me to post to Pinterest, it asks to select a social media profile and apparently Pinterest is not being considered as a social media profile (it’s not even listed as a social account in Hootsuite but it is there as a separate connection for itself). What is also missing is place to put URL, which is required for a Pinterest post. Not available in the Automation window. Also not available is ability to specify which Board on Pinterest I want to post to. So unfortunately this doesn’t work.

On my AirTable, it sends out an email when a view updates because the view in question is made to track employee records that are past their respected due dates. I would like an email to be sent out every Monday and Wednesday to the specific employee/collaborator, alerting them to follow-up on the past dues–until they no longer appear on the list. How can I do that? Drew

Hi All! Has anyone figured out how to automate the link to another record field? Basically have a flow where I am collecting a similar field such as an “email” or “name” and want to join from different tables. Eventually, i was to add parameters to not need to add for an email each time. Anyone have insight into this? that way I don’t have to manually link these records. Appreciate any help or advice!

Is there a way to trigger an automation when for example 1500 records are created in a specific table within a database? I have been trying to find a way but there is no solution.

How can I copy my SKU field to a linked filed that will also use the same SKU to link up data from my linked table?

My airtable automations stopped working suddenly with script going in pending stage. What can be the issue and how to resolve this?

Hi all, So I set up an automation to create a new Google calendar event whenever I create a new record and it meets the “to-do” or “in progress” status. When I tested the automation, it worked. But then I turned it on, I added some records, and all the automation runs failed. It is saying "Unable to parse datetime: “” … help!