Automations

Hi all!Maybe someone has solved a similar problem.I'm making a kind of task tracker, but I can't solve the following problem. I want to do the following in the task picker interface:1. You can select a record from the database (already done)2. For the selected entry, using the button, you can create a related task entry, which will be linked to the firstHow to solve the second point? I tried different variations of automation, but nothing worked for me

I created an automation with a Webhook trigger. When calling that webhook, I want to run a script that reads the webhook data (POST) and use them in my script. I haven’t found how to do something as simple as that so far. I’m starting to believe this isn’t possible.

So, I have contacts that have been pulled into Airtable from different sources (Active Campaign, Google Form, etc). Each data source is in it's own table and I have created a fourth table where I have pulled in EVERYONE using automations, lookups and roll ups. I have then grouped the view using email address and what I now have is a brilliant view of a single contact and how they are involved in our company. In my example below, I can see that she is a 'Puppy Handler' (pulled in from google docs data) and she has also subscribed to a few of our marketing emails (pulled in from activecampaign)... However, autonumber have given her 5 different ID numbers as she has a total of 5 entries within the base... is there anyway I can create a singe ID for her using her unique email address as the unique value???

Hello! This isn't the most important thing if it's not possible, but I'm embedding multiple lists into my email automation. (Based on each piece of legislation's changed status.)I'm wondering if there's a way to hide the plain text when it corresponds to a grid that returns empty. For example, in the below, if only the heading "Floor Vote Result" could be displayed/sent, since it's the only grid that returned content, while the other headers would be conditionally hidden. Any tips? Thanks!

I keep a large database of images in my Airtable. The jpg files include "document title" and "description" in the metadata. I would like to automatically insert that text into different fields in my table.The closest thing I can find is this EXIF extractor api but as far as I know this is different from the metadata in my jpg files (am I understanding this right?).This seems like a solution others would be interested in so I'm surprised I'm struggling to find information.

I am using the Update Record action type in airtable automation. However what I notice is that it completely replaces the existing data in that cell and overwrites it with new data. Is there a way to update the record by appending new data to the already existing data without overwriting? The field that I am updating is a linked record and would already have some ids existing. I just want the update record to append new ids to the existing list.

Hello!I am having issues with automation emails showing they've been sent in the base, but are not being received by the users. This issue just started to occur. Automation shows "on" and run history shows that they have all run successfully and that the email sent was successfully completed. This is the first time experiencing this issue. Please advise if possible. Thank you!

We are completely maxed out on automation runs! This is because Airtable hasn't reset after last month. On December 31st we were at 80% which is too close for comfort but with it only being a day until it should have reset we weren't worried about it. Here it is on January 3rd we're dead in the water!!!!!!!!! Obviously I cannot get immediate help from Airtable Support. I've talked to their sales department about upgrading us to an Enterprise plan but this is not immediate. Anyone have experience or know what to do? Maybe you've got a contact on the inside that could reset our automation runs for the month. How is this not automatic?!We have business critical functions relying on our Airtable. 

Hello to all my colleagues,The query I have I think is kind of stupid, because it should work as I am configuring a button in an interface, so that when it is clicked, it triggers an action that in my case is to run a script. I am following the instructions posted at:https://support.airtable.com/docs/when-a-button-is-clickedI am blocked at this point "Connect the automation to an interface".The problem I have is that I can't select the action to follow when someone clicks on the button, because the option "Run automation" does not appear within the options to select. Only the following ones appear:- Open record creation- Go to interface page- Go to external URLIt is supposed to appear within those options "Run automation", and after selecting it, link it with the automation process that I have created.I don't really know what could be going on, so I would be grateful if you could help me, I would appreciate it very much.Thank you very much for your help.Luis

Hi there - all my automations are failing. I have disconnected and re-connected my gmail accounts but they are still failing to run. Can anyone offer a suggestion on how to fix this - I'm pretty new to Airtable but hope I can understand the solution to fix this. 

