Skip to main content

Automations

Ask your questions about Airtable Automations here.

  • 5,195 Topics
  • 16,198 Replies
5195 Topics
M
milhauserNew Participant
asked in Automations
Saving/Copying the record values after updating them

I have this table to track some gym progress.I have a number of updated values for each record, e.g.:for a 1 set of 10 for 245 for b 2 set of 8 for 356and etc.there is also column for tracking the latest update.I need to be able to somehow store the progress/history of this values. So what if i update smth like this:for a 1 set of 10 for 245 => for a 2 sets of 9 for 250i could have bouth record in my baseI'm aware about the Revision history function, although it's not providing acces to the information in the most comfortable wayIs there a way, through some formula/automation/etc. to copy the current record each time i'm updating it? 

31
TheTimeSavingCo
T
TotoluvrNew Participant
posted in Automations
Looking for an AirTable developer to automate our workspace

Am looking for a developer that can connect our Airtable to DocuMint for automation. Also have additional automation needs that need to be addressed.  Please respond below with email and we will reach out!

41
ScottWorld
W
WillCNew Participant
posted in Automations
Enter specific text on button press

I'm new to Air Table and having trouble finding a solution for this. I want to press a button to update a record with some information provided by the user. So on hitting the button I want it to set one field to "Completed" (which is fine), one field to todays date (which the work around seems to be having a formula on the table that this can be grabbed from) and the name of one of our team. Ideally the name of our team member would be selected from a drop down but I would settle for them typing it in somewhere. Is this possible?

143
kuovonne
S
Sigurdur_HermanInspiring
asked in Automations
'contains' vs 'has any of' in automation condition

TL;DR: what's the difference between 'contains' and 'has any of'?I'm setting up some automations with a 'when a record matches conditions' trigger.When I set my 'find records' trigger to the condition 'has any of' the dynamic value I want to use, I get 'invalid value: when a record matches conditions cannot be converted to an array of string'.When I set the condition to 'contains', it works perfectly.What is the difference between 'has any of' and 'contains'? In natural language the two are synonymous (to my sense of the language, anyway), but I assume there's some important distinction in the underlying code that I don't understand.

1030
S
T
timlinesParticipating Frequently
posted in Automations
Creating an AirTable Script to Record the Duration of a Single Select Field

I'm intending to create a simple AirTable script to record duration of a single status field. In my use case I'm tracking a large number of issues where the status frequently goes back and forth between the multiple status',For example there are multiple status':  open, in-progress, and resolved status. A normal workflow would be non-linear, so a record could go from open to in-progress, back to open, then to resolved then back to open, and then finally to resolved again.open > in-progress > open > resolved > open > resolved.I'd like to track the duration that each record is in each status as well as the cumulative time each record is in each status. This way I could say this record was open for a period of 3 days, in progress for 1 day and it was  in a resolved status two days. In the first table I have several records with a status field and a time modified field as well as other important data fields to help identify the issue, like name and the primary

298
T
G
GrimiKnown Participant
posted in Automations
Automations - Updating records - Received invalid inputs - how to solve?

Hi to all! I am having a problem using Automatization for updating numbers in one table, when some conditions are matching in the other one.In table Bills I need to have an updated (lesser) amount of each bill, when in the table RatenPayment a part of that bill is payed. The Trigger is working (consist of the elements if date of the payment is not empty, and when the amount of the partial payment is given).However, the Action in the Automatization keep showing me error (but it seamd to be such a 'peace of cake')....Thank for ANY kind of a help, I am struggling with it more then a half day.. 

282
G
K
kumar99New Participant
posted in Automations
How to create custom new table, form views using automations or scripting?

Is there any way we can create custom table, form views using airtable scripting or automations?

181
TheTimeSavingCo
J
johnchNew Participant
asked in Automations
Trigger formula field update with automation

Hello, looking for help on how to trigger the update of formula field when a record reaches a condition. My example is the following: I have a "Birth Date" field which contains the birthdate as Date. I have a formula field which calculates the current year "Anniversary Date": DATETIME_PARSE(YEAR(NOW())&"-"&DATETIME_FORMAT({Birth Date},'MM-DD')).How can I trigger the update of this "Anniversary Date" when the record reaches the day after the anniversary? 

