Automations

Hi everyone!I want to send email to our customers in which I want them to choose between two options (buttons). "YES" or "NO" depending if they agree with the cost of repair for their product.How can I build this buttons and email so that I can get their choice direct to the AirTable? I already have one single select field with yes/no option. But I don't know what to do next.Thank you for your help!

I have built an inventory management system, where each item is a record in a table. I was able to add an extension that creates a QR code for each record and saves it as an attachment in PNG format.  The intention is to print that QR code on a label, then stick it on each item in my store room. Once someone extracts it from the store, they scan the code and mark it as "OUT" to keep inventory up-to-date.My main issue is to create a way for the QR codes (PNG attachments) to print. Ideally I would like to have a button that uses an extension or script. Once you click the button, it prints the QR code for that specific record only. Does anyone have a suggestion on how to achieve this?

I'm not normally a scripter, but just spent two weeks trying to put this little routine together and make it work. The script calculates the date one year in the future and uses it to rename a new column in the format MMM'YY.  After loads of trial and twice as much error, I actually got in to work!:Naturally I was really pleased with myself! Now just to apply a trigger. I want it to run on the first of each month. My first idea was to paste it into an automation. But I soon discovered that scripts run from the automation cannot create fields.How frustrating! Why not? Can anybody think of a workaround? Is there a command I can put in the script editor to make it trigger on a regular interval?Any ideas or workarounds gratefully received.

I have a script that I'm using to update records in my Airtable base, but it seems to be taking longer than expected and sometimes hangs indefinitely. I'm seeking assistance to optimize the script for better performance.Script Description: The script aims to update records in the "Tasks" table of my Airtable base. Here's what it does:It retrieves records from the "Tasks" table, selecting specific fields: "Predecessors", "Tasks", and "Next task".It filters the retrieved records to find tasks that don't have any successor tasks (i.e., "Next task" is empty).For each of these final tasks, it traverses the chain of predecessors to update a field called "Milestone Name" with the name of the final task.It performs updates in batches of 50 records to avoid hitting Airtable API rate limits.Code:async function updateChainWithFinalTaskName() {const table = base.getTable("Tasks");try {const query = await table.selectRecordsAsync({fields: ["Predecessors", "Tasks", "Next task"]});const finalTasks =

Hi! 2 things…I’m trying to find a workaround so that when you being typing in the address field, the address starts coming up like in Google maps. I have the map extension installed and can not figure it out. From what I’m researching it’s not possible? Also, relating to address mapping… here is my other scenario…Im creating this for a cat rescue and we perform mass trapping also. While in the field and a cat is trapped is there a way to snap a pic, create a new record and in the location field have our location populate? thanks! 

Hello everybody,For my personal knowledge, I want to create an automation to send emails in mass to the interlocutors but one email per person. I mean : 1) How do we automate to send an email to each of the freelancers? So in “To”, there will only be the freelancer concerned?In the Find Record, I wrote (See screenshot 1):Where freelance is not emptyand Status is "A rédiger"and date-publication is todayWhat I understood in human language: "Hey Airtable, you will do something when the Freelance field is not empty, so when there is someone to identify and the status is "A rédiger" and that 'in addition the publication date is for today'.Then I configured the email by saying (See screenshot 2):To: List of "freelance" and "List of Name".Human language: Send to the list of email addresses identified in the freelance field.Messages: "blablabla"...Grid of records: “post_idee” and “freelance”Human language: A table with the post ideas in the first column and the freelancers identified with

Hi,I'd like to ask how many emails i can send through automation triggered send mail action.I've read other posts and threads but i am still confused with the wording of Airtable.it says I can send any number of emails to collaborators with verified emails.and also i can send email to 100 unique non-collaborator email address per day.In scenario, I send task notification email to "A" non-collaborator email address, and then sends task assigned email to "B", when "A" completes and changes the status, and if it sends completion email to both "A", and "B" then would it still count as 2 unique collaborator, and i still have 98 more unique non-collaborator email address room left?Just want to clear up this before i start mailing stuff through the automation.Thanks

Hello, I have a DB ~15,000 records. I wrote a script to merge and delete records. It compares three data fields for duplications and combines the duplicate records. It also will merge data from two other fields if the fields are not empty. I tested my script on a 500 record DB and it works fine. When I test on a 2,500 record DB it times out. Can someone make any suggestions on how I can cut the execution time on my script ? I've seen posts about using a hash index, but I don't think that would work for what I want to do. Because I need to iterate through all records to find duplicates. If I'm wrong I'd appreciate insight.   var table = base.getTable('Testing_Dupes'); var query = await table.selectRecordsAsync(); //find records with a duplicate (first name, last name, residence) let dupli = query.records.filter((record) =>{ return query.records.find((potDupe)=>{ return record.getCellValue("First Name") === potDupe.getCellValue("Firs

Hello,I would like to ask whether is possible to copy linked connection between two tables with automation?I have three tables:1. Summary - here I would like to collect prices from Payment and VAT from Invoices2. Invoices - here are list of invoices, each has at least one connected Payment.3. Payment - list of payments with specific pricesIn Payment table I manually connect each payment to specific Summary.What I would like to do is automatically create/update Summary field in Invoices table with same linked connection as I do with Payment, so in Summary table VAT can be calculated. I tried it with automation, but probably I have mistake somewhere in the action..Hope I explain it clearly, here is link to my sample base - https://airtable.com/apphUNbqkv8pDYRGS/shrdfftFVSqakQLawThank you very much

Hi everyone,I'm new to Airtable and I'm trying to automate the process of updating fields in a primary table based on records filled out in a secondary table. Both tables share the same ID for each record. The primary table serves as my master record, while the secondary table contains five fields that will be completed via a form. I'm pre-populating the ID in the form to ensure consistency across tables. However, I'm struggling to find a way to automatically reflect the updates from the secondary table in the master record table as soon as a new record is created. I feel like there should be a simple solution, but I haven't managed to figure it out yet. Any advice would be greatly appreciated!

When an interface button is used to trigger an automation, does it leave any kind of trail in terms of date clicked?I am making an interface for a staff member to generate a draft contract, but she needs to do it only once. Since the button is so easy to click, I am afraid of it being generated multiple times. I thought I could somehow put a field showing below it of the date the automation ran. Thanks!

Generally, I've been very happy with Airtable's documentation and what's available in the community.  Not so much with this issue.  I see posts ALL OVER the community about people needing to query a table or view and filter their results (like a typical WHERE clause in SQL).  This is one of the most common questions/issues I see, and yet the support from Airtable staff on providing very clear example code for accomplishing this is between abysmal to non-existent.  I'm no genius, but I'm fairly bright.  Trying to figure out the exact syntax for accomplishing this from the info available is way to difficult!  Come on, Airtable!  Help us out!I'd like to see a new section that supplies plenty of specific script code samples for the most common query filtering, such as...1) A basic string field "where FIELD = 'Some value'"2) When multiple fields need to be included . "where FIELD1 = 'value' AND FIELD2 = 'somevalue'"3) When your filtering on a Linked Field4

