Automations

For the following simple database example: Table called EMPLOYER with the following fields: EmployerName, Employees, Country. Table called EMPLOYEES with the following fields: EmployeeName, Employer, Country. Required AirTable automation: When EMPLOYEE/Country is Empty, copy the EMPLOYER/Country value to the Employees of each EMPLOYER. How would you setup the automation?

Hello! Apologies if this is a repeat question, but from my initial searches in the community threads I haven’t found a great answer as of yet… I have three near-identical automations that are meant to send an email through Gmail to contacts, and they all include a hyperlink to a pre-filled form that was created within Airtable. The difference between the three automations is the language used in the email itself, as they are sent to contacts that are either 1) currently in our database but need to update some of their information, 2) are currently in our database but need to update a lot of their information, or 3) are not currently in our database and would need to complete the pre-filled form from the beginning. I first created the automation for the third group, those contacts that we need brand new information from. I have since sent out the emails via this automation and it looks like 1000+ emails sent correctly, with the hyperlink pre-filled form being pulled in correctly, looki

Hello, i had comisioned some dude on Fiverr to make this script automation for Airtable but he is facing this error and is unable to resolve it, can somebody help out?

So I have 2 bases, let’s say A and B. Table 1 in Base A is synced to Base B. When 2 records with the same name lets say X are created in base A table 1, they enter a view on the synced table on B. When they enter this view an automation runs to create two new records in base B table 2 with the same name (dynamic field value). However when X and X are created in base A, I only want one new record to be created in base B’s table (when the name is exactly the same). What would be the easiest way to have the automation only create 1 new record named X? And it would be a bonus if I could have the new record in base b’s version field number to fill out as 2 when there are 2, 3 when there are 3 records with same name in base A and so on. Thanks!

I have two automated emails that are failing to run. When I test the automations, they work just fine on trigger and action, and the preview loads fine. But when they run, it comes up that the email has no “to” input. The input I’m using for the first automation is the outcome of a formula that finds an email. The other email is two email fields with a comma separating the emails. Help!!

When they say - Image 2022-09-20 at 6.36.31 am - 19th - what they reall mean is 20th lol… well that screwed up my whole follow up strategy lmfao - how do I tell AirTable that all dates are MY dates - Brisbane time! Lol - when it comes to automations - I don’t know what the heck format AirTable is following - but I know I made the automation to send me an email when a record falls into the “current day” - any input much appreciated. Thanks! Edit 1: Because look the automation says when it falls into Today - Image 2022-09-20 at 4.34.12 pm … and the date is… Today! - Image 2022-09-20 at 4.38.04 pm - so why is it coming up one day late? :thinking:

Hi all, I am seeking help with a base that records football data that I am a coach for. I currently have a Base with two tabs. One is for all the players names, positions, address and general emergency contact information. The second tab is the ‘Games’ tab. Here I record the team playing, Date/Time, Location, Type of Game (Tournament/League), Home or away option, who was in the team (Attendance) score and who scored. I am having huge issues trying to get the data to add up the goal scorers when they score more than 1 or 2 goals and how to best record that so it can show a total on an interface. Is there anyone able to help please, happy to jump on a teams call to discuss if this helps. Airtable support are scratching their heads at this one at the moment or would seem to over complicate the system. Thanks in advance

I’ve created a couple of automations using trigger events - if a record is created in Table A, create a new record in Table 1 populating a subset of fields. When I test the automation it works fine. Yet, in practice, it appears to be adding blank rows in Table 1 vs populating the actual data. Any thoughts on how to fix?

Hello, When I use an AirTable form to upload an image attachment via web search , the subsequent image URL does not come with a file extension (e.g. https://dl.airtable.com/.attachments/231bcb7e4fc58c1ddd69fa9f2cf112f2/894c6793/What_animal_welfare_problems_are_associated_with_dog_breeding_… ). This causes issues when I try and use this URL to upload an image into Woocommerce via Integromat. Any suggestions?

Here’s the scenario: I have a webhook that pulls in data from one source The data should create or update data in 4 different tables All combinations of existing/non-existing data for each of the 4 tables are possible (I believe 32 total, maybe 64) Issue: Conditional actions only run the first condition that is true To account for all 32-64 of my possible combinations, I would need to create 32-64 different conditional action steps, since only one can be true Can anyone help with a more efficient way to do this?? Having 64 conditional action steps seems absurd. I’ve read through tons of articles online and there is no workable solution. Help is much appreciated!

Hi all, I’m building a table to track items availability (musical instruments) for students to sign out and borrow for a limited time. My base has two tables, one with the instrument catalogue (containing general information on the instrument, brand, etc. Also has a field of whether the instrument is in stock or unavailable). The second table is the home to the form for instrument request, these requests come in as a name, instrument requested, and date needed. The email autopopulates from a student directory and the return date autopopulates with the dateadd formula. I already automated emails to the students based on these dates and it works fine. What I am not able to do is to automate a change in status of the instrument. I would like for the “Status” field in Table 1 to change to “unavailable” when the next sign out date is “tomorrow” (as automation allows you to set) in table 2. The problem I’m having is when I’m setting up the configuration for the “update record” step, it asks

If I find a bunch of records in step x and try to update them in step y I’m getting the following error: ‘received invalid inputs’. According to the docs (Find records automation action – Airtable Support) it should work: “One recommendation is to use the update record action in order to update one set of records using data from the records found using the “find records” action outlined in this article.” How? Just to be clear, it works fine with 1 record, just not with a list.

Not sure why I am suddenly getting this error. It worked before but, not sure where the error is. I’m checking each tag in each record from a table and comparing it to another table. If any matching tags are found, create an array of object ID’s. After all are found (loop is done), then update.

I am trying to set up an automation that keeps track of how many videos my editors are completing a week. I currently have it set up to send me a slack message every time they set the stage to be “completed” but I would like it to say something along the lines of “Mark has completed 2 of 10 videos this week” and then have that number both increase throughout the week and reset at the beginning of the week

We use the Slack:Send a Message automation to send new messages to channels. Is it possible to reply to an existing message? I’ve been able to capture the Slack Message Identifier (permalink), but I’ve not found any options in the AirTable automation that would allow a reply. Use Case / Details: AirTable 1a) Form Submission 1b) automation: NEW Slack Message “Confirmation of Form Submission” (includes AT record id) Zapier 2a) monitors channel for new bot messages 2b) Zapier formatter to extract the AT record id 2c) update AirTable record with ‘slack permalink’ AirTable 3a) Record status “complete” 3b) automation: use the permalink to REPLY TO (1b) - “Request has been completed” I could use Zapier for step 3, but would prefer to use AirTable if at all possible. thanks! p.s. this is the format of the permalink, but I can capture channel ID (cid) , timestamp (ts) if that will help develop the action: https://xxxxxxxxx.slack.com/archives/xxxxxxx/xxxxxx?thread_ts=1663343544.273199&

