Automations

Hi everyone, I’m sure this is a common question but I didn’t find a neat solution. We send weekly emails using AT Automation triggered by a schedule. This searches for new project created over the last 7 days and sends an email with the HTML grid view. Occasionally there are no new projects and so it sends the email without any data. Is there a neat solution for this ? Cheers

I am unable to send email when base is closed while on testing automation it sends mail thanks for your help

Hi I have specific mails to be sent to all the records depending on what day it is and it has to go at a Specific Time. Eg If today is Monday, a Mail drafted for Monday should go to all the records exactly at 10 am. On Tuesday, mail drafted for Tuesday to go to all records exactly at say 4 pm. Basically everyday checklist based on which day it is. What did I do? I created a Day Field and added Sun, Mon, Tues… as value. Created separate automation with specific day mail body. Created a Trigger condition if Day Field changes to “Mon”, send a Monday Automation mail body to that particular record. Same way for each day created a Condition and Mail body. Manually, at 10 am for all the Records, I have to change the value of Day field to “Mon” so that it is fired at that time. Next day manually change value to “Tue” at 4 pm. Now, I need a solution to make it really automated. Either everyday at the specified time all the records should get a mailer. Or Automatically change Field values of

Hi, Is it possible to use a variable as a condition on a form, or is there a work around?

Hi guys! So, first time using the community part of this. I have an automation that notifies me when a certain document expires, so it basically just checks for an expiry date. However, I’ve run into the following issue: A document is set to expire on the 1st of August 2021 (01-08-2021). In the interim, and before it expires, I get said document updated, so that it now expires 1st of August 2022 (01-08-2022). While I’m editing the date of said document, the field that does the date-check then sees that I’ve changed it to a “01-”, and thereby thinks something has expired and then shoots out an e-mail via the automation. Has anyone encountered a similar issue, and did you find a solution for it?

I have connected and tested the SMS App from Airtable with my Twillio. That works. However, what I actually want do do is track the actual message I send by logging it in my messages table. There appears to be no way to track this? Can anyone help I’m new to Airtable but it is important I track the outgoing messages

Hi all. I’d like an automation so when two columns show specific criteria (e.g. KNOWN CLIENT and PRODUCTS) this creates an entry in a third column with “PRODUCTS NEWSLETTER”. I’d then like a further column showing when “PRODUCTS NEWSLETTER” was added (i.e. last modified). I need this as it’ll run a Zapier automation and input the customer data into Mailchimp. I had successfully created an AND formula but this didn’t seem to link to a ‘last modified’. I’m trying automation but I don’t understand the steps. Can anyone help? Thanks so much.

Hey everyone, I need help with deleting a single record using script. We want employees to be able to delete a record in Airtable by selecting a checkbox in STACKER. Here’s the flow Employees selects checkbox in Stacker Airtable automation triggered based on checkbox deselection Script triggered to delete the specific row Any help is appreciated, thanks! Jake

I am trying to group my line items by campaign but whenever I create a new campaign name, it automatically generates a new line item with just that campaign title in my empty/null cells section. If I try to delete that line item, the entire campaign gets deleted and my cells become ungrouped. For example, if I link my calls called “Apple”, “Blood”, and “Clifford” to a campaign called “Red”, they are grouped together but the system also generates a line item called “Red” that appears in the null cells box and it won’t let me delete it without it automatically deleting and ungrouping Apple, Clifford and Blood.

Hello, With an Airtable apps, I generated QR codes in order to label the products in my stock and improve my follow-up. So, I need to print them on label sheets, but I don’t know how to do it (one QR code in x copy per sheet) Can you help me please? Which third-party tool to use (word, google docs or other)? How to send the information? Thank you in advance

I’ve been experimenting with the Airtable - Hootsuite automations. I’ve been able to schedule posts for Twitter and Facebook. I haven’t been able to schedule Pinterest pins. Has anyone been able to schedule a Pinterest Pin using Airtable’s Hootsuite integration? There doesn’t seem to be a way to specify the board a pin should be posted to. I’m guessing that’s why I am having trouble scheduling my pins. Thank you.

I don’t know how to officially request a feature, but I think it would be grand if I could move automations around in the list, rather than have them listed in the order they were created. This would make organizing long lists of automations much easier! While I’m at it, can we also get a “duplicate automation” button or a copy/paste? I often have to create several automations that are *slightly* different and being able to duplicate or copy/paste would save time.

I am building a somewhat advanced Base. Base functions “live” in Beta-mode. However, any tinkering with proposed changes is done on identical copy of this Base, the one in “Test Mode”. Question 1: is there an easy way to move/copy an automation from Test to Live ? Currently we resort to copying Automations “by hand”. Question 2: is there a way to convert a created Automation to Script? without writing out the script ?Then I would just copy/paste the script with minor edits

I created an automation to trigger when I change a Status in one of the field. I tested the with old mail id. It was working fine. I tested with my new official mail id. It was working fine. When I switched on the automation, out of 300 records, only 100 successfully triggered. Rest of it failed… I am getting this message in reason for failure. “This automation is no longer authorized to use the configured Gmail account. Please select a new Gmail account for this step.” I again Tested it with one record. Its working. Kindly help. Bala

