Automations

Can someone PLEASE help me figure out why this automation isn’t happening? I’m about ready to stop using Airtable and switch platforms if I can’t. I keep trying to update so the Trigger is that whenever something appears in the table and the Action is just for associated info to update. The Trigger is always testing fine and works. The second I put in that I want a record to be updated EVERY TIME IT SAYS THE FIELD IS BLANK WHEN IT ISN’T. I put in the correct Table, I have the record attached: those both seem to be fine. I put in the field name, which in my case is “Class Listed” and it has a multiple select attached. Each time I add it and run the test with the added information it says it failed. I do the same thing with “Create New Record” and it seems to work. What am I doing wrong? PLEASE? I’ve tried contacting Customer Service and literally nobody has gotten back to me and a week and it’s affecting the business this is for.

Hi! I’ve been loosing my mind over the past days trying to find a way to either solve this automation or find an alternative even if it requires a manual check. However it got to the point where I am willing to pay for much needed dedicated help. Here’s the situation: Scenario I have 2 Bases. The first one is a very simple setup on a free plan where collaborators drop basic input: Airtable - Registro de Producciones (that’s it, nothing fancy here). The second base is on a different workspace on a Pro account. I’m using the Sync feature to pull the data onto this Base. Goal Part 1 Create a new linked record when the field of either “Videographer”, “Photographer”, “Producer” or “Videographer 2” i

Hello all! I’ve set up automation to act as a support desk. I’ve got a form on our firm’s internal square space site, from there it feeds into Zapier which automatically pushes into airtable to create a record. Square Space Form > Zapier (8 automations) > Air Table Base (1 Automation per base) Based of the question subject the question gets directed through zapier and into airtable. Currently using the automation “When a record is created”. Which then sends off an email to the user who submitted the form request. After running tests, I’m receiving 8 emails, from all 8 automations in each base. Any idea why this is happening?

Hello, I have a google sheet that takes pricing information for different products and lets sellers know where they can get the best price for their inventory. I have the google sheet working, via a couple dropdown menu and a query based on the results. I wanted to layer a UI on top of the google sheets and I’m having trouble finding an app that’ll allow me to read and write responses instantly from google sheets to the UI (airtable, glide, etc.) Does anyone have any suggestions on how to go about this. From what I can tell there’s no way to instantly read/write data back and forth from google sheets.

I’m trying to us the example script, and keep getting: airtable recordid should be a string, not undefined I am using the script as is, except I changed the table name on line 2. I followed instructions on how to configure input variables using the left panel. I added recordID field to my table, using the recordID function in formula field. When that didn’t work, I changed to a short text field, preserving the generated record ID values, but I still got this error. I’m out of ideas. Can someone help? “TypeError: Invalid arguments passed to recordQueryResult.getRecord(recordId): • recordId should be a string, not undefined” TIA, Sharon

I have multiple automations set up for email notifications to different parties when a record enters a view. the automations are set up correctly and run as they are supposed to when the record is initially entered. Then 3 days ago, May 1st - the automation triggered and an email was sent out for ALL the records in that view even though they were old records. Then it happened again on the 2nd and the 3rd. Then today, a different automation triggered and sent out 150 emails for old records. I really need assistance to figure out why this is happening so I can fix it. Please help!!

Hello, is there a way to change the creation date / time of a field? Automations will only render grids with fields sorted by creation date. This makes reports unreadable, and automations as weekly digests useless…

Hi all I have a table containing 10 ‘taster’ registers (URL links) - one for each week of the term. I’m trying to make the correct week’s URL copy into the ‘taster register’ field, depending on which week we’re in. I have two separate formula fields - one called ‘day of the week’ (Monday = 1, Tuesday = 2, etc), and a second called ‘current week’. To update week 2’s register, for example, the automation is dependent on two criteria - that the day of the week = 7 (Sunday), and that the current week = 1. This way, at the end of week one, the week two register links will automically copy into the ‘taster register’ field. It might make more sense to look at the base itself - its quite tricky describing it here. Basically, it isn’t working. But, if I manually change the the formula to match the conditions, it does trigger on all the records. What am I missing? Has anyone experienced something similar? Here’s a link to a redacted version:

