Automations

Are the record's previous values available in the "when record is updated" trigger?  I'd like to be able to compare the previous values with the current values and act accordingly.  Does this require a code step instead?

I have a database with ages, I have grouped the ages into views and I want to shuffle each members a particular age into a group of five. For example: Ages 18-24, I want the members to be grouped by five members each and at the end of each month, the automation shuffle the members so the members are different for each month.

Hi,how can I add my email signature for the email automations? 

Hi,I am working with a list of contacts in my main spreadsheet. I am trying to update a specific information of many contacts simoutaneously. So I created a second table, where I want to input the name of the person, and this information (books received). I want to be able to add a list of people and books on this second table and add these books to the already received books on the main table.I was able to do part of the way, but I am having a problem with the Record ID after the Find record step. For some reason I only see the option of 'List of Airtable Record ID', which I think is why it is not working. It seems like a simple automation, but I can't go around it. Any suggestions?Thank you!

I'm trying to set up a paypal scenario in Make.com that adds new paypal transactions into my airtable table. When I try to set up the airtable connection, I use OAUTH type, and it asks for a a URI Redirect URL. I don't have a clue what to use here. When I google, it asks what site I want people to redirect to, but that doesn't help me much.Anyone able to advise?Thanks. 

I'm trying to use an automation in a base, but there's something wrong with my flow. And it may be that what I'd ultimately like to accomplish isn't possible. In Base 1, I have a single-select field named "Status" with various color-coded options as variables to select from. In Base 2, I have a duplicate of the fields in Base 1, but none of the data. My goal: When the single-select field Status is changed to a particular option (in this case, "Delivered"), the record is copied from Base 1 (Active) and duplicated in Base 2 (Archive). But the flow I have is definitely not correct. So, one, is this possible? And, two, does anyone know what I need to adjust in the automation flow? Thanks so much for your time!

