Automations

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!)

Hi there community members I’m still new to airtable scripting and really need your help in solving the timeout problem on one of my scripts. I’m getting a script exceeded execution time on the following code. What can I do or how can I change the script to prevent it from happening console.log(“Start Ditribution script”); let inputConfig = input.config(); let leadRecordId = inputConfig.recordID; let tableLeads = base.getTable(“LGA Leads”); let query = await tableLeads.selectRecordsAsync({ fields: tableLeads.fields }); let leadRecord = query.getRecord(leadRecordId); console.log(leadRecord.getCellValue(“Lead Key”)); I see the 1st console.log, but not the 2nd, so I assume it must be happening when I’m opening the table. The table has a lot of records.

I have already done this process on another base, but now it just doesn’t work. convert email address to and I get this error code Same with the ARRAYJOIN Thanks in advance!

Hello, I have a little script in automation, but when we copy the database, we need to test it manually every time. Is it possible to do this automatically? Thanks for your help

Hi there! I am trying to send personal & private reminder messages via Slack to people in my team. For that, I created automation and would now like to add a dynamic (colleague+me) channel ID which is connected to their name and therefore allows me to also put a dynamic (personalized) greeting. However, I am not managing to get the automation working. Is it possible at all? Do you have any tips on hand? Please don’t hesitate to ask questions in case it is not 100% clear, I am conscious that I am having a hard time describing my issue. !

I have created a form that we want to send to our customers with some data prefilled. The form is working correctly when i follow the link from within the Airtable, however, when sending it in an email some of our links get changed. For example “?prefill_Company+Name=rec4C08RaU1jF9SZG” is changing to “?prefill_Company+Name=rec#C##RaU1jF#SZG” It appears that all numbers are being changed to a ‘#’ Any information would be greatly appreciated. Many thanks in advance

Hi! I’m trying to build an automation for a social media tracking table wherein when a user selects a status from a dropdown (ie Facebook, Twitter, Instagram, etc.) that Content Title will automatically have a suffix added (ie /FB, /TW, /IG, etc.). Any suggestions on how to build that? Thanks for the help!