Hello,I am trying to set up something so simple, but AT is making it so complicated.All I'm trying to do is:- When a new record is created- Find a previously created record with the same CUSTOMER NAME & PHONE NUMBER - (while also looking to see if one of 2 checkboxes are checked)- If the NAME, & PHONE NUMBER are the same, and the previous record has a checkbox ticked, then add that checkbox tick to the new record.(If the checkbox is unticked, leave the new record unticked as well)I've gotten the automation to halfway work, but it is adding the new checkbox tick to every new record even if the previous record doesn't have a checkbox ticked.This seems like such an easy automation, but I've tried using "When a record is created", and "When a record matches conditions", I've tried doing the "find record" step in between the update record step, and without, but nothing is working.Please can someone walk me through how to set this automation up?

I have an Airtable Base with a document upload field. I take the URL of the documents and map that to a JSON to pass through an API.Sometimes, users will upload multiple documents to that table. The output URLs are in an array. I have a pdf module that will combine the PDF files into a single URL. I just need to map all the URLs in the array to the module.However, I am having a very tough time doing this. From the Airtable module, I can only map the first URL in the array. If I use an iterator, I cannot map each iteration in the same module. If I put the pdf module after an aggregator, I can again only map one iteration. I cannot set a variable of both iterations in between the iterator and the aggregator. I tried setting a variable but ran into the same issue where I can't map more than one iteration.I solved this issue in another scenario with email attachments by creating a Drive folder, uploading everything to that drive folder, and sharing a link to the folder.But I can't do that

