Automations

Hi There! I am pretty new on airtable but finding out that it is a really helpful tool for my bussiness I am preparing (fighting against actually:-)) an accounting table and i want to convert a formula field to a linked field through an automation. I dont have any problem if the formula returns a single string but i am not able to do that when the formula returns several trings separated by commas. I have read here and there that this option ( i mean, to convert a string with commas into diferente links on a linked fill is possible just copying and pasting) But, with the automation, i get a single link instead of several links. ¿Do you know why it is happening? Thanks! David

In Automation “Find Records”, only 100 records get found for the subsequent action. What are the work arounds for updating more than 100 records?

Hello! New Airtable uses and non-techy type, so thank you for your patience and translations if I use the wrong lingo. I have a database with appx 800 records, each record represents a person. I’d like to send an email to everyone and have them respond to a question that I would like to automatically add into the record. I understand how to make a form (I think), but am unclear about how to automatically send a link that would pull into this current base. I can create a new one, but that seems like a bit of double handling. I’ve had a brief look at the Zapier option, but it seems costly and like quite a bit more than what I need to do on this instance. Also I eventually need to add an automation that sends an email when a certain box is ticked. But I think that will be a bit easier than this first challenge! Thanks! Cessalee

I must be as dumb as a box of rocks, but I cannot figure this out. I am trying to make all day events export to my Google calendar. In the Automations configuration screen, I have “all day event” checked, which you would THINK would negate the need for specific dates/times to be added. Apparently that is not the case. The form won’t let you even run a test unless you put in a start and end date. Originally I had a single Date field, but I kept getting “Unable to parse datetime:”" error. Soooo, I added a new field to my base (which I don’t really need & it clutters my view up to NO end) to add an end date. Thus now I have a start date table field and an end date table field, both configured as “Date - US”. Same error message. Do I really need to add times for all day events that don’t require same? I’ve read all the other threads on this and haven’t come up with anything that helps, I guess b/c nobody else is trying to set up all day events? Also,

Hi I have a quick question about setting parameters of when an email automation sends out. I have my automation setup to email certain users based off of a record being updated that is within their view. I’m noticing that I am spamming people because Airtable is sending the email before I’m done typing in all of the notes. Is there a way to not have the automation fire immmediately? I want it to fire when I’m done updating the record vs in the middle of it. Hopefully that make sense. Emails that were sent: Automation: If this is posted somewhere else please point me in that direction. I tried searching but couldn’t find exactly what

I have written a script that gets triggered when a record enters a View, and that entrance into the View is supposed to happen just after any field in the record is modified. The script itself creates or deletes records in another table based on the event-speaker combinations in the original record. Well, I find some interesting behavior when I duplicate a test record. Specifically, the duplicate AND the original records both enter the View triggering the script twice. I would like to know why the original record is considered modified according to the LAST_MODIFIED_TIME() function, and if there is anyway to stop this from happening. Thank you.

In the same table I have a column that has a running tally of copies sold (I sell books) and in another column I have the Sold Out Amount. I’d like to create an automation that triggers when Copies Sold equals the same amount as the integer in Sold Out Amount which seems like an easy thing to have happen but the automation won’t let me put in a field name to compare

We are trying to create personalized product recommendations based on answers to a survey. We have a survey in Landbot that we would like to create product recommendations, where a consumer could add the products to their shopping cart in Shopify. Has anyone done something like this?

Ultimate goal: Have analytics in one place so I can run graphs/reports. I have a spreadsheet where folks have been entering analytics. I also have a table with the stories. I’d like to merge them in some way. One idea i had was to create a new table for the FB posts. Table “FB Posts” column “FB Text” includes the same text as Table “Editorial Content” Column “Social Text”. I added a Lookup column to Editorial content so it will show the FB reach, but I need to fill out the “Link to FB Posts table” to make the lookup column work. I thought I could run an automation. Here’s what I have so far: Trigger when record enters a view in “FB Posts” (I added a checkbox in FB posts table to trigger this). Find records Table Editorial Content Find records based on Condition where “Social Text” contains "Record (Step 1: Trigger) Field Values “FB Text” But I get lost at the Update Action. Thanks for your help!

I am the original creator of my companies’ Airtable account, and as such I created all of the automations and integrations. In the majority of our automations, we use our company Gmail account to send an email as a result. Today it came to my attention that the password for that Gmail account was changed, and as such the integration was broken in Airtable. When my co-worker (who has full admin access to our Airtable) looks at the “Manage connected accounts” menu, she sees “no connected accounts”. My question - is a collaborator unable to view / edit connected accounts, regardless of their access level?

Hi there! I am setting up a Gmail: Send email automation. Everything is working as expected. I want to add email addresses on the cc but I can’t seem to find how. See attached photo below to check how the setting looks on my end. Am I missing something? If there is a prior discussion on this, kindly link me to it, please. Thanks in advance for any help.

I have a sheet that facilitates a document workflow between Creatives and Client. Creatives add draft copy to an attachment column, which triggers an automated notification to the Client to review it. If the Client has feedback, they put it into a 2nd attachment column (“Feedback”), which notifies the Creatives, who will add their revised draft to the 1st column, and so on. In addition to notifying the relevant party, the automation updates a Status column. What I’d like to do is prevent the Client from updating their attachment column while the Status indicates the ball is in the Creatives’ court; and vice versa. Can columns be disabled or permissions adjusted conditionally using the “Run a script” option in the automation? Any feedback on the best way to prevent one party from interrupting the other would be appreciated. Thanks!

