Automations

I am working on a massive base that has multiple columns and tables. I want to create a form that allows users to fill in information that will: Pick Main Record to Update Select an item from a list This is tricky part - once the form is submitted it will look at the Main Record selected to update and I need it to update the first blank defined column in that record. i.e. First Form Submission - Order 1 Column in Main Record = selected Item from list Second Form Submission - Order 2 Column in Main Record = selected item from list The caveat is that the form will be submitted by a few people at random times. The only important thing is that as the forms come in it updates the next Order # column in the main record.

Hi. I’m a non-developer. I have a table that has two multi-select fields. I want Airtable to find records that are tagged A, B, C or D in the first column, and automatically select the WINTER tag in the second field (WINTER is one out of 5 choices in that multi-select field). Can anyone help me with this? I can “Find records,” but I’m lost after that.

Hi! I see that this is possible, but I don’t really understand how to do it. We have two tables: State level information. Local information. Hopefully most of the overlapping information will be entered at the state level, and when someone enters information on the local table, an automation will push it there based on a single select field- if the value is one of the statewide options, many fields will populate. However, sometimes folks working on the local table will collect statewide information. When they select one of those statewide options, I need to set up the automation to work the other way: push info to the state level table if the record is blank. The additional twist here is that there may be 5 local records for one state record (ex: there is only one Delaware record, but it is linked to 5 records in the local table), so I also need to make sure only the proper information populates in those empty fields. Thank you!

Hi, I am looking for an automation that would automatically staff a member (update record) in the PM field PM Field: PMa / PMb / PMc Project Phase Field: A / B Rule: Each PM can not have more than 4 projects in phase A Each PM can not have more than 8 projects in phase B PM with the least amount of total projects in phase A+B get staffed, PM with the least amount of projects in phase A get staffed, if all matches, randomly staff one PM. if all PMs are overloaded, staff the one with the least amount of project in phase A+B Would love to have help with the script for the custom rule above. Appreciate all the help and thanks in advance!!

I create a new field in a table with no other linked fields It is a linked field to another table in the same base Airtable allows me to do that Then I select some lookup fields from this new linked table So far so good, just like the other ones ive done but Both of these columns keep populating empty I repeat these steps w same trouble :confused: I actually tried creating a new field to be the linked record in each table from a=>B and B=>a always empty then an existing single line text field in both directions [not the primary field] uff!

Hi there, I’m new to automatisation and coding, I checked online what was the difference between let and var and I wanted to know if there was a preference on using either one. Thanks

Hello, I am trying to figure out how to run the Field Tweaker scripting app whenever a record is created on a particular table. I have the app working successfully manually but I have not been able to figure it out thus far as part of an automation. I am assuming the code has to be changed slightly to reflect which field I want to tweak and what case but I am not sure if there is anything else I am going to need to do. Any help or pointers would be greatly appreciated!

Hello, Is it possible to automate this? Export csv from Airtable view Send exported csv to Slack channel once a month

Hello I have a table that tracks all outreach to our contacts with the final field of each record being a checkbox column that will be marked if the contact agrees to an appointment. The goal is to copy a record and all its fields to a new table (appointments) when checkbox column in the original contacts sheet is marked. Additionally, I would like to add a timestamp in the new table to stamp when the record transfers over to the new table… I.e. a timestamp of the date we confirmed the contact agreed to an appointment. I understand I can use the same table and different views however we already are working with APIs on the appointments tab for external automations, so I would prefer not to mess with it.

Hello, Airtable—I would like to request the following simple features for the automations section: A user should be able to name to scripts added as actions in automations, so that when users are looking at the overview in the “Steps” tab, they can easily see what each script is doing, without having to open up the code and read the code to figure it out. A user should be able to re-order actions in the automations screen. A user should be able to change the trigger to a different type after initial creation, not just update the previously selected trigger’s details. Currently a user has to create a completely new trigger, copy the contents and settings of the original trigger and each of its action steps, and then delete the original, all to just change the type.

I have table A with 5 fields and table B with 5 fields each corresponding to those in table A. Table B are checkboxes. If a field is filled in table A then I want to checkbox the corresponding field in table B. I want to use automation and formula. Please suggest how to do this. thx

Anyone else having issues with this lately. I have emails in to support, but thought I would check to see if there is a general system problem. Thanks, Tom Embaugh

I’d love it if I could add a delay as an action step, similar to how you can do it in Zapier. Currently, I want to be able to trigger an automation when a formula field calculates to a specific value (a value that figures out if a combo of other values is a valid combo). However, when someone is editing the record, this formula field jumps back and forth between a “valid” and “invalid” state while they’re still editing. This triggers the automation saying the formula field is marking the record as “invalid” even though the person editing the field isn’t done editing yet. Ideas for implementation: A delay step that can wait n minutes after a trigger has occured before any further action steps are taken. In an ideal world, there might even be an easy way to check the record that triggered the automation to see if it’s still meeting the triggering criteria. (Like a Zapier “filter” step) A delay that waits n minutes after a record was last modified to then trigger the automation if the re

