Automations

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!

Hi all! I would have a form on Softr sending data to rows in Airtable. I would like ideally to just have one row and each new item received from Softr be written over the top of the old. Otherwise, have it created as a new row and delete the old one. I’ve played with a few automations now and can’t seem to get it to work. Any help would be appreciated! thanks, Rich :pray:t2:

The URL will contain the source as PlatformA or PlatformB.So I want to find out what is present and if it matches type the same in the column. Tried using the following IF statement but irrespective of what’s there in the URL its always showing up PlatformB in the column. IF(“URL = PlatformA”, “PlatformA”,IF(“URL = PlatformB”,“PlatformB”," NoSource")) Thanks

Hey!! I am new to Airtable Apps. I need some help!! How can I assign to a cell of my field casually a value from another table? I have in my source table a field with 2 values (Resistance, Spia) and I want to choose casually one of them and then put it in my second table (Field: Ruolo), how can i do it? What script I have to write? And then copy the value from this table to the last one? Thanks in advance for your help! (Sorry for my weak english!!!)

I am quite hitting the limits of Airtable, 500 fields max, maximum 25 automations per base, 25 actions per automation, 30,000+ characters formulas … what else. So far I didn’t break anything in Airtable, so far so good. But I don’t much data, so I don’t mind my base is slow like a snail :winking_face: Anyhow, did anybody notice an issue with Automations tests? I have 2 tables linked and 2 automations with total 50 conditional tasks. They are exactly same, copy of one each other, with slight differences. Yet, when I run the test in the Automation, one automation shows errors, the other one doesn’t. The second Automation was created as a copy from the first one and it was created later. Both automations work fine and no issues. However, the first automation created earlier shows a sea of red exclamation errors saying The Record does not exist. As I said, both automations work fine inspite of these errors showing. For some strange reason - in Automations - Conditional actions - the Reco