Hi all! I’m working on an automation script which needs to get the current date so that it can be formatted for a URL. However, calling the .getMonth() function on a date object returns an incorrect month. I can of course correct for this by adding 1 to each month but would prefer not to. I’ve created a new script which creates a date and logs the resulting month to demonstrate my issue: The code: The resulting console logs: Has anyone encountered this issue before? Thanks!

Hi, Is there a formal that I can enter in the “Color” “Conditions” to mark when there is a duplicate Name? Or is there some other way I can flag duplicate records? Screen Shot 2022-05-31 at 3.44.08 PM|601x251

I’ve upgraded my account and I can verify that $12 has already been charged. But I still couldn’t use “Run script” feature inside the Automations tab for a space belonging to the workspace that is in “Plus plan”. And also, I can still see the alert “Over limits” in the page of one space. But since I’m in Plus plan now, it shouldn’t give me this alert.

Here’s how the data looks: { "gatewayMessage":{ "gatewayID":"956995" , "gatewayName":"Ethernet Gateway 4 - 956995" , "accountID":"40029", "networkID":"66417" , "messageType":"0" , "power":"0", "batteryLevel": "101" , "date": "2022-09-16 00:00:30", "count":"3", "signalStrength": "0", "pendingChange": "False" }, "sensorMessages":[ { "sensorID":"701519" , "sensorName":"Cooler 1", "applicationID":"2", "networkID":"66417", "dataMessageGUID":"88e199c6-62a3-4d2c-9a57-7c0a375282d0", "state": "16", "messageDate": "2022-09-16 00:00:03", "rawData":"7.9", "dataType": "TemperatureData", "dataValue": "7.9", "plotValues": "46.22", "plotLabels": "Fahrenheit", "batteryLevel": "13", "signalStrength": "76", "pendingChange": "True", "voltage": "2.24"

Hi, we run automations on Airtable combined with webhooks and pabbly connect. Since we use our base as inventory system, we would like to know from which order the stock changes comes from. So we decided to at the order numbers in a field, which will be changed every time an order comes in. Today we found out that if there are orders in the same timeframe, the history changes the stock in a correct way but shows only the last ordernumber, which means that the numbers have been combined automatically. In the screenshot you can see that the stock goes from 2 to -1 (3 orders) but only the last ordernumber was taken: Is there any way to show the full history, since we need those numbers for internal adjustments.

As in the title, I’m trying to update multiple records with the results of a Find Records step. I’ve got my ‘When a record is updated’ Trigger and ‘Find Records’ Action step set up correctly, but I’m having trouble with the script Action that comes afterwards. I’ve adapted the code of another forum user (which updated a single-select field when records matched Find conditions): let jobsTable = base.getTable("Jobs") let packagelinkFieldName = "Package Link" let inputConfig = input.config() let recordsToUpdate = inputConfig.recordId let thepackagelink = inputConfig.packageLink let updates = new Array for (let record of recordsToUpdate){ updates.push({ id: record, fields:{ [packagelinkFieldName]: {name: thepackagelink} } }) } while (updates.length > 0) { await jobsTable.updateRecordsAsync(updates.slice(0, 50)); updates = updates.slice(50); } The error I’m getting is: Error: Field “fldZN1J0lfQqAQwXo” cannot accept the provided val

Hey all! So I wanted to create an event, and CLEAR or DELETE the Google Calendar even when a checkbox/flag is clicked. This would be used when we cancel or reschedule but don’t want to delete the original entry. Currently I have three automations: These all work beautifully, but I wanted one more automation, unless the #2 could also update, but figured it’d be better to keep it separated as its own unique automation. Any ideas? I don’t see an option “Delete Google Calendar Event”. Thanks. Sean L

When including a checkbox field in slack message automation unchecked displays as blank instead of false. Could get around with a calculation field but that seems like unnecessary extra work.

Is it possible to select records in scripting with specific conditions? If I wanted to get all the records that have a field value of green, how would I write that query? I don’t want to just get all the records; I want specific records with more than 100 results.

Is there a quick way to switch which record is the test input for a script automation? Can’t seem to figure out how to change it, but makes it hard to build out a new automation on existing data if you don’t want to force modify old data! Currently, I’m trying to write an automation that is triggered when a form is submitted, but it’s testing on a row that wasn’t created by that form, which means nothing works quite like it should (nor should it!)