Skip to main content

Automations

Ask your questions about Airtable Automations here.

  • 5,192 Topics
  • 16,179 Replies
5192 Topics
D
Duck-LorangeNew Participant
asked in Automations
Setting up Multiple Select Automation

I could use some help correctly setting up a multiple select field that monitors changes in other fields. For context, this'll be setup for internal use mostly for billing purposes. Once the tagged change(s) in the multiple select field have been resolved, they'll be manually cleared. Scenario: I have a multiple select field called Changelog that monitors changes in other fields in the same table- Contribution Status, Contribution Amount, and Current Donation. Any change in a record associated in a specified group should have their respected outputs reflected in the Changelog field. Issue: I want the Changelog field to populate any and all changes. Sometimes the output looks accurate, other times it does not. In the example screenshots, I changed a record's Contribution Status which resulted in changes to both the Contribution Status and Contribution Amount- correctly reflected in the changelog. However, when making this change, it affects the other records in the group,

184
D
F
Francoloco23Known Participant
posted in Automations
How to find an Order ID autonumber field into another table

Good day team,I currently have a table wherein we have an auto number field as well as an attachment field or excel sheet with our clients personal data. Then the data on the excel template will then be manually transferred to another table. Is there a way or an automation that could also captured the correct auto number field and be seen as well on the other table based on the subjects in the file? For Example:Subject 1 - 1234Subject 2 - 1234Subject 3 - 1235 Thanks

75
TheTimeSavingCo
D
Devon_GodfreyInspiring
asked in Automations
Create Comment Via Script

I'm going based on this: https://airtable.com/developers/web/api/create-commentThe authorization is fine, but for some reason within scripting it keeps giving the error that the body isn't parsable. My script is as follows:    //Variables let inputConfig = input.config(); let recordID = inputConfig.recordID; let commentContent = "Hello World"; let url = 'https://api.airtable.com/v0/appksePpf16d6MPdp/tbl4ZEftsWgo84Ldu/' + recordID + '/comments'; console.log(commentContent); //Create the Comment let response = await fetch(url, { method: 'POST', headers: { 'Authorization': 'Bearer [private]', 'Content-Type': 'application/json', }, body: { //For some reason, it's not accepting this body 'text': commentContent } }); console.log(await response.text()); //console.log(await response.json());   I've gotten it to work with this exact same data in Spectator, so I'm really puzzled as to why this doesn't work. 

792
D
D
Don_TranNew Participant
posted in Automations
I just used up 17,000 of the monthly 30,000 automation limit. What do I do?

Many departments in my workplace heavily rely on automations. Towards the end of month, we sometimes reach a limit of around 30,000 and it's a hassle linking records manually.Earlier I just changed a filter and triggered 17,000 automation runs before I could disable the bad automation, which sends emails when a record is created in a synced view.... It's only the beginning of the month. I'm stressing out. I had optimized and sacrificed many automations; I undid all that work in an instant.What should I do to prevent automations from entirely stopping in two weeks?

101
kuovonne
R
robsimasNew Participant
asked in Automations
email notifications and google docs

I have a simple automation set up to send an email when a record is updated. The email includes a link to a Google doc for that particular record. The automation works most of the time, but I've run into situations where the URL for the Google Doc in Airtable gets modified when it comes through in email. For some reason, the underscores in the link get removed. See arrows in attached screenshot. The top URL is the correct one in Airtable, the bottom URL is what comes through in the email. I have other records in Airtable that also have underscores in the google doc URL and those comes through fine. It just seems to be random docs that this is happening with.Any ideas how to fix? 

32
R
O
Oscar_RamiroNew Participant
posted in Automations
Date Time not correct when integrate with make

I am working with make + airtable but when i try to write the date + time in my airtable with the data from make the date applies correctly but not the hour. It always insert 00:00 time. What is wrong here? thanks in advance. 

66
O
E
erangggKnown Participant
posted in Automations
can I change grid direction to right to left?

Hi,I add a grid in my email automation.when I insert the grid I want the grid to be Right to left.right now its left to right like here:is it possible to make it Right to left so the supplier will be on the right side?Thanks. 

783
E
J
j_c_pascasioNew Participant
posted in Automations
Actionable button in share view

hello - i created a button field that triggers an email via sendgrid integration. while this functionality is possible as a creator/internal user, it is not possible (i.e., button not clickable) when a shared view is generated and viewed as a non-internal user. is there a way to allow non-internal users who view the shared view to click the button to generate the email?

164
kuovonne
V
vince_forte25New Participant
posted in Automations
Getting Error - "Invalid item in array cell: foreign record is invalid: foreignTableId is incorrect"