Hello everyone!I have a table, where each record has field with complex info - object, or stringified object, doesnt matter. Lets call this table - T.Can basic automation do either: a) I have a linked field to T in another table, so its content is Array of record_id`s from T. Can i select and iterate such array with automation ?b) Compare complex field content for each record in T with Example, stored in another Table ? (Compare like a string)or i need Scripting capabilities for that?

hello!we have multiple airtable accounts with creator permissions for a base. what's the visibility of connected accounts? can a co-worker create an automation using a connected account that I connected? it seems we cannot see each others connected accounts. how can we share this?

Hi all.I've created an airtable that is populating customer subscription changes via a Zapier integration with our revenue tool, Chargebee.The changes occur in the "Subscription Status" column in the airtable base:This is working, however when I try to create new views dedicated to those subscription statuses (active, pause, cancelled, and new), those updates aren't occurring in those views.Eg. the second record you can see in the screenshot is a new subscription that I created, then paused. Both of these actions were recorded successfully.However, the subscription itself is not appearing in either the new subscription view (after creation occurred) nor the pause subscriptions view (after pause occurred).I tried two methods: duplicating the "All Subscriptions" view, and also simply creating a new grid view.Is there a simple step I'm missing to link new views to the original one? 

I am working with a Marketing Agency that is using Airtable to manage task work. Currently, we have a table with tasks, grouped by frequency (daily, weekly, bi-weekly, monthly, quarterly). For each task, if the task is applicable to a client - that client is linked to the task with a linked record. We currently have automations, per client, to create tasks by frequency (using time as the trigger and finding the client record and checking for the applicable tasks that match the frequency). This means that for each client, we have to have a separate automation for each frequency to ensure tasks are generated for the client ONLY IF they have that task included in their applicable tasks. We are running into our automation limit (50 per base) so I need to find a solution and I'm wondering if there is a better way to automate the task creation while retaining the functionality of only generating tasks that are applicable to the client. I'm open to suggestions for restructuring the base

Happy Holidays everyone! I have a table that includes columns for both Start Date and End Date. Date format for both date fields is "Local". My gmail automation is setup so that when 'today' is 10 days from the End Date, the client will receive an automated email.This example, the End date is January 6, 2024 and the email automation triggered December 26th, which is 11 days from the End Date.How can I fix this so that it triggers when 'today' is 10 days from the End date? 

How can run the python script automatically if we update any record in the airtable.

HiI have a script which exports data from Airtable to Make.It exports 3 record columns in total.The trigger is a new created record.The output returns the same record every time, which is not even the newest, just a random out of the list.I'm quite clueless at the moment and appreciate any assistance in this matter. The script is attached: let apiKey = 'XXXXXX'; // Replace with your Airtable API keylet baseId = 'XXXXXX'; // Replace with your Airtable base IDlet tableName = 'Data'; // Replace with your table namelet integromatWebhookURL = 'https://hook.eu1.make.com/lltvxgqpxuvehximley444ibk3vcqkw9'; // Replace with your Integromat webhook URLlet table = base.getTable(tableName);let query = await table.selectRecordsAsync({fields: ['Quote Number', 'ID', 'Client Name'],sort: [{ field: 'Quote Number', direction: 'desc' }],});if (query.records.length > 0) {let record = query.records[0];console.log('Client Name:', record.getCellValue('Client Name'));let dataToSend = {'Quote Numbe

Hi Airtable community! New user here,I am working with three tables in Airtable: 'Families,' 'Codes,' and 'Vases.' Each family in the 'Families' table can have multiple codes in the 'Codes' table, and each code in the codes table can have multiple vases in the third table. The objective is, for each new record, to automatically generate and assign unique codes for each family in the 'Codes' table and each code in the 'Vases' table. When assigning a new code, Airtable should automatically tell me the last code used for that family and assign the next one (for example if xxx-1 exists already, then assign xxx-2) The code format should include the family number followed by a numeric increasing value (e.g., 1, 2, 3). The count should reset for each family, ensuring that each family has its sequence of code numbers. The goal is to implement script in the Airtable Scripting Block that triggers whenever a new record is created on the codes and vases table, ensuring the proper assignment of the

Thanks in advance for the help - unsure if this is an automation, lookup or sync question.I have two tables in my base that I need to somehow link.Table #1: Content calendar, where posts are to be planned and marked as "ready for approval" Table #2: Task Management, where ideally, once a post in the content calendar table is ready for approval, would automatically be populated into this table with the same info. I would ideally like to be able to switch the status to approved here too and it would be reflected in content calendar. I would also need to add tasks manually in this table that aren't related to posts. I've played around with automations and lookup fields but am at a loss for this one and may not be expert enough to fully understand lookups. Do I need both tables to have exact same columns? Thanks in advance!

I've got a table that has a single select field. I'd like to parse all records in that status by airtable user, and send that user all records in 1 email once a month.I've got this worked out kind of, but it emails each per matching record - I'd like to make it send 1 email and include all records. Screenshot is what I'm doing that emails each record to that airtable user.  

Hi All,im trying to create a button in an interface, of which the interface has a project record picker, that will trigger an automation, to find records in another table.the project picker is set to a particular table called PROJECTS.the button is set to find records in a table called PAYMENTSwhen creating the button and setting up the automation, the conditions of the FIND RECORDS option can set up all the requirements but won’t limit to the particular project that the Record Picker has selected. In fact it won’t let me have any condition relating to the PROJECT. When I test, it picks all records not limited to the PROJECT. Is there any way to let the RECORD PICKER limit the button automation selection… eg.Record Picker: set to PROJECT number ‘100’. So all records assigned with project number 100.Button set to find all records in PAYMENTS tab with other conditions, but can’t set it to only also find records assigned to project 100…? Thank you

Hello Community.. I hope all is wellI built an Agenda database that has recurring events such as "Daily Lunch Time" and "Weekly Team Meetings" etc.. Keep in mind that new Agenda items with new frequencies keep adding up. Setting a recurrence automation is possible, as a new record of the same Agenda item gets created every time the item is marked done. But what if I need to see the items for the whole year from now, without waiting for the items to get done, and without having the automation run endlessly? I have been looking at a formula or automation for recurring events with different frequencies while having an stop date for the recurrence. would truly appreciate your support if anyone knows a perfect hack for it without the requirement to write a coding script (as I am not experienced in that) neither I hope my question is clear. I truly appreciate your support.Best,Hamda

Hi everyone,I need some help to build some automations please.I would like to modify status after specific period.For example, when a new record is create, the field "creation date" fill be filled.for records below 3 days I want to automatically change the status to "Less than 3 days"for records between 3 days and 5 days I want the status "3 to 5 days"records between 5 days and 10 days, status "5 to 10 days"and below 10 days will have no status. I already tried to make automations with "on this date or later" and "on this date and earlier" but it's not working properly.Thanks for your help and merry christmas!