Automations

Hello, Is there a way to create an automation where a new date is populated for 2 weeks later. For example, I have my google docs linked to my airtable. When I open a new document, it creates a new record. I want my assistant to schedule that content 2 weeks from the time of writing, so there needs to be a date created. However, I want the date to only be on a tuesday or thursday. I content bath my work for 2 weeks and that will plan next months content and the content created can only be posted on Tuesdays/Thursdays, so not exactly 2 weeks from the time of creating the record. Any help will be appreciatied!

Hi all, I am not a developer and I am trying to run a script that converts Numbers to Words each time a cell is updated… I found this script in a topic here, but I get this error when testing : TypeError: output.markdown is not a function ** at main on line 1** It is supposed by automation to convert in words when updated a cell called ‘Salarynumbers’ in another cell called ‘SalaryWords’ in a table named ‘Animateurs’ This is the script : output.markdown('# Numbers to Words'); // establish the words arrays let a = ['','one ','two ','three ','four ', 'five ','six ','seven ','eight ','nine ','ten ','eleven ','twelve ','thirteen ','fourteen ','fifteen ','sixteen ','seventeen ','eighteen ','nineteen ']; let b = ['', '', 'twenty','thirty','forty','fifty', 'sixty','seventy','eighty','ninety']; // get the name of the table let table = base.getTable("Animateurs"); // get the records from this table let result2 = await table.selectRecordsAsync(); // Update the records for (let record of r

Hello guys, I’m new to airtable in the hope to find a solution for a serious issue I’m having. Bascially I want to be able to send tailor-made emails to my customer based on the number of purchases they made on my website (1st purchase = email 1 / 2nd purchase = email 2 / etc.) So to do this I’m using woocommer, zapier, airtable and my autoresponder. At this stage I’m able to send my woocommerce data in airtable via zapier but I’m struggling to make the count work. What I need is that everytime someone lands in my airtable, the system automatically check if the email address is already present. If it’s not the case then attribute the number 1 and if it’s the case it counts how many time the email is already present to give the right number. Then I’ll be able to use this information to send people to the right autoresponder list using zapier again. In excel I’ve been using countif but I’m not sure how to create this automation in airtable. Could someone help me? Many thanks, Géraldine

I’m currently using the Airtable script ‘Convert URL’s To Attachments’ to populate a column w/in my table with images coming from a URL. My table’s data is refreshed once per hour - so currently my images need to be downloaded after each refresh (manual at the moment) I’m trying to automate this process by using this script w/in the Automations settings for my base but do not see a way to select an existing script when setting up the automation.

If I want to run a python script when an item is created in a table using pyairtable, is this possible or will I only be able to do this through an IDE/terminal? If I can import my script to the website, will I need the plus, pro, or enterprise-level account?

Hi, dear community, In AIrtable automation there is an option to send emails to several people for every updated record. Now the problem is it sends individual emails for every individual updated record. I wanted to know if there’s a way I can use to automate the emails for all the updated records in a table at the same time. Meaning if I have 10 records in a table, and I updated them all at the same time, I want to send an email to my teammates containing updates for those 10 records at along. Thank you and really appreciate your help!

Suppose I am trying to grab some records from table 2 using a set of linked records from table 1 with an automation so I can show a list or gallery of these records in an email. For whatever reason no matter how I do it, Airtable will not let me use an autonumber field to do this. I’ve tried it both as a primary and non-primary field, I’ve tried using a formula, I even tried creating a formula that gets the record ID and then seeing if Find Records could find that (which resulted in an “unkown error”). I don’t know why any of this is the case when its essentially performing a sort of janky database join. I’d appreciate any suggestions for workarounds. If you are curious what exactly I need this for: I have a series of equipment reservations. I want to list the equipment details in an email detailing the reservation. The trigger needs to be a form on the reservation table.