Hey all, So I had my rep create a triggered/automated email based on date passing and it was working fine, except I needed to add some other triggers. I somehow broke the previous cool hyperlink with the text: ** Hey Team, The video 2021-05-03T13:00:00.000Zfor Film and Visual Effects needs to be retrieved.Click here to access the record** I fixed the weird time thing(used a different field, no fancy formula) but broke the hyperlink Hey Team, The Archology-2021-01-12video for Datasmith needs to be retrieved. https://airtable.com/tblxvulRRANNvpsaC/receRXgVuBqS0FRy9

Hello! Had a bit of a puzzling issue today. We currently use Airtable to make a list of 3D styles that need to be worked on in our company for clients. Our clients receive an automated email when the status changes to “ready to be reviewed” or “questions for this style”. Today I received an email from airtable automations that I had +1400 failed email automations and we’ve also been receiving emails from our clients that they gotten upwards of 200 emails about their styles that are no longer relevant. It seems that anyone who got the emails got notifications about all the tasks they’ve ever requested us to work on. Before this happened I had merged a .csv import with my current data in the table (all tasks gets entered with an empty status), when I do this is also change the email field to a ‘look up’ so we can associate emails to the proper client based off a linked clients tab, then change it back to an email field so it works with the automation. All tasks i’

Hi, I’ve been using Airtable to manage and automate registrations for events. I set automation to confirm the registration. The trigger was a “When a record is created”, i.e. when someone completed the registration form. After the event, I did not switch the automation off, and I inserted a new column into the same sheet to indicate who participated in the event (checkbox). Problem: Registered people who could not participate at the event complained about receiving my automated message confirming his/her registration after the event a second time. Previously, I assumed a record was when someone completed my form. Please help me to understand what happened. If the inserted new column was a new record/trigger, why only just a part of registered people received the automated? With thanks

I have two bases that use automations. In both cases I have problems with the automations triggering. In the first case the automation triggers for some things but not others. I believe that there may be a cascading automations problem in the first case, but I don’t know how to space things out enough to get all the automations to work correctly. In the case of the other problem automation it just never triggers, and it may be suffering from a semantics argument. The records are created by an outside automation (the record is being copied over from another base) but I’m only watching the relevant field for updates. I view that as an updated record because the record has to be created first, then that information is copied over, but is it still considered a created record and I need a separate automation for updated records? Thanks for the help!

my use case is very simple I want to invoke a REST API on every trigger of Record Created and Updated .(Whenever new record is added in Sheet or existing record is updated ) I should be able to read all the column data of a created / updated row and pass it to my API payload as a POST request Thanks

I have created 2 google worksheet automations. They test well and were working successfully. They have just stopped working but still test OK. I am on the free Plan. Can anyone help me?

I have an airtable table that I have automated into a Google sheets sheet, and then have that google sheets sheet copying info to another google sheet using the =Sheetname!cell number formula, but nothing appears when I have the airtable automated data in there, only when I type it manually into the google sheet. How can I fix this? is the data formatted differently when it comes from Airtable, or does the google sheet not recognize it is there or something in order to add it to the second sheet?

Here is my basic situation: I use airtable to manage events - each record has a specific date and time associated I have a limited number of staff - each record can only be assigned to one staff member within a given time frame (staff are not able to overlap their events) Is it possible to create an automation that creates a calendar event when I reach 75% of my staffing capacity? From what I can tell, I can only create an automation based on individual records. I am envisioning an automation along the lines of: “When number of unassigned staff at a given time falls below 10, create an event in GCal” Any other creative ways to approach this would be super helpful. Maybe there is an app that would be more appropriate. Thanks in advance!

I would like to build a pricing tool script that allows me to provide a few inputs, and then the script would calculate the price based on a series of calculations that run in the background. This is a for a trucking company whose job is to haul materials from the customer to a processing location. Each processing location charges a different rate to process the hauled materials. The pricing calculator needs to calculate the distance from the customer’s site to the processing location and the cost to process that material. [Project Table] input project address input material hauled input market location [Processing Table] list or processing locations containing address, materials accepted, processing rate, and market location I would like for this script to run a calculation for each record w/in a particular view of the Processing Table, and produce the lowest rate and associated Processing location that is driving that cost. The script wo