I have setup an automation to create a new event in Google Calendar. I need it to be an All Day event however, the automation does not create it as such. Instead it is adding an arbitrary time to the event, in this case 12pm.I am using the same Date field from my table as my Start and End times and the date format in the table does not include time. I am also including the same Date field in the All Day Event option when configuring the automation.Does anyone know how to create an All Day event in Google Calendar through an automation?(I do not want to make the Start Time 12:00am and End Time 11:59pm, it does not create the same type of formatting that an All Day event has on GCal.)

Hi hi.I'm stumped. I set up a ridiculously basic automation for a client to send an email at a scheduled time. It's set up as follows:Trigger: at 9:00am on the 15th of the monthAction 1: Find Records that match a condition (billingStatus = Bill By Month)Action 2: Using the records that were found in Action 1, send one email per record. Each email has my client's email address as both the bcc: and the Reply To email. The Run History shows that earlier today, the automation ran once and 4 emails were sent. But my client got 6 emails! 2 were correct and only were sent once = yay; 2 were sent to the same email address twice - one with the right information and one with the wrong information = boo. So it's not happening every time to every email.The attached multipleEmails picture tries to tell the story of what my client sent me using yellow and blue arrows. The emailExample picture shows a redacted view of the automation run history: each client has only one email and that one email

Hi. Sorry, but I'm struggling to know how to do this. After my automation sequence, I want to update a date field with todays date to show when the automation ran. I've searched hard here, but I cannot find a way to do this. I've tried a formula in the chosen field to update, but formulas don't seem to be accepted in the 'update record' module.

