Automations

For work I would have to automate our airtable, we use it to log projects and each project has a different supervisor. Now i would have to automate the system to send automatic emails whenever something changes in the “row” of that specific supervisor. I tried this via the conditions trigger with: WHEN supervisor is X OR … basically every “column” So that when something is updated for their project that specific person gets an email. However, this does not seem to work? As it only gives an update when only 1 field changes and not when for example 3 fields get updated accross multiple projects or even just 1? How can I fix this? I am looking forward to a response! Thank you :slightly_smiling_face:

I have just discovered that the automation for when “record enters a view” will only trigger the first time that it enters into that particular view, for both AT’s new automations and Zapier. Bit of a nightmare tbh! Is this the same for the automation triggered when a “field matches a condition.” My particular use case is for example using the kanban to monitor a workflow whereby a card may need to re-enter into a particular single select status (eg. imagine there was a status of ‘pending’ and I wanted to the re-trigger an automation to notify the right individuals each time it entered that status via slack) I cannot even find a workaround using the automation for “any field updates” and a last modified field. Thanks

I’m looking to import and categorize my amazon purchases. I have all of my purchases in a spreadsheet that I downloaded from Amazon (after I requested it). It lists each item by ASIN (a unique ID# for each product) but it does not include the category (e.g., Home and Kitchen, vs. Baby vs. Food, etc). I can search by ASIN on a third party website (https://amazon-asin.com/) and it will give me the category. Does anyone know how to write a script that can go to a webpage and retrieve the category text? I’m not good with writing code so curious if this is possible. And if so, can someone assist me or point me in the right direction? Thanks so much

Hello everyone, It may sounds stupid but I have an issue to sync cancelled events (Calendly) to my Tickets Table (Airtable) via Zapier. Basically, when someone cancels their attendance on Calendly, I don’t know how to change their status from ‘Booked’ to ‘Cancelled’ on Airtable via Zapier. I am using Calendly for my ticketing/attendance management. I have different kinds of recurring events, with different times/dates, with different users booking/cancelling their ticket. On Airtable my ticket table has a single select column called ‘Status’ so I would know when someone has booked or cancelled their attendance. The problem is I don’t know how to make Zapier updates the status column automatically from Calendly when it’s a cancellation (I know how to create a record when someone books though).

Hello, i have this error message, when my automations try to create google calendar meeting from record. Cell has “date” value All test pass. The only way to sync is duplicate existing record… and it’s working.

at first this did not happen, until one month of use. suddenly it happened, not all of the recorded data from Gform entered the airtable, after I matched it was really lacking, 36 data should only enter 21, and when I repeat I delete and fill in Gform again, there should be 36 recorded data entered, but on the airtable only goes in 21, sometimes 30, 29, 34

Please add a “Wait” option to the list of available Actions, where a user can require a certain amount of time to pass (in minutes, hours, days or weeks) before an Action can run.

I have set up a simple automation to create an event from a date and time field. These are PDT and my GCal is set to Los Angeles time zone. However, the event that gets created is one hour behind the start and end time listed in Airtable: 1st event should start at 9:30 am on 11/13 2nd event should start at 21:30 (9:30 pm) on 11/13 Here is what arrives: Off by one hour!

I have an automation that’s being ‘stuck’ in a vicious circle: I can’t press the ‘Update’ button on the bottom (well…I can, but nothing happens) I can’t switch the automation off because it isn’t updated I can’t delete the automation because it isn’t switched off In the meantime the automation keeps generating error reports by email, which is annoying my boss ;-). Can somebody shine a light on this? :slightly_smiling_face:

I have been using dashdash and airtable for quite sometime now. All of a sudden , I started getting errors today. The message is AUTHENTICATION REQUIRED. In some other applications I got an error message RATE_LIMIT_ REACHED ( Rate limit exceeded) Please try again. There is no change in anything as such. I changed the API key and tried . But the same results. Can someone please help ? Hari