Hello, I’m not a developer, but I’m trying to work on an automation using scripts that will take the inputed “Current Monthly Image/File count” number and add it the “2021 Image count” total for every record in my table. Every month someone else inputs the number of images captured by a photographer in “Current Monthly Image/File count” and I want to add that number to the annual image count in the “2021 Image count” field. Thanks!

I have an automation based on a record entering a view. When I’m actively in the app, the record moves into the view and the automation is triggered. However, it seems if I’m away or off of my computer, the automation is not working. The view filter is based on a date/time calculation (record moves into the view when it’s within 10 minutes of the scheduled time). Any ideas? Should the automations be working automatically in the background or do I need to be logged in and using Airtable for them to trigger?

Hello, I created a field with a complex formula based on other field’s values. When this field is 0 (False) or 1 (True), I am showing them in a separate view via a filter on the view. When there is a new entry in the view based on this field being 1 (True), I am sending an action to Slack. Yet, sometimes when we see the notification on Slack, I check the view and there is no entry at all. We are suspecting that, when you paste a value to any field which is referenced inside the formulated, the formula gets updated for the slight of a second and then enters the view. Is there any thing I am missing here? A possible approach to fix this issue? Thanks.

Hey, People! I have two tables- Table 1 & Table 2 So I need the data from Table 2 to be automatically pulled into Table 1, once it has been marked verified. Will the IF function work here? or is there any other way? Please help.

Community experts, Sorry for the long title. I am very new to coding of any kind and without the community I would have never gotten this far. Basically, I have a synced table in my base and I have a automation script to link the records based on a field, “Part Number” in one table and “Part#” in the other. The trigger for the automation is “When a record enters a view”. I am linking the record in the synced table, Orders, to the Inventory table. I am able to make this happen with the following code. var mainTable = base.getTable("Inventory"); var mainView = mainTable.getView("Vendor Source Inventory"); var mainTableRecords = await mainView.selectRecordsAsync({fields: ["Part Number","Vendor_Source_Usage"]}); var lookUpTable = base.getTable("Orders"); var lookUpView = lookUpTable.getView("Completed Vendor Sourced Orders") var lookUpRangeRecords = await lookUpView.selectRecordsAsync({fields: ["Part#","Order Qty","Updated"]}); for(let record of mainTabl

I have table ‘Submissions’ that records each item submitted by users. Each entry has the Username of the user who submitted, and a Points value according to the Type of item submitted. I need to aggregate the Points for each user in a separate table. The other table is ‘User Points Table’ and so far I have had to establish the links to ‘Submissions’ manually. ‘User Points’ has one line for each Username and column for Submissions (linked to each entry for that Username in the Submissions table) and one for Score, which is a Rollup of the Points field from the Submissions table. What I need is for the User Points table Score to update automatically every time a new entry is added to the Submissions table. I would have thought this is possible but I ca

Looking to gather my monthly income(Sold inventory) and subtract it from all monthly expenses(utilities, property lease, office supplies, warehouse supplies, advertising, etc…) How can I create a formula or automation in order for this gross monthly income tab to work? Thanks

Hi All, I’m looking for a simple/elegant solution for a formula/script that will produce what I’m looking for. I have a text field (it will have a maximum of 9 ALPHA (uppercase only) characters in it. I’m looking for a solution that will perform the following functions. a. If a character is contiguous to itself if will count the total contiguous characters and place the number followed by the character. For example if the text field was PPPPP I would get a result of 5P. b. If a character has no contiguous matches then the result would just be the characters as shown. For example QRSTUV would give a result of QRSTUV. c. Combining these two rules together if we were to have RRQRRRQS the result would be 2RQ3RQS. I can easily find a solution if I wanted the result of an input sting of RRQRRRQS to be 5R2Q1S but the sequence has to remain as was originally shown as each value is assigned to a corresponding column (column 1 through 9 which is associated wi