I have three tables - deals, project, and a join table that connects deals and project. The deals table is connected to the project table through a linked field, creating a 1:1 relationship. I am trying to link the join table to the project table based on the linked field in the deals table. I am using the Airtable ID for the linked record from the deals table and inputting it into the "link to project" field in the join table, but I am encountering an error."Error: Field "fldxxxxxxxxx" cannot accept the provided value: invalid item in array cell: foreign record is invalid: foreignTableId is incorrect."I'm getting the correct id for projectID field as I've double checked but still it is not getting linked to the "Link to projects" field. Please do let me know if more detail is required or if anyone has any solution to this?

132
kuovonne
I
InfoWranglerInspiring
asked in Automations
Solved! Editable shared view workaround

Hi folks. I’m trying to create a way to allow a member of our team to edit a shared view, and I’ve reached a snag. Here’s what I’ve done so far: Created a synced table in a new database using the data from the shared view Added 3 new columns in the new table for adding information to individual records Created an automation in the new table that makes a new row in a google sheet every time a particular column meets a condition All that works. And here’s where I’m snagged: Creating an automation in the original database that updates the changed record whenever a new row is added to the google sheet - BUT: When I use the Record ID from the new synced table, it doesn’t match the Record ID of the original table, so I get a “record doesn’t exist” error When I use one of the other field values from the new google sheet row to identify the record, I get an “Received invalid inputs” error. SO - how do I get the original base to recognize the equivalent record in the synced base? What’s t

1415
P
Y
ydocNew Participant
posted in Automations
email notifications and calendar time zones.

I have an automation that emails a list of people every time a record is created and within that email is a formula field that concatenates a date with several other fields but the problem is in all the emails the date and time is always 7 hours ahead. How do I make it so it sends only in pacific standard time? 

41
TheTimeSavingCo
A
aziz0731mNew Participant
posted in Automations
Multiple action in one automation

I have created automation when the condition matches  and assigned to person "A" then it should email person "A"In the same automation, I would like to add another condition whereas if assigned person is "B" then it should email person "B" only. How can I add multiple action in one automation whereas based on each action the email goes to a different person.  Please see attached screenshot.  

654
TheTimeSavingCo
Y
ydocNew Participant
posted in Automations
I am trying to run an email automation but get this error: Cannot email non-collaborators on the cur

I am currently on the team free trial plan do I need the business plan to email non-collabaorators? I am trying to email every person I have on a table with the same email is there a way to bypass this through other services?

146
kuovonne
U
UnderPressureNew Participant
posted in Automations
Automation issue

Hello, We have a problem with our automation (see attached). Our client works with her clients with points. We already have an automation that is working > when an entry is updated in table X, create a new enter in table Y.Now, we'd like to automatically, when an entry is updated in table X (points available), that is automatically updated in table Y (for the corresponding line). We tried to change ID, fields, everything and we always have the same error. If someone can help !Thanks 🙂

165
Pascal_Gallais-
M
medfuturexaiKnown Participant
asked in Automations
How to add New options to Multiple Select option

Hello,I have three columns with multiple select options: Lecture (Mandatory), Lecture (Required), and Lecture (Optional). I want to automate the process so that if I add a new value to Lecture (Mandatory), it automatically gets added to the other two columns.For example, if "English Lecture" is added manually to Lecture (Mandatory), then "English Lecture" should also be added to the multiple select options of Lecture (Required) and Lecture (Optional). How can i do that using automation I have make some small automation but it is not workingSet the Trigger:Choose the trigger "When record matches conditions."Set the condition to monitor the "Lecture (Mandatory)" field for updates.       let table = base.getTable("Your Table Name"); let recordId = input.config().recordId; // Fetch the record that triggered the automation let record = await table.selectRecordAsync(recordId); // Retrieve the values from the multiple select fields let certificat

165
Sistema_Aotearo
P
PCSNew Participant
posted in Automations
Batch/Group Attendance

Hi! I am trying to create an attendance form that is able to create multiple records from a single form submission. What will be most convenient for our users will be a batch attendance as they login and log out at the same time.Im currently attempting this by using fillout forms. Im willing to try any options to achieve this result.Image 1:  Rows 1 to 5 is the output that i want. Row 6 is what i get.Image 2: What my form has to look like Appreciate all the help I can get! 

71
Sistema_Aotearo
E
E_HermanNew Participant
posted in Automations
List of records that looked up a particular record

Table A (Names) has a lookup field in Table B (Clubs).  I would like a field in Table B that lists all records from Table A that  looked up that particular record (club) in Table B.   In other words, I would like a field in Table B that shows all the names for a particular club.  How do I do this?

21
kuovonne
C
cgreavesInspiring
asked in Automations
Make a report to guide manual changes to seperate database.

My team has several hundred user profiles with personal information stored in a database with no API. We keep the personal info there, but we have an SFTP to upload CSVs for information regarding statuses and due dates on various per-profile tasks. Those CSVs land in Airtable, where I'm working to create interfaces that are a lot more user friendly than the database. The really unfortunate thing is, I need a way to track any status or date changes we make in Airtable in order for teammates to manually update that data in the database. At any one time, there will be three "truths": what the old upload previously said, what the teammate has changed it to, and what the new upload says. (I should note, the new upload will probably overwrite the old upload? I'm not sure, I haven't set it up yet as I'm designing the base with fake data.)I can't wrap my head around the best way to do this. I could:1. Have user status/date changes change the last uploaded data, but then compare to the new