Hi :wave: , This is my script now: let ranking = base.getTable("Ranking"); let record = await ranking.selectRecordsAsync(); for (let line of record.records){ let tweet_url = line.getCellValue("tweet_url"); if (tweet_url != null){ let status_location = tweet_url.indexOf("status"); let id = tweet_url.slice(status_location+7); let link = `https://api.twitter.com/2/tweets/${id}?tweet.fields=created_at`; let token = "AAAAAAAAAA2pr2rjtB9ewZtrXtic5AXxsWdAC"; let response = await remoteFetchAsync(link, { headers: { Authorization: `Bearer ${token}` } }) let file = await response.json(); let datetime = file["data"]["created_at"]; let t_location = datetime.indexOf("T"); let time = datetime.slice(t_location+1,t_location+9); console.log(time); await ranking.updateRecordAsync(line, {"tweet_time": `${time} GMT`}); console.log("time updated

Hello, I want to achieve the following, using automation, when the condition matches. Send SMS via 3rd party (in my case either Vonage or Twilio). Currently, Twillio cant send SMS only via app integration when the record is created or updated. I need it to send when the condition matches. Has anyone managed to solve this case? Theoretically, Vonage supports sending via some code Curl, Node, Python, PHP etc… but all require some external packaged and since Airtable supports only vanilla JS, i have a problem in that. Has anyone got any ideas how to create a work around here? Thank you

Hi, I need to send product info to people, and the general email is the same every time, but with different links in the email depending on which product they ask about. I’ve set up a view for each product that can trigger the correct email, but that requires a different view for each product along with a different email automation for each product. Is there a cleaner way to do this? Thanks.

Hi folks, I’m kind of new to Airtable… I created an automation to send an HTML grid to email. it works fine and I get the selected view to my email as a readable table. I tries to send same view to slack but it sends only html markdown (not in a table and not readable) what’s the way to send to my slack account HTML grid view same as in emails P.S - when sending records to email I can choose fields but when I send to slack the only option is a markdown no fields to choose

Hi guys, in the spirit of Christimas I’m in charge of a support group for people in need. We have got a lot of applicants who really need our help to make sure their kids are going to get a gift this year. I’ve got a ton of gift cards in a single column in excel, and I’d like to distribute all the gift card codes to the recipients. Now here’s the kicker: the recipients have different amounts of kids, which means they need different amounts of giftcards. I’m trying to figure out an automation that links a number of times from the recipients sheet to the gift cards code sheet, while never linking to the same code more than once. The route I’d go would be to make a formula field which counts how many links are in a ‘link to an another record’ field, and if there’s less than the number of children in the family (a manual number field), then it keeps adding a new link from the gift card sheet. But the last part is not really doable in automations, as I see it…? Worst case: I’ll do it by han

I have a database with a column with all email addresses of my clients. I would like to send an email automatically to all of them, but can’t find the way. Maybe a Zapier integration? Everything helps. Thanks!

Hello! I have a table in which a student’s “Start Date” is captured in a date field. There is then a # field that indicates the “# of weeks” the student is in the course. Then lastly is a formula field that takes the Start Date + # of weeks = Graduation Date. A student is allowed to renew for an additional 12 weeks. I would like to create an automation where the following occurs: Trigger = Record Meets Conditions Action = Run a script that would take the records current # of weeks + 12 and put that new total into the # of weeks field. I simply cannot make heads or tails of scriptwriting to get something that works and am hoping someone else can assist. I feel like this is probably something very easy, and I really don’t want to add a few more fields along with messing with the original formula for Graduation Date, if I don’t have to :slightly_smiling_face:

Hi! I am sending text-only information from a form in my Softr Web Application to Airtable and create a new row for each entry in a table. Later on, I retrieve this information and display it in my Softr Web application in a Grid view, including a image for each record. As I don’t want users to upload/provide images, I would like to add placeholder images for each record created in Airtable (and display them then in the web application again) As for the moment, I couldn’t identify a way, using automation, to add a placeholder image to new records created by Softr in Airtable. Is there any possibility to link an existing image from another table or similar?

Hello, I created an automation when a record is updated it sends an email to certain team members. I am having a hard time sending the the URL field that attaches to that record. How can this be done? Thank you

New to implementing anything but the simplest “send email” automation, so hoping I did my initial design right. We’re trying to build a log for tracking if timecards from various crews (construction) have been submitted. Table A has a list of all the shifts that we’ve scheduled coupled with the day the shift starts (IE we can have a 12/14/21 Day Shift, Swing Shift, Or Night Shift). This table would be filled in the office (calendar view) and we would assign a foreman to each shift. The Primary field (right now) is a formula combining the date and shift, so a typical record looks like this: Date-Shift (Formula) ||| Date (Date Field) ||| Shift (Single Select Field) ||| Foreman Name (Linked Record to a Foreman Table) Then Table B is for the foreman to fill out via a form view. They get a date picker field, a shift select field, a foreman linked record (just like Table A) and then an attachment field to upload their timecard file. Would look like this Date-Shift (Formula) ||| Date (Date Fi

Hi all, I have a question about whether a script could be developed to integrate automation with the “Task Tracker App” functionality. Specifically, whether an automation based on conditions being met could then trigger an action such as starting, pausing, or stopping a Time Tracker App being run on that Record ID. Apologies if this has been answered or addressed, I have not been able to find anything on this community or FAQs. Appreciate it! Best, DL

WHOOP WHOOP

I have two linked tables in the same base i) Accounts ii) Meetings. I would like to update the “status” field (single select) on the Accounts table based on the the “meeting outcome” field (single select) on the Meetings table. For example if I create a new record in the Meetings table for Account#5 and I set the Meeting “status” field to “Successful”, I would like to automatically change Account#5’s record in the Account table to “Won”. Conversely, if I create a new record in the Meetings table for Account#5 and I set the Meeting “status” field to “Unsuccessful”, I would like to automatically change Account#5’s record in the Account table to “Lost”. Can this be achieved with automations? I haven’t used scripts and am not a programmer so not to comfortable using that approach.

Hi, I’m currently in the process of trying to perform an automated update of a table record based on the trigger type “When Webhook received” (still in alpha dev phase). It indicates sending a webhook request to an ‘example’ webhook address in order to indicate ID references. I have placed the example webhook address into a script app in the base that is intended to trigger the update automation via webhook. I have also included two input variables in the webhook call. The intent in doing this is to have the script call the webhook to trigger update automation and use the input variables to a) identify the correct record to update and b) provide the updated value to the intended field to update. The result is the error in the screenshot below. This raises the obvious two-part question: Why is the console message indicating that the URL is not found and the automation test failing as a result? Thoughts anyone? Am I overcomplicating this endeavor to start with? Thanks in advance! (Yes,

The processing (or calculations) I need to perform are currently done in a Google Sheet. The calculations in the sheet are straightforward but have about 20 steps, and the final result is a string (an array) in a cell in the Google Sheet. I want that result in a cell back in AirTable. I am sure there’s a way to write a custom script with Javascript in an Automation and write result to the cell. I’ve started, but I’m not strong with JS. I would like to explore other more low/nocode ways do these calculations. I imagine there exists some other low/nocode SaaS tool that you can build a little black-box app with build business logic and calculations and spit out a result. In summary, here’s what I’m currently doing that I need to automate without Google Sheets: Row in AirTable has 5 values. I manually copy those 5 values into a Google Sheet, which does a bunch of calculations, involving creating a 12-period time series with about 20 rows of partial calculations, ultimately collecting the

Hi, I’m trying to update a record and select specific options in a multi-select field via Integromat and need some help. One of my preceding modules in Integromat gives me an array of destinations. Something like this: Destinations = [Africa, Asia, Australia and South Pacific, Central America and Caribbean, Europe, Middle East, North America, Polar Regions, South America] In Airtable I have a multi-select field with these exact options I referred to this thread, but can’t get Integromat to put the original multi-select values directly into the multi-select field as suggested by @ScottWorld. When I try this, I keep getting a “Cannot parse value for field Destination Options”. As you can see from the image above, I am using an iterator to iterate through each value in the Array and pass on the Update Airtable Record module hoping that on each iteration, the next item from the Array, i.e. one destination at a time, will get ‘checked’ in the multi-select field in Airtable. Am I going abo

Hi, So I’ve got a Zap sending data to Airtable on a from submission is Webflow, the Zap then also adds the uploaded attachment to the CMS item as a link in Webflow so Webflow form → Airtable → Airtable → Webflow CMS Item. Only the problem is that the link that ends up in Webflow’s CMS is still the uploaded Webflow froms link. Very new to airtable, but is there an automation I can run when Zapier adds the Webflow form file upload link to the Airtable Attachment field that will actually add the file to Airtable so that Airtable isn’t just adding the same Webflow link back into Webflow? I need all the uploaded files to live in Airtable. You can see the steps in the Zap here and that Airtable is just passing the same link back from the Attachment field instead of a link to the file in Airtable.

I have created an automation in Airtable that schedules a post in Hootsuite when the Status field is “APPROVED”. My Date, Copy, and Attachment fields are correctly mapping to Hootsuite, BUT I need my “Image Link” field to map to Hootsuite. I need this to happen so when someone clicks on the image of my post on LinkedIn, it opens to a hyperlinked location vs just expanding the image. Right now, I have to remove all of the copy and the attachment that was automatically populated, paste the “Image Link,” click the “custom link preview” button, upload my attachment, remove my pasted link, and paste back in the copy. There HAS TO BE an easier way - help! This is a screenshot of my base. I’ve circled the fields that are correctly mapping in RED and the field that I need to map in blue: This is a screenshot of how it appears when it automatically uploads to Hootsuite: And here are screenshots of the lengthy process that I have to go through to get the post in the format needed, all because