I’m using Airtable to send personalised emails trough gmail with zapier. I used to fill one field with all the text of the email formatted in html. I was getting the field number from zapier options. It was looking like this : {{71809321__Name}} Zapier no longer give the option to get the number of a field, but only automated picking of a field. Do someone know who to get this code number ? I’m a newbie with coding. Thanks for your help. My html email was looking like this : Hello {{71809321__Name}}, Here is the link to yours documents : {{71809321__Link}} Can you tell me if the option {{71809321__Option Choice}} is fine with you ? All the best, Sébastien

Dear Community, I am thrilled about the automations but I am banging my head against a wall when it comes to date feilds and I am hopeing you all can be of assistance. I have two Bases, one for Orders Details and one for Order Fullfilment. The Order Fulfillment base has a synced table pulling the orders in from Order Details. The Orders have delivery dates attached to them. Deliveries go out each day on one truck and there is data that I want to collect for each delivery date, so I have created a table in Order Fulfillment to list each Delivery and the primary field is Date. I then linked the Delivry table to the Orders table. I then tried to create Automations so that when a new record is created (or updated) in the Order table, the Delivery Date feild would automatically populate the Linked field to the Deliveries…thus either linking the Order to that date’s Delivery record or, creating a new Delivery record because there is not yet a Delivery record for that date. However, I have no

I have STARTTIME, DURATION,CALCULATEDENDTIME and ENDTIME fields. After entering values for STARTTIME and DURATION, the CALCULATEDENDTIME adds the two. My automation is setup to trigger when a value is entered into DURATION, and copy CALCULATEDENDTIME to ENDTIME . Here is the problem: automation does not read the complete data entry, just it’s first typed digit!!! The CALCULATEDENDTIME does the DATEADD with each digit I type- ONE DIGIT AT A TIME!!!, and automation thinks I’m done. Example-if my STARTTIME is 12:00 and DURATION is ‘60’ minutes: CALCULATEDENDTIME changes to 12:06 immediately upon typing the first digit of the DURATION (the ‘6’), the automation then triggers and assumes the CALCULATEDENDTIME is complete. I continue typing the DURATION (‘0’), but the trigger is already executed. Any suggestions to have it work with the complete entry?

Hi there, lots of updates have been done last year and i was wondering if it is currently possible to get a link or pdf of the Page Designer block into with every record now on mobile? Perhaps an automation which i can create on desktop which then would work when using the mobile app. Thank you.

I have an issue that was working fine up until today and for the life of me I can not figure out what broke. I have a table of dates I have a table of events I have a table of games played at events When a game is added to an event I create a new record of it in my game list to get the Game + Date of Event so I know when it was played. Previous I was then able to copy the date from the event into the date column via automation but as of today it keeps telling me that the link can’t accept the format. So you are clear the first column of the Date table is the date field and what I am trying to copy in is a date field. Also this worked fine up until today

I am trying to set up an automation to change the status of a project from “currently active” to “past” if the date entered in the end date field is before today. Yet when I create a new record with an end date in the future, the automation I’ve currently set up still changes the status to past and I have to manually change it back to currently active. I have turned off the automation for now until I can figure out what’s wrong, but would appreciate help figuring out why it’s not working correctly. Here are my parameters in the attached images. Thanks for any help you can provide! Update: I’ve determined there’s a difference in how the automation responds based on whether I start manually typing in an end date, or whether I use the field’s calendar to click ahead to the date and select it directly. Starting to type anything in the date field automatically makes it assume the date will be in the past, whereas selecting a future date with a click instead doesn’t trigger the automation.

I have a linked field value in a base that’s populated by an automation - basically it’s copy pasting from a google sheet and important industry values, and I need to map these to our internal values. So I have a value that comes in like “Energy, Chemical, and Utilities”. My linked field is set up so as to not allow lining to multiple fields, and yet when this value comes through instead of being linked to one field my value is suddenly being linked to 3 new fields - Energy - Chemical - and Utilities. I need a simple fix here! I know I can use a substitue formula + a copy paste automation, but that seems like a A LOT for what should be the behaviour I set up for, no linking to multiple fields! If you can suggest a script that I can check out, or an automation, I would rather not have several too many fields to solve this. Thanks!

Hey all, I’ve run into an interesting problem with AirTable. I have an automation script thats finds all records from today and emails those records with the “Render as HTML Grid” option. Some field values are truncated, and I couldn’t find a way to affect the row size or CSS rules that are causing this to happen. For example: For example, there’s a parent <div> that wraps the table enforcing a max-width of 1000px (and overflow-x: auto!) and inside of each <td> element, there’s rules for a max-width of 250px and overflow: hidden. Parent <div> of table: <td> rules: Since I can’t modify AirTable’s restrictive CSS, can anyone give me some recommendations on how to work around this with 3rd party apps or Zapier integrations to use for this specifically? The truncated table text is the only real problem I have here. :open_mouth:

Hi, I have an automation set up to post in slack when a new record is created. When I test the automation, it posts correctly, but when I set the automation live and manually create a new record it does not post. I updated the automation this morning to use the new Form Submitted feature (which is really what we wanted originally) but the same issue occurs: the testing posts, but it does not work when live and a User submits a form. Any thoughts?

Hello! I’m trying to use Airtable Automation to publish a tweet every time there are new records that match some conditions. It was working well when I was testing it last week until today, when I received a Twitter error. Screenshot of the error: The problem is that I don’t receive any other information. Could you help me discover what is happening? (BTW, first I had a problem when publishing a tweet with an image (it was a correct image but it said incorrect size). But after removing the image from the record I received this other error. Thanks!

Can automations be programed to send to outside emails that are not current users of airtable?