Hi all,I want to expand a script that assembles an e-mail using a few field values and sends a nice and simple daily report to stakeholder.I want to add images inline from an attachment-type field. I use something like this:    if (clippings && clippings.length > 0) { for (let clip of clippings) { let imageUrl = clip.url; imageUrl = clip.thumbnails.large.url;    and later:     if (imageUrl) { entryText += `<br><img src='${imageUrl}' alt='Clipping' style='max-width: 100%; height: auto;' /><br>`; console.log(`thumbnail added: ${encodedUrl}`); }    I then pass my output over to the next step:    outputText += `${entryText}<br><br>`; output.set("emailOutput", outputText);    Although all URLS are definitely good (I paste them into the browser and

My company exports a .csv file every week containing the current inventory of the same objects.  Each object has a count that may change week over week.  We copy this .csv into an airtable weekly.  I would like to capture the old counts from the prior week so that I can track the differences week over week.  How can I set up a scheduler to move the values from the "This Week's Apples" field to "Last Week's Apples" field automatically?

Hi! I'm new at this. I want to send a scheduled email to a subgroup of contacts and pull in specific Airtable data into the body of the email and pull in the email addresses from the database. I'm using the gmail integration.In the "To" field I'm using the + to pull in email addresses from the base structure and the test keeps failing. It says "Invalid email address in the "to" field: fldU4hKNRZaMDR6U3".  The other fields in the body of the email that I'm pulling in from the base structure say FIELD ID instead of what the actual field name is and so I think those are also not working properly. I feel like I must be doing something incorrectly. PLEASE HELP. Is the email address in the To field what will act as my key to pull in all the other relevant data? I'm not clear if I need to set up a lookup/key mechanism here since the trigger is a specific time and not meeting a condition. To get to the subset of companies I plan to add a condition. THANK YOU!  I'm havi

I'm based in the UK and we've had an integration working on a booking database for over a year which automates the creation of an Outlook event when a booking is made. No changes have been made to this automation but today the events which are in Airtable as dd/mm have started coming through as mm/dd. I'm really at a loss with this and what I need to be looking into.

Hey there,First of all thank you for your time and your help 😉I've made some pretty basic automation, when a record matches certain conditions, I trigger the action "send mail" (airtable default one). The field "To" is filled with a roundup type of field which has a formula "ARRAYUNIQUE(values)". It keeps the unique mails attached to the record.My issue is that it works 30% of the time. The failure to run is always caused by : "The "To" input is empty"Which is not, the field is never empty, it always has one or several mails. And it being not empty is a condition to trigger.I can't find what's common to success or common to failure.Any ideas ? 🙂  

I'm using a Repeatable Group with an Update Record inside to take a list of records from a Find Records action and update a field in the found records. When the list of records contains only one record the test runs successfully. When the list of records contains more than one record I get a received invalid input error. I think I know why this is happening.If I look at the Input table after a test I see Record ID listed there followed by a single record id if only one record was found. If more than one record is found then I see Record ID followed by multiple record ids separated by commas. If this is what is being presented to the Update Record action of course this will cause an error. If I'm reading the documentation correctly the input from the Repeatable Group should be a separate Record ID followed by a single record id for each record found rather than a single Record ID followed by multiple record ids. Why is the Repeatable Group not presenting the Record IDs to the Update Rec

my kanban is a list of products with different stacks. I would like it so that when a product is moved from one stack to the other, the autmation sends a slack message as to what stack the product is currently moved to.How do I access the name of the stack? I clicked on the blue plus sign but nothing there relates to the stack name. Just the product details.

I've created an automation that follows this schema:The issue is that when it finds three matches in the name, it writes the name as many times as there are matches. I only want the name to appear once.I don't know how to achieve this.Thank you for your help

Hi,I have automated record selection and adding a fixed value to the existing values in a field. or example, adding a new category to the existing categories of a record. now I would like to have this fixed value as an entry from the user through a form or something else and then use the value in my automation. So the user enters the fixed value and selects the records he want to add the value to. How can I make this possible? Is there a dynamic variable that could record the input and use it in the automation?  Thanks

Hi!1. I'm working on an Airtable automation that uploads files using chunked upload from Airtable attachments to Google Drive. The process fails with the error:'Response status was 308 Resume Incomplete but redirect mode was set to error'The logs show the script:Successfully startsGets the Google Drive folder IDObtains an access tokenCreates an upload sessionFails when trying to handle the 308 Resume Incomplete responseThe error occurs during the chunked upload process, specifically when handling the resume/redirect status code 308.Can you help me understand how to properly handle the 308 status code in this context? Or session (chunk upload) is not supported by Airtable?2. Of course, I would choose not to use chunk upload and upload files one by one (some of them are 100-300 Mb), but I face the 512 Mb RAM limit. Maybe you can also tell me what file size won't result into an error upon loading to the RAM in full size? That would also let me create a script, that partially automate

Hi folks : )I'm trying to put a link in an automated email, and it keeps generating a sequence of characters at the end of the url that makes the link useless. Here's how I have it set up in the body of the email:Here's what the end of the url is supposed to look like:230526796288065/sign_document_d4deb6cd5dd95877_79e90063180a7cbf.pdfAnd here's what it looks like when the automation is done with it:This happens whether I set up the field as a URL or single line text, and the link opens fine from the data view; these extra characters only show up in the link generated by the automation email.Since the characters look like html encoding, I looked them up and found this, if it helps:%EF : ï%BB : »%BF : ¿How do I set it up so this doesn't happen? Or is it a bug that can be fixed?Thank you for your attention,Shawn

I have a table (Table #1) in which we keep upcoming events, along with their dates, topic, marketing content etc. I created a mirror table (Table #2) with the same fields. Table #2 has a form our staff uses when they need to update any of the events that are in Table #1 (existing records). I created an automation that when a form is submitted in table #2, it finds the records in table #1 that match the name of the program and then updates the existing record.Here's where I am stuck and wondering if there are solutions:1) Finding the records: My conditions are the name of the program and the date, but the issue is with the date. I'd like Airtable to only find it if it's the exact date in both tables and not a range of dates. Is there a way to do this?2) Updating the records: when staff submits a form, they may ask for the topic (field) to be updated, but will leave the content (another field) blank because that didnt change in their program. When the automation find the record

Hello,Currently, we use automations integrated with Slack, where we utilize the "actionable message" feature to allow users to approve or decline directly through Slack. We are now transitioning from Slack to Microsoft Teams and would like to know if the same functionality is supported in Teams. Specifically, can we enable actionable messages in Teams using automation?Looking forward to your guidance.Thank you.

I need the dollar amounts on our automated emails to be automatically rounded to the nearest cent. The automated email is pulling these figures from fields in airtable that have formulas associated already, and they are set to round to the nearest cent/hundredth, however when they come through on the automated email suddenly they include an extra place value "thousandth," and do not provide thousands comma markers or dollar signs. I do not know how to combine a ROUND formula on top of the formulas that are already on the fields. Can someone help? 

I can't figure out why an automation is not performing as expected.You can view the test base here: https://airtable.com/appvus4mpIsM95P1S/shrcfwha5Sx1NEui9Please see the Content, Tasks and Task Templates table.The logic behind the automation is that when the podcast status on the Content Table is updated to "In Progress," the automation will generate a set of tasks for that episode. The automation looks for records in the Task Templates table under the Podcast View and duplicates those records in the Tasks table.The automation is creating extra records in the task table and I can't figure out why. There is no pattern to the extra records created. I've tested and tested and it's not the same duplicate records each time the automation runs. The extra records created in the task table break the date dependencies."Start Date", "Deadline", "Duration" and "Predecessor" work as expected in the Task Templates table, but when the automation creates the records in Tasks table, those same d

I am trying to get this to change the retention stage to month 2 when then 1st day in the field is one month ago?I have done this and whenever I am testing and changing the 1st day in the field to over a mo nth ago it does not even register the trigger on the automation history? Any ideas what I am doing wrong here?

Hi Community,I've created automation for sending an email using the 'send an email' action and it doesn't work for non collaborator's email addresses.It fails each time with the error: "invalid email address"I'm using a pro billing plan, so it's not supposed to be a problem.Does anyone know what might be the problem? Thanks.   

Ok, This community has become my safe space and I appreciate all your help!Essentially, I have a list of content and I have multiple clients linked (with their emails) to each line item so a certain email can be sent to certain people on a scheduled date. My challenge? My automation keeps sending one email to ALL parties, thereby sharing email addresses. I need an email to go to each address. In the below pics you will see I have a 'repeat for each in List of records) and this is preceded by find records where Issue Date is today. The right records turn up, and the email works, but to my mind it is not actively 'repeating for each'.I feel I could drill down to the Client tab for that info, but I don't think I'm going about it the right way. Relevant Fields:Table 1 - Content - Send date, Lookup For Client (multiple records), Email (from Client)Table 2 - Clients - Customer ID, Email TIA,Chelsea

Hello there,I am very new to Airtable (just started two days ago) and I am finding that there are so many things that can be done here so I am very eager to learn. So TLDR, me and my friend has a small business where we need to find suppliers and ask for their quotations for bidding purposes. We have been very overwhelmed lately and want to leverage technology to help us automate some of the jobs. I have a problem with configuring the database right and would appreciate any insights from you guys. Working Process:Currently, our working process is quite redundant and consumes so much time. So first, the purchase request will be decided by us on what items to buy. Then my colleague will print out those items (Row) along with some potential suppliers (columns), then we will work together to pick which supplier we will ask for each item. Also it should be noted that in each box, there may or may not be past price (if we ask them for quotation before). After that, my colleague has to t