60
C
O
oh78_2New Participant
asked in Automations
Automation for updated record via Mini Extensions

Hello,I am trying to set up an automation that sends an email when a record is updated, but only if it is updated via our Mini Extensions add on.We ask people to submit via an Airtable form with information that is TBC, and when the record is created, we can ask people to update anything via Mini Extensions so that they don't have to log in or have an Airtable account.It would be great to know when someone has updated the record through the Mini Extensions form, as currently I can only set up an automation when a record is changed at all - this would be inappropriate as we are updating the records ourselves all the time.The condition options in automations for 'send an email > when a record is updated > if conditions are met' do not have the condition I am hoping for; any advice appreciated.Cheers

72
O
n8atkinson
n8atkinsonParticipating Frequently
asked in Automations
Multiple Airtable Attachment Uploads

Hello. I am trying to send Gmail attachments I receive automatically to an attachments column in Airtable. I finally realized that Airtable wants the URL in array form, which I can do. However, I have not figured out how to use the array functions toArray, map, or add to append the files instead of overwriting and keeping the last one. I have searched and read numerous posts in both the Make and Airtable communities. This is my most recent attempt at make.com.My ultimate goal is to allow students to email their attachments and have them appear in the portal I built with Softr.I feel like I am so close. Thank you.

30714
CKARC
R
reem_dreamNew Participant
posted in Automations
Update Completed Date Field When Status is Done

Hi! I have a task table with a Status field and a Completed Date field. I'm trying to create an automation to update the Completed Date field when the Status changes to Done. Wondering if there is a way to add the date that the status was changed to Done in the Completed Date field. For instance, if I change the status to Done today, the date in the Completed Date field should be timestamped with today's date 5/24/23. I added screenshots of my automation flow ... as you'll see I am not sure what to use in the update fields configuration page. I read somewhere that I can use Today () but that doesn't seem right in the automation. What should I do here, and is it even possible? Thanks! 

614
M
F
FredsackNew Participant
posted in Automations
Automations and Linked Rrecords

Hey there,I have a linked records field with 4 lookup fields that look up content from another table. I created an automation to automatically put in the Teacher tame into the linked field so that it finds the matching record and populates the fields. I then get the error: Field "Teacher" cannot accept the provided value: Cannot modify a computed field. I'm not modifying the teacher field through the automation but a field called PARTNERS Lookup, which in turn should automatically populate the "Teacher" field (and a few others). I'm not sure why this isn't working. Any help would be appreciated!     

85
TheTimeSavingCo
E
erangggKnown Participant
posted in Automations
How can I create this?

Hi,I have a table of assets, faults, professionals and suppliers. Every time a fault is over, an email is sent to the customer (automation of email sending). Each property can have several malfunctions, each malfunction can have several professionals who handled the malfunction and several suppliers through whom we bought products to handle the malfunction. In the table of professionals there is the private bank account of each professional and the same also in the table of suppliers. Is there a way that if the fault is over and 2 professionals have repaired it and we have bought materials to treat the fault from 2 suppliers, the customer will be sent an email in the following format: Hi (customer's name), please transfer payment for the fault's termination to (professional 1) to the following bank account details: Bank - xxxxx branch - xxxxx bank account number - xxxxxx In addition, please transfer payment for (professional 2) to the following bank account details: Bank - xxxxx branch

168
E
L
luizapcamposNew Participant
asked in Automations
Connecting Automations to a Base for Run History

Hi everyone! I'm working on a project to track and monitor my Airtable automations. I want to create a base that will automatically populate with all my existing automations and update every time an automation runs. This way, I can easily view the run history of all my automations in one place, without having to check each one individually. Is it possible to connect automations to a base and track their run count automatically? I've reviewed the documentation but couldn't find a solution. Any ideas or suggestions would be greatly appreciated! Thanks in advance!

553
Sachin_191
C
chrisnhampNew Participant
posted in Automations
Automation trigger for matching records between two tables

I have a base with a record for each computer (about 4,000 total) that I am responsible for managing in my large corporation, and each record has fields about the computer including its Serial Number and Hostname, among others.I am provided with a semi-regular report in the form of a CSV from the company that lists every computer that has checked in with their security monitoring program which is required to be installed every computer. The CSV has more than 30,000 records. I want to ensure the computers I am responsible for are compliant and checking in, so I import the CSV into Airtable and then search for my computers by SN and Hostname. I use an automation to search for each computer in the CSV and update a field in each computer record to indicate if a match is found or not.In my current setup, the trigger for the automation is a single-select field on each computer record. When that field is set to "search for matches", the automation runs, and each computer's record is updated t

367
Sachin_191

Badge winners

Show all badges
Terms & Conditions