Automations

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

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 -

Hello, I’ve created an automation to add records to a shared calendar. Everything seemed ok when I was testing it with dummy data on a test table, and indeed when I cut and paste the actual data back in to the real table, to recreate the records (about 100 of them) again, the automation also worked correctly, inputting the Outlook calendar Event ID onto every record bar the one on the top row (no worries, can live with that). However, since then, when adding new records, either manually, through a test form, or through Stacker (as intended), the automation fails to add the Event ID into the correct field, and thus fails to write it to the Outlook calendar. I’ve tried changing the trigger from “When record is created” to “When record enters view” and still no difference. I have no idea where I’m going wrong now… Have I hit a daily automation limit or something? Any pointers would be much appreciated; my app is riding on this last thing! Many thanks,

Is there a way to set up a repeating email alert that is sent every day or every week as long as a record in a Base is not corrected by the collaborator? Drew

Hi everyone! We have started using Airtable for teaching and I’d like to have a mechanism that sends students their grades automatically each week. Each record would have information like the following in a table called ‘Grades’: ID: 1, Name: Anna, Email: abc@def.com, Grade HW1: 1, Grade HW2: 0. ID: 2, Name: Ben, Email: def@ghi.com, Grade HW1: 1, Grade HW2: 1. I want to send out an email each Monday to each student individually (they are for data protection reasons not allowed to see each others grades) that looks like this: Hi [Name], These are your current grades: HW1: [Grade HW1] HW2: [Grade HW2] Best, Ann What is the easiest way to do this? I have tried the “Find records” action in an automation with the “Send email” action but this gives me all field values instead of just those of a single row. I have

I am trying to generate my table responses in a google sheet however I am finding when I submit a new entry it sometimes enters twice on sheets and when i go to edit an entry, it will add a new entry as opposed to altering the initial one. Any help on sorting this out will be appreciated!

I’m trying to set up an automation that will send a link to a teams channel, but the Markdown isn’t rendering in the message: Am I doing something wrong? Is this a known issue? Thanks for your help! Joel

I seem to be missing something simple, hopefully someone can help me out! I have an automation I am setting up. To put it simply, the automation should do: If 24 hours have passed since the last change (Based on “Last Submitted Change”, a last modified by field) Clear out the “Change Type” field (A single select dropdown field) The automation seems to work in test runs. However, in actual execution, it fails every time. I have entries where the last submitted change was made two weeks ago but nothing happens. Can someone either offer some insight as to what I’m doing wrong, or help me figure out how to set the automation up so that it functions?