I'm trying to create an automation to update a record. I want to change the status of all tasks associated with a sprint to have an "archived" when that sprint is "done".The trigger is based a table called "Sprints Lists" with a condition of "Status:...
Basically we have two workspaces. One is for project management. The other is for accounting. Once the project has been completed, we change it's status to "ready for accounting" which then automatically syncs with the accounting workspace. So no new...
Hello everyone,I come again to ask for your help on the automation for integrating Airtable records into a Google Calendar. This automation only works when I duplicate my event in Airtable. I attach the capture of my automation. Do you have a trick t...
HiI have Table 1 with two columns (A and B).On my Table 2, I want to ask airtable to take the Table 2 column A and "read" or match any words to Table 1 Column B and automatically tell me where the matches are instead of linking then having to manuall...
I have a table with 2 forms. I set up an automation that is based on 1 of the forms but it's pulling records submitted from both forms. Anyone else had this problem and found a solution?
Hello! I am hoping to send weekly staff wide emails detailing a list of upcoming programs and events at my Foundation. I set up the Automation and it works well. However, the dates are ordered by when a record was created and not based on the actual ...
Hello,First, sorry for my english.I'm new in javascript development and i'm trying to update some product on my woocommerce website from airtable.In the automation, i have a script where i try to retrieve a product, i use this code : const reponse ...
Hi everyone!I'm trying to create a simple automation to send notifications on a specific Slack channel once action X occurs. PROBLEM: when I try to connect my work Slack account, Airtable tells me that "the selected account is not valid or no longer ...
I wrote a script for a client to place holds on a credit card via Stripe using this example. . The script works fine when I use a test key, but does not work when I switch to the live key.My initial thought was that this must have to do with permissi...
I need an automation to remove a linked record from a linked record field, without removing all linked records from that field.For instance, if a student is in enrolled in the courses 'knitting for war, animal husbandry and marriage, ice cream + pies...
Hi everyone,I am following along a tutorial and creating a CRM where I can send stripe invoices from: Send stripe invoices from Airtable | AATT#17 (30:00)I am in the process of catching a webhook from the 'send invoice' button in the 'invoices table'...
Hello,I am unable to set up the trigger for an outlook email received. It looks like the api is not able to get access to the "folders" data.The error message returned is : "Unsupported input expression key" (see screenshot below).Does this has to be...
So, with my limited scripting and Java skills I've been trying to set up a script that will call a webhook so I can later trigger something there. I managed to set up the basic ping but I came across the ideal of sending some record ID's I need which...
I've a table that generates records through the Airtable built-in form. Each record comes with an ID from an external software. The ID is connected to accounts in this external software, so account 1 could have ID: 123, account 2 could have ID: 1234....
Hi,I've been trying to modify the Airtable script (Create records from multiple select) pasted below into an automation as an action. I was thinking removing the input commands and replacing the table/field location to my specific fields would work b...
Hello Everyone,Quick question, do you know how I can modify the time at which a slack message is sent.To give you more context, I have a daily time table with a todo including activities to be performed in the morning and in the evening.I have create...
I see several posts that are similar to my question, but I haven't been able to find the actual solution yet. I have a database of all our locations, and at any given time we have about 40 pending locations. I'd like to send an automated email to th...
I am trying to send an update email in the automation section with the sum totals of each field like they are displayed in the grid view. However, when the emails are sent the sum row is removed. Does anyone know how to maintain them within the email...
I have an automation which sends a slack message at a scheduled time with a list of tasks due that week, sent in formatted single messages for display purposes.It's a repeating action which runs through a list found, but it never runs in chronologica...
Hello everyone! I'm new to airtable and I have been working on automation that when triggered, it decrements 1 from a field. I have been trying to find a solution but nothing seems to work. I appreciate any help that I can get.
| User | Count |
|---|---|
| 462 | |
| 395 | |
| 290 | |
| 193 | |
| 188 |