Hello! With an automation, we’d like to effectively display a changelog in slack for when specific, high-value fields are changed. I have an automation using the “When a record is updated” trigger that monitors those fields working great, but what we’d like is to know specifically what field(s) were updated and what the changes were (what the field’s value was previously and what it is now). Is there anyway to retrieve that information in the automation or a script?

email is sent to acknowledge receiot Hi there, Is there away to send and recieve threaded emails? we want to introduce a ticketing system ie request comes in via a form email is sent to client to acknowledge receipt all further comms are updated within AT automatically so anyone can see the notes on the job at any given time

We are looking to hire an Airtable expert. We are looking for a way to create dynamic pages using only Airtable variables for all content on the page, using Duda website builder.

Hi all, I’ve been reading a lot of he help articles, but, still can’t quite figure out how to do this… We would like to trigger a button to open a URL on a recurring schedule. My understanding is that we would need to trigger a script to do this or set an action to the same effect? I’m not experienced enough to write the script but I can’t think around how we could get there with a set of actions. This is my first post here so any help from the resident experts would be appreciated.

I think we need to revisit this: https://community.airtable.com/t/combining-text-column-url-column-to-create-text-with-hyperlink-inline/33068 I’m looking to automatically combine two columns (URL + Text) to get hyperlinked text. This appears to have been the answer until part of the script was deprecated. I’m finding discussion elsewhere about replacement for that command, but am not able (no expertise) to figure out how to combine everything into a script that works.

Hello guys, rookie there with a little issue… Currentlly I’m signing new customer using minExtension that is directly connected to my ‘Customer’ base. I have another base ‘Planning’ with a table ‘Time of coaching’ that displays for each teachers the time they spent coaching the customers. Is there a way to display the occupancy rate when I’m signing new customer ? I was thinking about showing the occupancy rate of each teacher on minExtension but I don’t think it’s possible (ex. on screenshot). Thanks for the help

Hi Guys, I am evaluating AirTable for our warehouse inventory tracking and i am enjoying it. I was wondering if someone can help me in answering the following Scenario: I have items that belong to the same Purchase order for a specific Job, and typically all items on that order would come from the same supplier. So my items would have a POnum Field and a SupplierName Field. And based on the above, all items with the same POnum should have the Same SupplierName. So is there a way to limit the drop down of the supplier filed so it only shows that same SupplierName from a previous item with the POnum, OR set the value directly for the SupplierName instead of limiting the dropdown? I hope this clear.

On the date 25 Jan 2022,I’ve got some new errors with Automation which is never happening before.I can understand that execution time is more than 30 seconds but the error looks new as compared to older error messages.Error looks like this.Does anyone has the same error during automation?

Hey Guys, I am building a directory of engineering teams https://teamfinder.dev/ where each team has their profile and projects. Each project is also a separate page. All done using webflow. Airtable is my backend. I would like to build a connect airtable form that will prefill website url or slug on each project or profile. Example project with webflow form: teamfinder.dev LBI Financial Case Study Superfast Jamstack Website For Insurance Business. So in other words i would like to have a form that will catch URL of it’s page. The goal here is to match a lead that would like to contact selected team. Is that possible?

Hi all I’m struggling to find this as another topic so apologies if it’s already been covered. We’re trying to set up a system for students to submit work anonymously and then allocate that work to a tutor for marking. What I’d then like to do is allow an email to go to the specific tutor with the new work to mark once allocated. I’ve set something up using views for each tutor and then automation for each tutor to be emailed when a record enters their view. However, this seems pretty inelegant and uses 12 separate automations. Does anyone know a way to integrate this into just one automation?

A screenshot is attached, and the issue is pretty clear: The conditional action group should be selected if a field is empty, they’ve been passed an empty field, and yet they fail to be selected. I have verified that there are no spaces or other invisible characters in the original record that is being tested. Separately (2nd screenshot), there appears to be no way to “Replace select values from previous steps” with empty values. When I enter BLANK(), the string value “BLANK()” appears to be tested. When I type something and then clear the field, the original value is tested instead of any substitute. The fundamental issue I’m trying to solve is automations failing when empty values are passed to a “find” action. I’d hoped using conditional groups could prevent passing such empty values to “Find” actions. I’m also trying to implement backup “Find” actions using other properties in the event the first search fails. The eventual outcome should be sending an email with a “score report”

Hi There! I am using the new Conditional Actions in Automations. I have created an automation for our course registration base form that will send an email with all of the data the guidance counselors will need to register students. I created the automation to occur when a new registration form is submitted. I then am creating conditions that state when guidance counselor X is chosen and email goes to them. I have to do this for 113 district guidance counselors. Is there any way to copy the email properties (the data that is being pulled) so that I do not have to create 101 more duplicates (Yes, I did 12 before saying this is crazy!). If I am going at this ALL wrong, any guidance you can provide will be greatly appreciated! Thanks!