Automations

I'm pulling data in from a Google Sheet into Airtable with an automation that was built by someone other than me. When importing, it sometimes maps incoming fields incorrectly to Airtable fields. (I say sometimes bc I just discovered the issue and it doesn't always appear to happen based on fields coming in correctly)Sharing a screenshot where you can see we have a "Client status" field in Airtable but it's assigning the "Client notes" label to it instead of the appropriate one. This appears to be happening dynamically and I'm curious if anyone knows how to improve this WITHOUT changing the Airtable field name (which would cause me to have to change it in several places). I've tried updating the Google Sheets label to something like Notes or changing the Client Status to just Status but it still confuses the two. Thanks in advance!

Hi everyone;I want to change a single select field when I change a single select field from another table. I tried to do it through automations but I keep having input mistakes. I will share some screenshots so you can help meWhen the status from Table A is 'technical interview'Change status from Table B to 'technical interview'And this is the mistake   

Hello!I'm not sure how to approach this issue, as I'm fairly new to scripting. I am creating a script to copy a cell value from the last filled cell in a column to a cell in a new column if the value in the first column is blank. The use case here is to associate subtasks with a main task. To note - this is based on external tasks requests, and I do not have the option to reformat the way that the requests come in. Here's an example of what I mean: Current Setup: Task NumberTask NameSubtask Name12345My Task 