Hello, I am trying to set up an automation that is sending out all our Purchase orders as an email via a shared distribution list.I can link my account, but I do not have the option to choose the "send as" Example: me@test.com  is my account and I also have access to the procurement@test.com distribution list. I log into my account in the "send email via gmail" automation, but after that it is linked to my private email. I can choose the distribution list as a sender via Zapier, but I would like to cut that out. Thanks for any help and advice

Hi Everybody! since start of the year I've noticed a change in the behaviour of one automation, that is causing me a lot of trouble.In a table I've a formula field that generates the ID necessary to link the record to another one in another table. The automation copy this formula field in the link field and the association is done. The link field as the selection limited to a specific view. Up until recent, this automation as worked very well, but now is not selecting the linked record only in the specific view, but outside of it.Sadly in the table that need to be associated, there some ID that are identical, so the association is not correct anymore. For this reason the selection on the link field on the first table was limited to a specific view, and it worked just fine, but now is not the case anymore.I know that the better solution would be to change the formula that generates the ID of the second table, so that they are unique, but this have implications on all the base, and

Hello! I have 2 tables in my database:'Employee Directory' with fields: Name, Seniority, Department, and Email.'Equipment Requests' with fields: Request, Employee (linked), Department (lookup), Email (lookup), and Status.I would like to create an automation where, upon the creation of a request (trigger), an email is sent (action) to the manager of the same department where the employee works.After setting up the trigger ('when a record is created'), I attempted to configure an action ('find records') that operates on the 'Employee Directory' table, finding records based on a condition. The condition should be 'where Department is' some dynamic condition. However, I am unable to select a dynamic item for the Department; it appears grayed out and states "Cannot assign list of string to string".Could you please assist me with this issue?

I am using Airtable's "Project Tracker" template which has two tables: 📝 Tasks, timelines, and assignees and 👀 Overview.I adapted the template to my team's needs. I want to accomplish the following,I want my team to update the status column in the 📝 Tasks, timelines, and assignees table.This table is organized so your tasks are grouped by project. There will be multiple tasks per project.In the Overview table, you can see the projects.The 👀 Overview table has a status column (or field) that should automatically update to COMPLETE, when all tasks under the project in the  📝 Tasks, timelines, and assignees have a status marked to COMPLETE.I'm not even sure if this is possible or how to go about doing this. Any ideas? Screenshot of the 📝 Tasks, timelines, and assignees table highlighting how tasks are organized by project and the status column. Screenshot of the Overview t

Hi all!I have two tables, the first is Stores, the second is Customers. They are linked. Customers has a Region single select, Stores a Region multi-select. All of the Region single selects are populated for the Customers tab. I need some help creating an automation or bulk update for the regions of the linked Customers are visible in the linked Stores region field. Thanks in advance! 

For the automation above, I kept getting an error OR inaccurate output. When I would test it out and submit a 90% score, it keeps creating a record as if the score was less 89.99 

Is it possible to add color to the automated email body copy. We are hoping to emphasize certain areas of content to our partners through the use of color. Thanks!

 [SOLVED]  Thank you for your help!UPDATE:I resolved the syntax issue.Hi Everyone! I just need help with the search filters.  TYI am getting an error message, when I run my scenario: “The operation failed with an error. [422] The formula for filtering records is invalid: Unknown field names: 321” I need help with:Airtable filter in the Search moduleI don’t know what the make.com filter syntex is for searching records. I am not a programmer, so I will need step by step instructions. The unique ID is SCOTT #. TY 2. Creating filters to avoid duplicate records in my Airtable base, in Make.com for: 1. New Records 2. Update records These search filters will be in the same scenario. I am using a Google sheet for all record data, there are new records and existing records in one Google Sheet. I am attaching screenshots. Any help would be appreciated. I am just starting to use make.com a bit more now and to me, it seems to be a bi

HiI tried to get all the records in a table by the associated User.Im used make.com to get this information and when I entered this formula and is not working - SEARCH('user_email@example.com', {user_field_name})Does somebody know what is the correct formula? 

Hi,I've created an inventory and order system using airtable but I'm being held back from having airtable calculate my order cost using a roll up. We sell some products with a special offer, for example, a hoodie normally costs £30 but if you buy two it costs £50. Another example, a pin badge costs £4 but you can buy three for £10. I thought this would be really simple to implement but can't seem to work out a way around it and I'm not clued up on writing formulas.Any help would be appreciated, thanks.