Skip to main content

Automations

Ask your questions about Airtable Automations here.

  • 5,190 Topics
  • 16,153 Replies
5190 Topics
K
kb11New Participant
posted in Automations
formatting issue with "Update record" automation

I'm running into a formatting issue when I try to update a text field by populating it with form responses.I have a form that collects a user's name, a text field for "Troubleshooting Notes," and a timestamp for when the form is submitted. An automation sends these results to a text field on another table. The automation has conditional actions to see if the destination text field is empty or not. If the field isn't empty, then it preserves the existing text, and just adds the new data below. I've attached screenshots of the automation actions.The automation works...mostly. However, if the destination text field is empty to begin with, then the automation adds three line breaks before pasting the form results. So, the text field looks empty unless you expand it and see the text hidden at the bottom. Does anyone know what is causing this formatting issue? It doesn't seem to happen if I remove the conditional statements, but those are necessary parts of my automation.

105
TheTimeSavingCo
N
NV16_2New Participant
posted in Automations
Help with workflow automations

Hi everyone. I need help with some automations. I want to replicate my ClickUp Workflow in Airtable. New to airtable. Thanks!PS...Check the image attached

61
M
E
Edward1976Inspiring
posted in Automations
Script has no errors but nothing happens

I have written the following script which attempts to check if a field has the value "Definition" and if so make selection on specific single selection fields on a random basis. The reason for this is that the values will be used in a series of image mockups.I am completely new to both airtable and scripting so have absolutely no idea why this script doesn't do anything, but also doesn't throw any errors. I also don't understand (despite being on the pro trial) why I can't seem to add scripting as an extension - it just says 0/10 added. However, when I go to the automation tab in the table, I can see the script I added (along with another one that works). base.getTable("Pre Mock Prod (YP-PP)"); let query = await table.selectRecordsAsync(); let records = query.records; for (let i = 0; i < records.length; i++) { let currentRecord = records[i]; let posterType = currentRecord.getCellValue("Poster Type"); if (posterType.name === "Definition") { let options = ["_p_d

575
E
T
thatkidrichNew Participant
posted in Automations
Update a field value with a script

I am at a loss. This seems like it should be the easiest thing in the world. I am trying to write the TableID using a script to a field called "TableID". I have the variable value:var id = base.getTable("Target Activity").id;This returns the correct value. However, I can't figure out how to set the value to the field. Am I missing something?

2121
kuovonne
A
AdminEANew Participant
asked in Automations
Automation Help

I have a client who has submissions to an AT base via jotform that populate into a master 'customer' database. With the business, there are different approvals that occasionally happen that need to be noted. There are multiple events throughout the year, and the client is asking if there is a way to timestamp when they were approved, so that when they are approved, it updates the master database. Furthermore, they would like to be able to search the main database, and when they search for that customer, it will automatically show the approval, and the date of that approval.They would also like to be able to see all events that they have participated in. Now, to throw a wrench in it, they only have 2 events open each registration period, which uses a different jotform for each event, but they all currently populate to the main database. So, there are duplicate customer records with the same name, if they've registered for multiple events (in the main database). We would like to find a s

120
TheTimeSavingCo
cvoith
cvoithKnown Participant
posted in Automations
Milestone task auto update

Hey there! I'm trying to have a Next Milestone field automatically update. In my Projects records I have a "Next Milestone" field that I would like to automatically update to the next milestone "Task" as we move through the project. I'm currently trying an automation like this:Trigger: When a record matches conditions if Task Due Date is after todayAction: Update record -Table: ProjectsRecord ID: Airtable Record IDFields: Next Milestone - Airtable Record IDIt's obviously not working but I'm hoping someone can help. Thanks in advanced!

63
Marielle_Gueis1
R
RomasvlNew Participant
asked in Automations
Creating an Automated Link Between the Orders and Products Tables Using SKU as an Indicator

Hi, I have the following task:I have two tables Orders and Inventory.I am loading an order from Amazon sellercentral in the Orders table. Each order has a column SKU (unique indicator of the sold product).The Products table stores the products that we sell with all the detailed information.Question: How to make the Orders table automatically pull URLs to the vendor's product page from the Product table, using the SKU as an indicator.In other words, for each new order, automatically fill URL in Order table (Supplier URL column) from Inventory table using SKU. 

180
R
A
Ana_Lara1New Participant
asked in Automations
Automate a self-link field when a new record is created

Hi,I am working on a base pulls the information to page design, that we use to run meetings. Because of the way page design works, I had to create a field that links to the same record.What I am trying to do is to automate this part, where if a new record is created, it automatically self-links in the self-linked field.Would that be possible?ThanksAna

50
A
S
Shawn_GarlandNew Participant
posted in Automations
Adding The Same Information To Multiple Fields & a Complete "All Sub Tasks" Button

I am in the process of rolling out AT for Software Deployment Projects that I manage for about 6 different people.We have a Projects Table, Tasks Table and a Team Listing Table. When the tasks are created, we have to manually assign the Engineer to each task, when its always going to be the same engineer doing every task for that specific project. The Engineer is a linked field from the Team Listings field. Theres also a Rollup field that captures this information.I would also love to do the same for other fields as well, like a CRM Case number field that is the same for each task. I would also love the ability to click one button, and complete all subtasks (Long Text with RTF field formatted with checklist items)I have a script that was written for us during implementation that creates the tasks already, if that would be helpful.Thanks!Shawn 

41
TheTimeSavingCo
G
gl3nnwilfr3dNew Participant
posted in Automations
Automation - Update Records: Updating more than just 1 record to a synced field

Hi, I have an organizations table and a contacts table.Every time a contact gets updated with different organization name under the contacts table - I need the organizations table to update its synced field with the contacts name, but i need the automation to update the organization table with more than 1 contact record in the synced field, Is this possible?

72
G
P
Peter_BuckNew Participant
posted in Automations
Reporting and Automations - Many Enterprise Features are DOA

It has been a long time since the promise and reality of a product is so far apart. I am a fan of Airtable until you have to do any meaningful reporting or distribution of data. Charting is worthless, even using vega-lite, a great tool in full form is turned into a hollow shell with "lite." Charts and Reports from Data Fetcher is much better but cannot put Data Fetcher on an "Interfaces" dashboard, so it becomes less useful. This leaves me with PowerBI queries or Google Automation, both are fine but just another place to have to do work.Then I found automations that can create a Google doc or an Outlook email. I thought my day was going to immediately get better. Then I find that product is about 20% complete. For example, if you want to report on a Activities table that has a link to a Customer to use as a subject like "Status report as of [date] for [Customer/Project], the automation adds the customer name to the subject line for as many records as in Activities. Not to mention, you

50
P
C
CoastalHealthNew Participant
posted in Automations
Running Balance

Hi everyone. I am new"ish" to Airtable and have very basic understanding of coding.I am trying to doing up a paycheck budget. My primary table calculates income vs expense for the 2023 paychecks so one can organize paying expenses at the time they are due instead of putting away a % each cheque. However, I cannot get the balance from the last pay check (record 1 field 8 lets say) and add as income to the next paycheck in the pay period (record 2, field 3) and repeat. It is so simple in Excel but for visualization and organization I'd prefer to stay with Airtable. Any help would be greatly appreciated.

131
TheTimeSavingCo
X
xXTMXxNew Participant
asked in Automations
Automate Task Creation in projects via a script

Hello everyone, i have a set of tasks that once a lead moved from one stage to another those tasks should be created. The set of tasks already listed in a Table called "Tasks Reference", content of the table as below:Linked with another table called "Tasks Stages Reference", content of table as below:"Tasks Stages Reference" this table is have all possible stages that the lead can go through.I also built a junction table that will have the tasks that will be created for any lead, called "To Do's", as below:Here's the script:let inputVariables = input.config() let lead = inputVariables.leadName let stage = inputVariables.stageName let leadTrackingT = base.getTable('Lead Tracking'); let tasksT = base.getTable("To Do's"); let stagesTemplateT = base.getTable('Tasks Stages Reference'); let stageTasks = []; if (stage) { for (let task of stage.getCellValue('Tasks Reference')) { stageTasks.push( { fields: { 'Task': task.name, 'Lead': [ {

145
X
Andrey_Kovalev
Andrey_KovalevInspiring
posted in Automations
Automation runs limit per month to reset

Hi guys! Recently I have run out of my 50000 automation runs limit. I can see that the last successful automation ran on January 2nd. Does that mean I need to wait until February 2nd for the counter to be reset? Does anybody know any details on the matter?Thanks in advance for the info.Andrey

487
Andrey_Kovalev
L
Lost-MerovingiaInspiring
asked in Automations
Stripe Payment from Webhook Decimal Issue

I'm creating an automation in Airtable where the info from each stripe payment comes though. The price comes in without decimals, so I thought it would be easy to add a conditional action that is there isn't a '.' in the dynamic object I could just add it within the automation, but ... its seems to be out of my comfort zone.Is there a Script that someone has to do this?  or another workaround?

200
L
K
Klaus_BostelmanNew Participant
posted in Automations
Automation counter

Is it possible to check how many automations have been executed in a given month?Thanks

1131
E
N
NamachaNew Participant
asked in Automations
Mail send date in automation

Hello everyone,I am currently discovering Airtable and trying to familiarize myself with all its features! Today, I am trying to update a date field when a select field is changed (example: Sending status -> sent, I want the date field to be updated with the sending date) but I can't find a solution, neither through scripting nor automation.Can you please point me towards a resource or any relevant information so that I can figure out how to do this?Thanks for your help ! 

40
N
A
ahyslopNew Participant
posted in Automations
Permissions Error - Automations

We have 2 tables Students + Tutors, within the Students table each student has a status set to 'Active' or 'Withdrawn' and also the tutor that Student has been assigned.Within the Tutor table, we currently just have 1 field displaying all of the Students for that Tutor, but we would like to automatically filter these with Automations when the student status is changed to show in separate columns if they are active or withdrawn (in the student table) Please see the below screenshot of the current setup I have setup an automation to do the above by running it if the student record is changed, we add that student to the correct column in the above screenshot. This works, but it currently overrides any data which is currently in the field, so I created an additional step in the automation 'Find records' to add before the new entry.However, I cannot seem to get this to work, I keep getting a permission error - please see attached screenshotDoes anyone have any idea why this is happenin

181
Marielle_Gueis1
S
Samantha_HebertNew Participant
posted in Automations
Using Scripts to Create Multiple Records in Automation

Hey, I’m working on a project management base were each ‘project’ has a series of associated ‘tasks’ that are populated upon the creation of each project. We’re a civil engineering company so each ‘project’ has 178 associated tasks. I’ve created a standalone record for each step, and want to automate 178 new records to a third table and then link the newly made project to each of those records. I think scripts are the only way to do this. Does anyone have some advice? Thanks!

10316
A
A
AlixNew Participant
posted in Automations
Failed Find Record automation

Hi, I hope someone can help.I have an automation where Trigger:When a record is updated - Episode number fieldActions:update - property field code with 'property field' (property field code text needed for next action)Find record - (in another table) where episode number = episode number and property field code = property field codeconditional actions:if matching record in the other table is found:update link field with matching recordif no matching record found:send a slack messageotherwise if no conditions are met - no actions runSo, this automation is running great, when the initial record's episode number is updated it's linking the record from the other table nicely.However, when the episode number was deleted from a record, the automation run failed at the Find Record action. Why is this run 'failing' rather than just running as the second conditional action - no record found (ideally like: episode number is empty = then no record found) is my question? Thanks! &nb

82
A
A
Angie_HannaNew Participant
posted in Automations
Create Google Calendar event time wrong

I had this working before, and someone messed with my automations. Searched but not finding the answer.I have two fields: Start, End.When a form is submitted, the automation is supposed to create a Google Calendar event with those times and I have those fields in the automation. The fields are configured as CST. However, the automation defaults to what I assume is GMT.Can someone help with the syntax of how to adjust the time in the automation configuration?

21
TheTimeSavingCo
S
Sharon27bNew Participant
posted in Automations
One form to support multiple table entries

Hi Everyone, Here is my need. There are five related tables in my database: People, Organizations, Events...Ideally, I would like to fill out only ONE form that would populate all 5 tables at once. Currently, I need to fill out 5 forms in parallel which is very time consuming.  Any idea? Thanks, Thanks!   

1922
Jason_Hill
F
FranckNew Participant
asked in Automations
Automation to change linked record based on manual field update

Hello all, I have two tables.MONTHS : https://airtable.com/shrkKQn1rwn5BcjksDAYS: https://airtable.com/shraNAmopa2LDZQxVIs there any way to make automation that each time I change manually the date of a record in DAYS table, it changes the field MONTHS wich is a link to the MONTHS table?i.e.: When the date is 12/01/2023 (European) it must be linked to the "23/01" record in MONTHS table, and if I change manually this date to 12/02/2023, the automation should change the link to the "23/02"  record.Thanks 

110
F
J
Joachim_BrindeaInspiring
posted in Automations
Script to go over the 100 found records limit

Hello, I'm in need of a script to circumvent the 100 found records limit.Here is my use case:I have a database of 2k records updated on a weekly basis.The user can setup and save complex filters (what I call alerts) to get a weekly email with new records.My automation searches in the [aides] table for records matching the criterias for the [alerte] record.It then links the relevant [aides] records to the [alerte]My issue is that it can only find 100, and I don't know how to do a script to replace the find records step.Thank you very much for your help.Cheers,Joachim

504
Karlstens
P
PolenKnown Participant
posted in Automations
List of records block in automations

It is nice to be back to this community after a long absence!I am creating an automation that triggers when a form is submitted.  This form has a link field where the user selects to link a number of records.  I use a Find Records action to pull information from those linked records.  I then use a List of Records element to add linked records info in the body of an email action that is sent to the user.I am not very hopeful but maybe the community has some ideas:  Is it possible to format the output of List of Records at all?  I would like to replace long urls from url fields like when using markdown [link](url) but it doesn't seem possible, or at least guarantee the url is added to the email as a hyperlink and not text.  I wish I could also edit things like padding of labels and values,  labels in same line as values, displaying single select values without the bubble, add a border around individual records, things like that.  Try

131
Karlstens

Badge winners

Show all badges
Terms & Conditions