I'm trying to create a script automation that will write update call log data from a phone number pool to airtable. Here is my code so far. The problem that I'm having is that the script within the automation section doesn't support my envo. const Twilio = envo('twilio');const Airtable = envo('airtable');const accountSid = 'TWILIO_ACCOUNT_SID';const authToken = 'TWILIO_AUTH_TOKEN';const twilioClient = Twilio(accountSid, authToken);const apiKey = 'AIRTABLE_API_KEY';const baseId = 'AIRTABLE_BASE_ID';const tableName = 'AIRTABLE_TABLE_NAME';const airtableBase = new Airtable({ apiKey }).base(baseId);const phoneNumbers = [FriendlyNameExample'];phoneNumbers.forEach((phoneNumber) => {twilioClient.calls.list({ from: phoneNumber }, (err, calls) => {if (err) {console.error(`Error retrieving call logs for ${phoneNumber}:`, err);} else {console.log(`Retrieved ${calls.length

Hi, One of my special views is a report to my client. Usually I “print” this by saving the PDF and the emailing that PDF to my client Is there a way to automate this in Airtable? Thanks Hazel

When record text field is not empty, find records with similar text fields and link records? Is this possible? The similarity could be a partial match.

Does Airtable have a way to create several new records based on the number of entries in a field? For instance: We have a request table that people can fill out a form to request being added to articles. They can request being added to multiple articles via a link to our overall articles list. These requests go into a request log, and then go to an updates log that tracks the changes to each article. The request log has an automation that creates new update records when the request is approved - but I can't seem to figure out how to have it create multiple update records if multiple articles are selected on the form. Right now, it's only creating the first update record from the request. 

Hey hey, I have got the following issue. My Airtable links to other apps like Documint, Make.com, NoLoCo etc.Documint for example will use the fields in a table to create a document.However in some cases, when I want to extract the data from the primary field (which is single line text and e.g. "Asset #1") it will not give "Asset #1" as a result but the record ID, e.g. "recnciFjzmZeLA4DY". What do I need to change? I have the same issues when Make.com extracts the data. Best regards,jan 

Hey everyone. I have an automation setup where it emails me anytime a record has been edited or updated within a base of mine. This is great, but I don't know which record or field has been updated so it's hard to figure that part out without created a seperate automation for each field and each record. Any suggestions how the email notification I get sent would alos include which record and which fields were changed that triggered the notification?  

Hi,In our base we have multiple Proposals in one table against each linked Sales Opportunity in another table. One Proposal will be the Primary Proposal and any others will be Secondary. This is done by selecting Primary or Secondary as a single select.If a Secondary Proposal is changed to Primary, I'd like any other Proposals linked to this Opportunity to automatically be changed to Secondary, to avoid there being multiple Primaries.Is there a way to automate this?Many thanks

Hello! In my zap, one of the steps is to find a record in Airtable, based on multi-condition search formula.  The problem is, that recently, despite testing okay in the zapier editor, the data out of this step is unexpected (one long string, no individual values).   I'd previously had a column with linked records in my table, and thought that was causing the weird output, but after deleting it, the issue remains. Also, the _zap_search_was_found_status: is true, which means my zap continues to run with empty values &#128542

Hi everyone,The context is as follows:We give trainings (among others) to many people. I would like to know who attended which trainings, get feedback on participation, etc....Each training is managed independently by a different team, with different constraints.What I have set up :I created a "CONTACT" database with all contacts in a shared table "PEOPLE ".Each project has its own database "PROJECT1", "PROJECT2", etc... I connected the shared table "PEOPLE" in each project database, to retrieve the data of the persons (email, tel). This table is read-only in this database. I add data for each person: "grades obtained, participation, etc...). For now, at the end of the project, I copy the important data of the project (grades, certificates) in the main table "PEOPLE".But obviously this is not ideal.My needIs there a simple way to automatically retrieve some

Hello there. I've hit a brick wall with an automation I'm trying to build. I was hoping to use an interface button to identify all records in a table with an unchecked box within a particular field and then check all of those boxes. I have created an automation where the trigger will be the button, and have then added the "Find Records" action where the condition is all records with an unchecked box. That part runs fine in testing. It all falls apart when I try to update records using the list of Airtable record IDs generated by the previous step and then ask the automation to check the relevant field box of all matching records. Can anyone assist please? 

Hi everyone,I'm currently working on designing a maintenance form for my clients.The maintenance form looks something like this, very simple.But how can I automatically populate the values of other fields after selecting a value in a particular field?For example, if I choose "Assignee A" from the Assignee field can I automatically fill in the Facility and Equipment Type that are assigned to Assignee A? In concept, I will create a table that associates an Assignee with the Facilities and Equipment Types they are responsible for. The person filling out the maintenance form will only need to select the Assignee, and the system will automatically populate the other information.Thank you for your kindly supports!

I used zapier to automatically fill multiselect column. but unlike as I expected, result of zapier goes into one block. not seperated. I think this was caused by double quotes issue, but i don't know how to solve this.I want to make result as second or third rows. however result comes like first row.

Hey All,Not sure if this is a bug or if I'm having a ridiculous amount of trouble. To replicate the same problem I'm having, I'm creating an automation in which I would like to make it so when a record is created in the Test Base table, it automatically ports that name over to the Students' Test Names table. As you'll see, Airtable says the automation ran, but it only pulls in the new REC ID of the record that's been created and not the Student's Name, despite the fact that I think I mapped both, and the "result" shows that it has added the associated student's name, as well as the REC ID. Any thoughts? Thanks.    

Hey there, I'm working on an automation to create a record and one of the fields I'm using for this automation is a long text field. In the Data tab, I've enabled this field to have rich text formatting, which works great in the Data tab! However, in the Automation tab, I'm trying to copy and paste from another Airtable base (I've also tried a Google Doc) that has line breaks and bullet formatting. When pasted into the automation, it strips all of the formatting. Is there any way to avoid having to manually re-create the line breaks? I've attempted to follow this documentation: https://support.airtable.com/docs/using-markdown-in-airtable And reviewed this one: https://support.airtable.com/docs/formatting-rich-text-in

I have an email automation running every day at a specific time.Is it possible with airtable to match the time the email is send to different timezones?Eg. the same e-mail is send at 2pm CET and 2pm ACT, etc Thanks  

My team has created an Airtable base that can keep track of everyone participating in our diversity program, and we’ve set it up to allow people to update their participation records using forms as they attend trainings for credit. Is there a way to let people update their attendance records using forms that doesn’t eliminate the previous record of what they had already attended?For example: John Doe has a record in the “participant progress” table. When he completes “Training 1”, he submits a form and Training 1 appears on his record. But the next time he attends something (e.g. “Training 2”) and submits the form, how can we have it ADD Training 2 alongside Training 1 instead of overwriting it?

Is it possible to select or send random numbers of images from clouds like google drive or even from PC folders? 

Hi,Is it possible to trigger and automation task if sum of one column for a group reaches some amount.For example I have columns grouped based on the a parameter, let's say group1 and group2.Then I have another column stake and I want to trigger a task if sum of a group exceeds the sum of stake column by some number Thanks

Hi Y'all!First post. real problem. Have been trying for 2 days(script below text)I have a workplace problem that i am determined to solve using Airtable.In table: Product data i have 1500+ product records with a primary barcode field called 'BRCDP'In table: Scanlist i created there's a field called 'BRCDA' also a primary barcode field. I needed a script that is be able to compare a dataset an match the records primary field, if a new records added to table: Scanlist matches a existing barcode in table: Product data, this new record should be automatically be added to the designated linked record field.  It keeps crashing. Does anyone have a simply script for this?const productDataTable = base.getTable('Product data'); const scanListTable = base.getTable('Scanlist'); async function linkRecords() { const queryResult = await scanListTable.selectRecordsAsync({ maxRecords: 1 }); const scanRecord

Hi, I would like to add +1 to a #Number column to a dedicated Name line in one table as soon as a record is created in another table including the same name. Is it possible?Thank you very much 🙏Example:Table/tab 1Name.      Surname NumberYohan       Lafon.      5Table/tab 2Name   SurnameYohan   Lafon   When a new record is created in table/tab 2 including this exact Name + Surname, it adds +1 (therefore it gets to 6) in Table/tab 1.Do you know how to do it?

Hi,I have an automation that triggers every day at a specific time.I want to end the automation after a number of days.How can I do that?Thanks,Jacqueline  

Hi community, I have a question related to the taggin proces. I recently uploaded a lot of data in Airtable and I have defined tags. Now I want to create an automation (with script probably) which is able to search in the description and compare with the predifined tags. If there is a match I want that tag to appear in the column "tags".I saw a discussion which somehow was related but not spcifically with matching the description and predefined tags. Is somebody able to help me? I am not a technical spcialist so hopefully it is not too difficult...Thanks!