Automations

Hello. I have a Status field which is “Multiple Select”. I am trying to build an automation that automatically adds “new” to the Status field when a new record is created. However, the Status field may start empty or it may start filled with other options from the “Multiple Select”. I can make an automation that works when the field starts empty (just assign “new”), but this will erase any other options if the field starts filled. If the field starts filled, I can assign “new”,{Status}, but this gives an error when Status starts empty ({Status},“new” also does not work). The error is ‘Failed to construct the value for “Fields”.’ So I cannot account for both at the same time. However, my table will have both cases for new records. Am I missing something about how to concatenate the already selected options with my new option? The work around I have found is to use an additional formula field that either fills “new” or concatenates "new, " to a non-empty field. However I

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 solved in outlook or in airtable? Thanks for your help !

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?

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: Done".And as an Action I want to edit the "Status" field from a different table called "Tasks Lists" so that the new value of Status is "Archived".I've tested the trigger successfully. However, when I click on the "+" button to select the corresponding Record ID from the "Tasks Lists" table, it only shows the fields from the "Sprint Lists" table used in the trigger. 

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 manually check where the matches are.Is that possible? 

Hello everyone,As a event planner, I would like to set some automations to create another record when one specific is created. I would like to create a 1 hour long record "Set Up" when I create a record "Meeting" to have the set up already writen in the planning without having to write it myself.Do you know how I can do that?Thanks in advance 

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 = await fetch("https://website.com/wp-json/wc/v3/products/54188?consumer_key=ck_xxxxxxxx&consumer_secret=cs_xxxxxxxx",{ "Method": "get", "Headers":{ "Contant-Type" : "application/json" } }); return await console.log(reponse);  but i have a 403 error (Access Forbidden). When i put this "https://website.com/wp-json/wc/v3/products/54188?consumer_key=ck_xxxxxxxx&consumer_secret=cs_xxxxxxxx" in the url, i have access to the product, i don't un

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'. In the subsequent step 'Find Record in Airtable' - I've set the search value to be the Record ID found in the webhook request.Lastly, I am attempting to create the invoice item in Stripe.I am running into an issue at the end however: 

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 chronological due date order and I need the list to appear in chronological order. Airtable has on their guide that it can't guarantee the order of the run and you should consider other options. What would these options be? Help would be much appreciated, thank you!

Hello,We are the company La Nouvelle École, We use Airtable and our old plan was limited to 5,000 automations.As we were going to exceed the limit, we moved to the next plan by buying the next higher offer on March 20th. The next plan was 50,000 automations.And the problem is that the total automation bar remained on the old model.So this problems has stopped our automation system. Someone knows to fix this problems ? 

I want to have an automation that when I click a certain table tab, it switches to a certain dashboard... can I do this ?The reason is in Dashboard 1 I have a map API showing locations based on addresses in that particular table.I want to be able to click on table #2 tab and see the map on dashboard 2 which will show locations based on that particular set of addresses      UNDERSTAND ??   can I do this ??

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 but having more trouble than I thought. Any one able to help me out? I'm looking to modify the script below so I can include it in an automation.The tables and fields would stay constant.   // Script settings let s = input.config({ title: ' Create records from multiple select field options', description: 'Creates 1 record in another table for each option in a multiple select field in the source table, and links the new records back to the source record.', items: [ // Source table select input.config.table('tableSource', { label: ' Table with existing records' }), // Source table: Multiple select field with delive

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 can save me a step later on.My error is surrounding inputConfig and how to parse it into the JSON body (I guess?)The error most likely lies in line 4 and 5, hopefully it's understandable what I'm trying to get done. For line 4 and 5 I also tried "" but that simply sends over the whole thing and not the input I setup in the script (picture attached below) let inputConfig = input.config(); let body = { "ping": "Survey Ping", "company_id":${inputConfig.contact_id}, "contact_id":${inputConfig.company_id} } let response = await fetch('https://n8n.joinowners.co/webhook-test/tally-onboardinglaunch-survey', { method: 'POST', body: JSON.stringify(body), headers: {

Hello everyone, I have: a webhook sending a user RecordID. a linked record field containing multiple users How can I remove just that one user from the linked record field? So far I’ve managed to add a single user, or to replace them all with one user… I would appreciate some help! Thank you

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 automation structure? 

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 an automation to send a reminder of the todo be slack. Is there a way for me to configure the automation so that the todo of the morning is sent in the morning and the one in the evening is sent during the evening ?Thanks a lot

Hello,I have a very basic automation and I can't figure out why it doesn't seem to be working.... when the amount paid is equal or greater to $300, I want to have a check box or single select text that says they are paid in full.I have a screen shot of the test I ran in the automation where it looks like the 'yes' single select text is added.  but when I go to my base, it's not there.  I've watched over an hour of help videos and tried multiple things.  I'm a newbie, I would appreciate the help! Thank you!!

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.

Hi - Sometimes our automation email works and sometimes it does not... What could be going wrong?  

Hi, I have a sales team that inserts every sale into a DB on to Air TableI would like 2 do an automation that sends me a daily report with1 - Sales on current month (how much)2 - Sales on current month (how many) 3 - Sales on current week (how much)4 - Sales on current week (how many) Maybe make it in 4 different emails and get those numers in the subjet like "Daily Report - Monthly Sales = R$ 1000 / 10 sales" and "Daily Report - Weekly Sales = R$ 500/ 5 sales"Is there a way?The field names are "Pagamento 1" for date "Valor Total Projeto" for amount of money of each saleThanks in advance =DJuan  

Hello, my usecase is to sync a record whith a third party server using an HTTP Request and write back a sync Id. The behavior of AirTable feels very weak for somthing that should be simple.Trigger an automation on Create and Update require 2 automations ! So duplicate and maintain script code . The workaround in an other message is so complicatedAutomation trigger while editing, sometimes it is usefull, in that case it's a real pain that trigger multiple request in parallele. Automation should have a flag to prevent that. 

Hi all!I'm working on building a Google Docs Automator where the automation updates a google document instead of creating a new one. I was able to create the content to pull all of the applicable data I need, but I noticed it's just adding to the content of the google doc, rather than replacing the content in it. Is there a way to set up the automation where the content is replaced with each automation run (i.e. "update")?For reference, this is to build itineraries for individuals that I have set up to update once a week (for now, but may increase the frequency later) - so it gets a bit cumbersome and superfluous in the document very quickly if it keeps adding a full schedule on top of what was already in the document - not to mention confusing for the folks referencing the schedule.Thanks for any help that can be provided!

Hey folks, I can’t create an event based on dates in my table. I need to create an event based on formula born date-times, and that didn’t work; but even now testing with normal date columns (with hardcoded values) didn’t work as well. It encounters an error: Unable to parse datetime: “” But there is definitely data in those columns. Here is an illustration.

I am needing help.I am needing to send 1 record to a group of email in different states. Ex: One email request to and email group in TX, another different request to an email group in FL and have it automated when the state or country says the group. (TX to TX group, UK to UK group, FL to FL group)  

Hello!  I've been mulling over how to optimize an image in the body of an email for an automated gmail connection- to send an email based on airtable records.  I was able to add the image using airtable supported in-line HTML tag <img src="https://www.btsministry.org/images/logoNEW_02.png">It optimizes perfectly on mobile, but the image is massive on desktop/laptop viewing sizes. I've currently not had luck including image sizes through Style or including specific px sizes. I.e. style="width:300px;height:150px”; Any suggestions on how to optimize the image size using airtable's supported HTML/CSS (span, style, img) ? I may just have the html syntax wrong 🙂  Thank you!!