Automations

I have an Automation to send an email when a record enters a view. I can get a regular date field to format the way I want, but I can’t when I try to do any calculations. This is a Deadline date that I would like to add 48 hours to from the time it enters the view. Anyone have any suggestions on how to do this? I’ve tried multiple variations of the following. I’ve also tried using Update Record Automation, but it won’t accept DATEADD() or I’m not doing something correctly. If it’s just a plain date field, I can use this and it works fine: DATETIME_FORMAT(SET_TIMEZONE( {Test Date}, ‘America/Los_Angeles’),‘dddd, MMMM D, YYYY h:mm a’) But if I try adding 48 hours using something like this to an Intermediate Due Date: DATEADD({Deadline},48,’hour’) And change the formula to this: DATETIME_FORMAT(SET_TIMEZONE( DATEADD({Intermediate Due Date}, 48,’hour’), ‘America/Los_Angeles’),‘dddd, MMMM D, YYYY h:mm a’) It fails and says the formula is invalid. Even when it looks correct in the View, What

Hello! I work for a government office which handles various requests from constituents (water issues, waste management, tree trimming, etc). Our current system uses three tables; one for requests, one for our database of constituents, and one for the types of requests we receive. When we receive a request, we create a record which describes the issue and link to the person who submitted it as well as to the type of request. Our type of requests (ToRs) contain instructions for how to solve the issue. Our current process has us copying the information from ToRs into an email to the constituent. My goal is to create an automation which pulls the instructions from the ToR and sends an email to the constituent who created the request. Basically, we review the request and if it doesn’t require any personalization, we could click a checkbox and it would send. I have the logic setup. The problem is that the information about the ToRs exists in a long-form text field with hyperlinks to city web

Hey guys, I’ve been really struggling with this for quite a long, hope you can give me a hand. I’m aware, that those questions have been asked already several times here, but still I couldn’t apply any of proposed solutions to my case. I have table A where I’m adding booking numbers. There are also several “special” booking numbers in table B. Whenever in table A there is a booking number, that already exists in table B, I want to have it tagged/highlighted in the next column (in table A). In the same table A, I’m adding a notification numbers. Whenever I add the notification number that already exists in the same table A, I want to have it highlighted in the next colum. Thanks a lot

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: Delete a record by automation Scripting extension I am looking to Run a script in an Action. basically whenever the Category “Done” or “Postpone” is set to the record by single select field. I like to run a script that deletes those records. The trigger is pretty much easy to do by the automation configuration. The script is the one I didn’t figure out how to do. Can someone help me figure out how to make this work? Thanks for your help :slightly_smiling_face: Gabriel

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: BundleValidationError Validation failed for 3 parameter(s). Collection can’t be converted to text for parameter

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