Automations

We have an Automation setup to send an email notification via gmail account. In the email body is an Attachment field. The email recipients could open the attachments perfectly fine for month. In the last 2-3 days (likely as a results of the Attachment URL change/expiration), these attachments thumbnails show in the email body of the email notification recipients, but there is an error when clicking on the thumbnail image to try to view the attached file. Here is what the recipients see… The email recipients, as in the example of the screen shot above, are not users of Airtable. We just send them email notifications. Any way to fix this? Thanks, Khuned

Hello Airtable Community! I am new in Airtable and have no coding skills so bear with me please. I created a first rule that creates a record in Table B if a checkbox is checked in Table A: That is working as expected. Now, I want to create an automation rule that if I uncheck the same checkbox from Table A, it deletes the same record in Table B. I’ve searched for article and found this one but don’t know how to make it work:

I have a formula field that creates a URL from a form, with pre-filled data. We are sending this URL link via an automated email. When someone receives the link on a mobile device and tries to open it, they land on the Airtable site and are asked to sign up. It does not display the form in a browser.This is not an issue on a computer. How do we fix this?

Hello! I was wondering if there was a way to set automations at a scheduled time for a 12+ week interval. The reason we need a “weeks” interval (instead of a “months” interval) is because we want this automation always sent out on a Monday. Thanks so much! Sean

Hi, can you help me? I need to sum 16% if the field “Incluir IVA” contains 16%, if it doesn’t, just do the first arithmetic operation. Thank you

Hello all, I am very new to scripting and trying to find a way to create separate records for all dates within a range of two dates, a start and an end. I found this code online but it is not working, I am completely new and just wondering what needs to be added before in order for this to work with Airtables var fromDate = new Date(inputData.from); var toDate = new Date(inputData.to); var output =[]; var i = 1; do { var useDate = new String(fromDate.toISOString()) output.push(useDate); console.log(fromDate); fromDate.setDate(fromDate.getDate() + 1); i++ } while (fromDate <= toDate); console.log(output); return{output};

Hi guys! I run a small business where we sell vacant land and use airtable as a hub of property data. We have three tables (that are sent to customers) 1. Current inventory with CASH prices, 2. Current inventory with FINANCING prices and 3. Current inventory for a specific sales agent We have a status section for when a property is “available” or “pending”. Since we all work out of different tables, I wanted to see if there would be a way to create an automation that can update the status in ALL three tables when the status is changed in one? I have been trying to do it with update records in one, run two actions but I keep running into a “fix testing error”. so I am hoping someone more techy than me can provide some insight!

Hi Community, I have a table with multiple records. Each record has the name of a colleague in the first column/field, an email in the second column, a link for that email in the third column, and the weekday in the fourth column. E.g., Record 1: Simon, simon.g@gmail.com, URL 1, Thursday Record 2: Jack, jack.f@gmail.com, URL 2, Thursday I need to send the links to the email addresses for each person. Since each link is specifically designed for that colleague, I would have to send individual emails to each colleague. Is there a way to automate the process? So that by every Friday, Airtable could automatically send URL 1 to Simon and URL 2 to Jack, and so on for every colleagues. Thanks!

I’d like the contents of a single line field to automatically be added to a multi-select field. This is meant as a workaround as Airtable doesn’t allow creating new options from a form, so I’d have the user create a new option in the single line field - and then this will auto-populate the multiselect field.

Hi all - I am new to Airtable and am hoping to use it manage inventory for an online secondhand clothing store (Shopify-based). When we receive a new order a zapier integration will create a new row in an Airtable ‘Orders’ table with fields like quantity ordered, price etc. I would like this action to automatically trigger a corresponding downward increment of the quantity available field in my ‘Products’ table. How is this possible please? I don’t want to use formulas as then I would need to store all our orders indefinitely and would quickly exceed the size limit on the sheet. I need to be able to archive the orders information without losing the impact on my rolling ‘quantity available’ field in my products table. The incrementing impact needs to permanent and cumulative. Many thanks, Oli

Hello, I’m building an Automation in Airtable and am using the “at a scheduled time” trigger and the “send an email” action. In the “send an email” action, in the email subject line, I’d like to include the “actual trigger time”. However, the time includes the date and timezone code, and I’d like to remove the timezone code. As an example, here’s what I want the email subject line to say: “Weekly Sales Report - 2022-11-08”. But instead it looks like this: “Weekly Sales Report - 2022-11-08T22:51:31.571Z”. Is it possible to strip out the timezone code (T22:51:31.571Z)? Or can someone suggest an alternative solution? Thanks so much!

Hi there, With all your advice, I managed to create the automation to update my google calendar event if I change something in the airtable record. On the other hand, my little concern is that I did not find the trick to delete the event from google calendar if I delete the airtable record. Does anyone have an idea? Thank you very much.

Just getting back into airtable…is it possible to clear (delete all records in a table) every morning? In a perfect world this would be automated at/for a certain time. Seeing scripting and/or automations could be an option, yes? Full disclosure, an automated scenario from integromat populates the table once a day. Thank you for your time and effort! -Anthony