I can’t create a google calendar event base in the row selected timestamp, i have the google calendar account connected, but in the automation i insert the date base on my record date field and generates an error in the run test. it’s posible to crate a google calendar event base on my records date field?.

Yesterday I made a form in Jotform that fill 3 tables in my Airtable database. It creates 3 new rows (one row for each table). That works fine, but there are no links to the different tables. How can I link automatically link the last record from table A (table 1) to the last record from table B (table 2)?

what value can i put to update a check field type? when some conditions are met I want to mark my field type check. if i put value “check” i get an error.

I have created an automation that is triggered when a condition is met, an email is sent. When I test it, it says “successful”. However, when I fill out the form with a condition, the trigger doesn’t work. This works for my other automation. Any ideas I am doing incorrectly?

Hello, i’m the owner user and my collaborators connected their google account, but I can’t select their accounts to connect to an automation. how can I do it? Is it necessary for them to give me their username and password for their google accounts in order to connect them?

I need to copy a record from one table to another table (or from one base to another base). The records I need to copy are the ones I label as “Expired”. The act of copying them will be done manually, that’s not an issue. What I am looking for is how to preserve the date in the Create Date field when copying the record. Right now copying the record would trigger the Create Date field to be updated with a new date (=now date). What I want is the new copied record to cary over the original create date. One solution I came with is to: In Table 1 (the record has Create Date field with the date) In Table 1 add another field called “Original Date” Set up Automation in AirTable or Integromat. It would trigger when this “Original Date” date field is empty. When copying the record into Table 2, this Original Date will be carried over (although the Create Date will have a new date =now date). I haven’t tested Airtable Automations if it will work but I assume it should (another option is to

Is there an automated way to send a list of records from a view each day? (The view is filtered by date to show records on or before today’s date.)

I’ve set up a simple automation to copy data into a field when a record is updated. This works fine if you are just changing a single record but sometimes we do bulk updates (cut and past multiple records) in that table and the automation only seems to fire for the first 1 or 2 records. Is there a delay or lag in terms automations firing, so is there a better way to handle this?

I have an automation run when a field is updated on a record. The field type is linked records. The automation runs a script that sorts the linked records based on the fields in the linked record (status and date). Sometimes after the automation runs, what is displayed when you expand the field or open the record to check the field to see if the sort worked, will not display correctly. When I refresh the page and look at the field again on the record it will be in the correct order. It seems to not display correctly until you refresh the page. I think the problem comes in when you make multiple updates dragging multiple linked records around in the field causing it to trigger multiple times. Is there a way for the update trigger to not go until you close out the record? There seems to be a display bug due when you update a field while an automation triggered by a field update is running. What is actually stored in the field is correct, but it will not display correctly until you refres

Hello Community, I want to create multiple records automaticly. The number of records should depend on a specific entry in a table. Is this possible? Thank you very much!

Hello, I couldn’t enable an automation. I don’t know what is missing from my configuration. Any suggestion is appreciated.

Hi All! Newbie to the Community, but not to Airtable. I have a Table, Table 1, where info is populated by form submission from everyone in my office who completes a task. I am trying to feed a subset of that information into Table 2. (Let’s assume for some reason that creating a new View of Table 1 won’t meet my needs.) My Trigger tests perfectly: But my automation Action keeps failing. This is a simple pull - a number is entered into a form that populates a record. I want it to pull the record identifier (which is, in both tables, a number entry Primary Field) over from Table 1 to Table 2. I cannot fathom what would be going wrong here!

I can’t update the collaborators field when creating a new record, I want to add collaborators by default. how can i do that?

hello, it is possible to group collaborators into a team and add the team in a record instead of adding them one by one?

Hi, I would like to update a record in airtable, The record is a PDF file I created in my Google drive and now I want it to be a record in airtable. I don’t know how to fill these fields: File URL Can you please help and send example what to fill in?