I don’t this this is available for airtable but I am trying to send a email that has a calendar view through airtable. But the only options I see available are basically either a list or grid HTML file. I would assume airtable can’t actually send a email with the day’s events in calendar view.

I’m on the free plan and when setting up an automation to send an email I get this error message: “On your billing plan, you may only email collaborators with verified emails. Contact your workspace administrator to upgrade.” However, the email address I’m putting in is my Airtable username and it has been verified. Any ideas on how to fix this?

Hi, I’m looking for a solution for creating an automation that changes the status of a new record to “Denied” if a record already exists with the same requestor name but with status “Approved” in the last 30 days. Can someone help me if this is possible?

Hi, I’m trying to create an automation to send a notification to a collaborator at some point in a project. However, whichever automation I create (email, Slack message, comment on a column of my record), the collaborator is not recognised : I select the input from the collaborator field, and it returns an empty field. Does anyone know how to fix this ? Thanks a lot !

I have a single select field for “Schedule” with 3 options: Today Tomorrow Future I’d like to create an automation that runs at a speficied time (midnight) every day that will change any record that has “Tomrrow” in the Schedule single select field to “Today”. I’ve been trying to do a trigger of “At scheduled time” and can set it for midnight — that seems to work fine. But I can’t seem to come up with the action that will change any “Tomorrow” to “Today”. Am I missing something?

Record ID is not being detected by the automation tool. I need to change a status of a record when another record is created. But when I link them together it does not detect the ID and the error says the field is invalid. I have other automations done the same way. I am using “copy” tables so I don’t mess with my current data Flow wanted: The table that is going to be updated is “Control Modulos” When record is created in Cosecha → Change status of linked record to “Disponible” and then When record is created in Paso Modulo → Change status of linked record to “En operacion”

I have two tables: “Widgets”, “Sales”. A Sale record can reference one or more Widgets. When I create a new Sale record, I want the the “sold” field in the corresponding widget record(s) to be toggled. Sounds like this might be an Automation, but I’m new and not sure. Can someone please point me in the right direction? Thanks.

Hi, I have a trigger when a record is updated. Then, I want to find record depending of a dynamic field from the trigger step. When I want to add the field, I can’t “insert” it. I can only insert the first one “airtable record ID”. All other field, there is a ‘continue’ button and nothing afterwards. Do you know why ?

I have to upload a file to Airtable. I don’t quite understand the documentation for file upload. I have this code that is in python that should upload a file to airtable via a link but it gives me a 422 error. How can I fix this? ATBASEID = "****************************" ATTABLENAME = "DEV" AIRTABLE_API_KEY = "*************************" ENDPOINT = "https://api.airtable.com/v0/" + \ ATBASEID + "/" + ATTABLENAME HEADERS2 = {"Authorization": f"Bearer {AIRTABLE_API_KEY}", "Content-Type": "application/json"} data2 = [ { "id": "attqyuWADmKW9DgDG", "size": 26317, "url": "https://www.filepicker.io/api/file/5YTJXioCQG0tYWPw6OPw", "type": "image/jpeg", "filename": "33823_3_xl.jpg", "thumbnails": { "small": { "url": "https://www.filepicker.io/api/file/Dy5gioxaShSUvHX0LgIC", "width": 54, "height": 36 }, "large": {

Hi community! I know this question has been asked before but I’m having trouble sorting linked records. I’ve got a project management app that I need to sort updates, showing the most recent update at the top of field. I’m currently able to do this via a manual Batch Update but I would like to create a script that does this automatically. I found the below script on another thread but it is not working form my base. This was originally posted by @Omer_Frydman and looked very promising. I have a tabled called “Action Plans” that contains projects. I have another table called “Action Plan Updates”, that contains project updates. I have a linked field in the “Action Plans” table that links records to the “Action Plan Updates”. These are currently displayed oldest to newest. The way I would like the script to work is when a new project update is entered to trigger the sort to happen upon submission. I’m very n

Hi guys, I am new here and I need some help regarding Grid-View and Calendar: I have two tables. Table 1 shows Projects which have been booked - every record contains ‘project name’ as a single line text field and ‘project date’ as a date field. Table 2 should show them so I am trying to sync both tables (they stay in one base). I tried to make an automization: sync date field of table one with date field in table two. This works fine. sync project name won’t work because I cannot automize a string with a date field. My question is: how can I sync project name + project date out of table 1 with table 2? If there is a thread for this task I would appreciate if somebody can share it with me. Thanks for your help. Best Philipp

I’m just needing a hand with the Automation Scripting Syntax - I can push it to Console.Log, but just struggling to pull/assign the input values to variables. I’m trying to get local time date stamping into fields, really struggling to get my head around the timezones, when I think I’ve got the problem solved, it’s not. So I figure that if I pull the time of when the script actually executes, surely that will reflect the correct date.

I created a formula column (B) so that it contains a different kind of checklist for each record, depending on the value in another column (A). For example, in column B, each record has either of these two checklists x y z or red blue green Because I want the checklists to appear in rich text format, so that I can easily select a checkbox, I duplicated the formula column (B) to create a new column (dupB) that is long text with rich text enabled. Is there a way to automatically make the checklists in dupB show up as richtext so that I can make selections using a checkmark? I could do this manually but I’d have too many rec