Hello, I currently have airtable tracking shipments that are scheduled to come back at a later time. I have to manually track all this. I have tried my hardest to find the method to make airtable do this automatically but i cannot figure it out. i have a status field and I would like the delivered date and due date to be automatically adjusted when i mark the status as “with client” I am trying to figure out how to make airtable select the delivered date on the day that I mark the order “with client” and add 10 days to the due date. could someone please help me . thanks

Hi, i have created 2 tables, one for houses (woningen) and the other one users. So the users have a profile with for example min and max what they want to pay for a house. So the house goes to a filter of all the users profile to not overwrite the user that is added to the field i am using a array aggrergator. because i want to send the users in a list to have multiple users instead of one that is overwritten but it gives me this error: Bun

Is there a script that will just pop up a quick message within an automation? When someone chooses a particular option from a single-select field, I just want a pop-up window with line of text to show on the screen. An email isn’t useful in this case. I need to remind them to link the record to another table if they choose this one option. It isn’t a one-to-one link, so the automation can’t do the linking for them (i.e. the update record automation won’t work.) And an email comes too late, in a different context, and I’d rather remind them to do it while they’re in the record, not have to go back after they check their email. The other idea I had was to have the automation open, or navigate to, the field. Can you “find” a record at a specific field?

I have a date/Time field I have a duration field I have a “Reminder time” field that calculates the Date field minus the duration What I can’t figure out is how to set the automation to trigger based on the Reminder time. being NOW .I prefer not creating a view that filters because I have too many views already so I am hoping I can do it based on “When records match condition” but NOW is not a parameter in the triggers.

I have a CONTACTS Table and a linked INTERACTIONS Table. I would like a button in the Contacts Field that creates (and opens for editing) a related record in the INTERACTIONS Table with the Contacts name and today’s date in the Date Field pre-populated. My assumption is I need to write a script and then have the button run the script. I know how to do the second part but don’t know how to write the script. Any help would be appreciated.

Hello, I have a two tables, in one I have a record of products and some of them have an “order” check. In the other table is the order to suppliers, with another check for when the order is placed. I need that when the Check of suppliers is set to Check, automatically the Check of “order” in the products table is deactivated. I try in the automation but it gives me error. What can this be due to?

I work with a cohort of independent trainers who offer in-person and only training. I have a column with my training courses listed. At the end of the training, I would like to send an evaluation form to my participants that displays the course and the trainers as listed in my airtable base. Is this possible with a url with fields attached?

A group has until 11:59 p.m. on Sunday to complete their tasks. I want to create an automation that sends an email on Mondays at 12:15 a.m., letting the entire team know which tasks were completed and which ones are outstanding. When I select “Monday” the trigger keeps displaying “Sunday.” If I turn “Sunday” off and select “Monday again,” it just adds a new “Sunday.” Can someone please explain what I need to do differently?

Everyday I have new data coming into a base. Each row will uniquely be assigned to a user. I have a User table with the email. The data needs to be emailed in a csv. I was thinking can do this in Python script, but there probably is an easier way. Trying to avoid additional costs. Thank you for the help

Hello all, Thanks for reading :slightly_smiling_face: I have a base with a table call « people » People has a Name, a email, a status. I am doing a automation that « whenever a status is change to ‘Send a Email’, Send a email with different status to update » When the status is changed to ‘Send a email’ a mail is send to the person with the current email : To : [Email] Hello [Name], How are you today ? I am happy I am ok I am sad I don’t know what should I do to update the different row, creating a page that use incoming webhooks from the email with the object id in get url parameter or talk to a Dev to do that using the API, or an other solution ? Thanks again for reading and for the help

I have a script below to trigger a webhook when a record enters a view. I need to pass two parameters (recordID and UserUuid). The problem: I get the error message “This expression is not callable. Type ‘string[]’ has no call signatures. (2349)" on the variable userUuid” The possible cause: because variable is Array<string> rather than just string, I need to reflect it in the below code. I got the script on the internet, so I kindly request if someone could let me know the change to apply in the code to make the array callable? Thank you so much let inputConfig = input.config(); // AIRTABLE REALTIME TRIGGER TEMPLATE let webhook = 'https://hook.us1.make.com/gks2o5k90h0f2fggmdy6u4uilamaegru' let queryParams = `/?id=${inputConfig.recordID}&user=${inputConfig.userUuid` const returnedPayload = await fetch(`${webhook}${queryParams}`);

The title pretty much says it. I’m thinking this would be simple for someone who knows JS, but I don’t. So I’m hoping someone can help me create this button. I’m trying to do this with a button field type and the scripting extension. I have a column where I put the JSON in plain text and I want to convert it to application/JSON and then copy it to clipboard. All with the same button. If you’re curious, I’m doing this so that I can store my webflow components, So I can have easy access when I want to reuse one.