181
TheTimeSavingCo
A
amundsen_shackNew Participant
posted in Automations
Add Task and Assignee from one table in another

Hi,I have a base called "Tasks" where each record has an Assignee.I created a new base called "Timesheet" to enter the time spent on each Task with a form or interface.When a new Timesheet record is associated with a Task record, I would like the Timesheet table to add automatically the Assignee for the Task related to that Time entry.I'm trying to get this done by having an Automation that looks for Timesheet records which have an Associated Task not empty, then finding the corresponding Task in the Task base, and finally adding the same Assignee to that Timesheet record.However, the Automation does not allow me to search using the "Associated Task" field because it says "No valid nested options".Is there a way to get around this? Or a better way to connect my tasks and assignees to a timesheet?Many thanks!!! 🙂

191
TheTimeSavingCo
R
Rperkins95New Participant
posted in Automations
Airtable and ETapestry or Blackbaud

Hello!My current data base and forms are connected to Blackbaud and E-tapestry. I'm not fully ready to commit to downloading everything into airtable, but wanted to know if you have seen a successful integration with these systems?For context:I'm creating a speakers Bureau and want my updated information to go into E-tapestry. I would also be pulling reports from e-tapestry to integrate into airtable. The forms on E-tapestry are outdated and clunky, I would much rather use airtable for this.I'm also to look automations where a speaker enters information and we send a thank you email. That is also clunky with e-tapestry. But I still need the data to sync between the two for now. thanks! -Rachel 

151
TheTimeSavingCo
M
mmr1443Inspiring
asked in Automations
How to automate copy/paste from one column to another, and determine appropriate trigger?

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 records are being created in the accounting workspace.We then generate a "price code" based on the company name and the product. The price code reference a price list which is a different table in the accounting workspace. I have nearly all the mechanics of this worked out, but currently have to manually copy/paste from "price code" column to "price" column (see screenshots). I'd like to automate this, but I've had trouble with the tutorials I've seen, and I also don't know what an appropriate trigger would be.Thanks in advance for any help!

792
M
M
Marcus_LeeNew Participant
posted in Automations
Automation Add Option to "Multiple Select" Field that might be empty or filled

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 would rather not

11515
N
A
alphrbNew Participant
posted in Automations
Outlook received email trigger - Unsupported input expression key

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 !

11
ScottWorld
S
Susan_StevieNew Participant
posted in Automations
automation trigger 'when a form is submitted' - table with 2 forms

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?

71
TheTimeSavingCo
A
amundsen_shackNew Participant
asked in Automations
Automation: Update record from a different table

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. 

2074
A
K
kayaladnpNew Participant
posted in Automations
connecting two columns on different tables

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? 

10
K
U
username1New Participant
posted in Automations
Create a record one hour before another existing record

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 

116
TheTimeSavingCo
S
SNQRNew Participant
posted in Automations
Woocommerce API in script automation

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 understand why i have a forbidden access with the script 😕😕 So i tried to pu the authentification in the headers :   const reponse = await fetch("https://website.com/wp-json/wc/v3/products/54188",{ "Method":

10
S
A
Adam_Abdur-RahmNew Participant
posted in Automations
Sending stripe invoice from Airtable

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:  Does anyone have any idea why this is happening? 

221
Kenneth_Raghuna
A
AlixNew Participant
asked in Automations
Automated Slack message - Chronological list?

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!

221
A
T
theau11New Participant
posted in Automations
Automations problems

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 ? 

21
Vic_Airtable
theskiffguy
theskiffguyNew Participant
posted in Automations
Table tab automation trigger ??

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

21
Vic_Airtable
A
Ann_YeomKnown Participant
asked in Automations
Modify "Create multiple records" script so it can be included in an automation

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 deliverables input.config.field('delivField', {

636
A
M
Manuel-TancoNew Participant
asked in Automations
How to input workflow data into a JSON body through Script

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: { "Content-Type": "application/jso

413
M
J
Joachim_BrindeaInspiring
asked in Automations
Removing one record from a multiple linked record field

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

656
C

Badge winners

Show all badges
Terms & Conditions