Automations

Hello! Trying to get an automation going where if the text output of a field (i.e Prop1Text) from a formula field (Prop1) that is parsing the input (Property) matches the text in a different view, the “status” field is updated to my desired option. I had an issue with my first test because when the request for multiple properties came in, the “prop” field had all of them in a single string and that failed the previous automation find record if “Property” in master list is “Prop” Text then update. Currently i am getting the “invalid filter on Property field” error when I try to do a find record action I had read that formula fields cause issues during lookup automation (not sure entirely) so I had it copy the text from the formula field “Prop1” into a single line field “Prop1Text” by another automation. That is working perfectly fine, but i am stuck at trying to get the matching record ID to update that status of that specific record

Hi! I saw an article that discuss my problem, but didn’t have the solution. I’m trying to create an automatization that runs a script to copy a field (formula that puts year and month together like this 2021-12) to a liked to field whenever a record is created ou updated. So I found here this solution that requires you to put the field you want to copy as a primary field let dateT = base.getTable('Dates'); let dateQ = await dateT.selectRecordsAsync(); for (let rec of dateQ.records) { let dateFieldID = rec.id await dateT.updateRecordAsync(rec, { 'Date Link': [{id: dateFieldID}] }) } But I can’t make this because I use my primary field to make a resume for my Calendar view title record. Here is a simple example how my table looks like Does anyone solve this or could help me ? (sorry if my English is not so clear. I’m an Brazilian who is trying his best here)

So I created a base, with a bunch of tables. The first Table is sort of a summary table of the other tables. My use case: Let’s say I change the status of the item in my General Manager Table from Define to Communicate: I want to update the corresponding field in the Status column to the same value: These selections are drop down selections. So I setup an automation that when a record is created in General Manager table, that it will update the corresponding object (sorry, I’m none-technical, and don’t know the proper terminology) in the Status table: The automation keeps failing, and I’m not sure whey. Any help would be super appreciated! Thank you.

Hello, I have a table where every record has a time field. I would like to check a checkbox when the time is today at the specified time. Using automations I managed to check the box when the date is today but the time is not considered. Is it possible to check the box at the exact time? For example, I have a record that says 12/11/2021 1:00pm. The checkbox should be checked only after 1pm and not at any time of the day. Thanks

I’m having issues with an automation. There are two collaborators. Their client’s submit forms every week. They would like to get an email when the forms are submitted. They only want to get notified of the forms they are assigned to as a collaborator. This is where I’m running into problems. What I’ve tried: I’ve tried setting up one automation that’s triggered when a form is submitted and inserting data from the previous action to get the email from the collaborator in the “to” field. It doesn’t pull their email. I get an error saying “the to field is empty”. Then I tried creating a different automation for each collaborator that would trigger when a form is submitted. I used the “find record” action and added a condition to filter the collaborator. This time I typed out the email in the to field. However, when I submitted two different forms assigned to two different collaborators, the automation for Collaborator A ran and sent an email for a form that had already been submit

Hello! I have two tables: “Projects” and “Tasks”. I’m wanting to create an automation to do the following: Trigger: When a record is created in “Projects” table Action: Create value {Record Name} in X field in “Tasks” table Basically, the name of the record in the project table should update a field in the Tasks table. I would like the automation to create a new field value within a dropdown field and the value name should be taken from the trigger record name (i.e. the project name). From what I could see, the only way to achieve this is to have the action be to update a field within an existing record, so I created a dummy record. This is what I’ve created: When I run the test, it shows the field in the dummy record is updated with the project name as expected. But when I go and create a new project record, the automation shows as running successfully, but the field in the dummy record is empty. Am I overcomplicating this/approaching this wrong? Appreciate any help!

Hello to all, I have a table with products and their price, and I want to indicate automatically a price range using the symbol “$”; “$$” or “$$$”. I am trying to run an automation to update the record “Price Range” record when the condition “Price ($US/m) < 5$”, meaning I want to display “$” in the field Price range when the price is under $5. So here is what I did but when I launch the test only one record is found and so it only updates one record. However when I apply a filter on my view (price under $5) I clearly see that 10 records match the condition. I tried adding the action “Find a record” where the condition is prince under $5 and it does find it, but then I don’t find the way to update the records. Could you help me solve this problem? Thank you, Chloé

Hi guys! I’m trying to set up an automation where I could send an email to a requestor once the project matched certain conditions. For a requestor field, we’re using a collaborator option, and now whenever I’m trying to send an email to a collaborator I’m getting a message of “invalid email address” . Is that something airtable is working currently on? Or is there an alternative way to generate an email address for a collaborator? The Formula for instance etc. Thanks!

Hi all, I have base a certain table with fields “Production method” and “number” as per attachment. (The numbers are imported testdata) The goal/ each production type should get an (auto) number. each production should get the highest number available +1in the field from a certain range. eg. "production-type 1 should get the highest number + 1 available from field "Number. The highest number available must lie in range 30000 to 40000 eg. "production-type 2 should get the highest number + 1 available from field "Number. The highest number available must lie in range 20000 to 30000 When a production method changes value, a new number must be calculated in another specific range. Business wise this should not occur, but might be needed to catch user mistakes I was planning on doing this via Automations. “When record is updated” Or “When a record matches conditions” → “Run script” But I have not much coding experience. Very, very basic. Can this be done via script? Can I get some pointe

I have a script that makes a request to a GIS API and fetches the response. When the script is in an app, it works at expected. As an automation, it does not work. The fetch returns a response with 403 status. This is strange because this means access is forbidden, however it was not forbidden when this script was an app. Here is what I have in the automation script: const geocode_data = { "SingleLine": addressText, "f": "json", "outSR": {"wkid":102100,"latestWkid":3857}, "outFields":"*", "distance": 50000, "location" : {"x": -8396932.14535, "y": 4854564.864250004, "spatialReference":{"wkid":102100}}, "maxLocations": 2}; const geocode_req = new Request( "https://geocode.arcgis.com/arcgis/rest/services/World/GeocodeServer/findAddressCandidate

Hello - I would like to add contacts from my Gmail into Airtable in real time as my emails come in. Does anyone know how I can set this up? I’d like the same kind of feature as the web clipper, but for email profiles/addresses. Thank you!

Hello everyone, I’m very new to Airtable and also a non-coder. I’m trying to launch a script as an automation’s action, which is pretty straightforward. However, the script I’m trying to launch needs settings to be populated before each launch, ask for a confirmation before launch and therefore the script needs to be run manually. However, those settings are now fixed in my base so i would amend the script code directly to reflect those. I don’t know how to proceed. This script is part of this function : https://www.airtable.com/universe/expK9hEwh5d1IGkH3/splitting-multiple-selectlinks-into-individual-records Here is the code : let settings = input.config({ title: "Create junction table (keep multiselect)", description: `Running this script will populate a junction table that contains every possible combination of linked records from two tables. Both tables must contain a linked field to the junction table being populated.`, items: [ input.config.table("table1", {

Hey Airtable Friends! I have a problem I can’t solve, but I feel like it has to be doable. I would love some help! Situation: We’re a mortgage company and we keep a database of our Loan Officers and what states they’re licensed in. Those licenses need to be kept up by the employee, so they come and go very often. Each state their own license syntax, so in Airtable, we have 50 text fields, for the 50 states and when a license gets added or removed, someone goes in and types in the license number for the Loan Officer in the corresponding state field, or deletes it from the state field (if it’s removed). Problem: We very often need to see who all we currently have licensed in X state. But it’s very annoying to sideways scroll through 50 fields - So, how we currently do it is someone adds or removes a license, then they scroll over to a multiple select field and add the state from a drop down. That way we can go to ‘John Smith’ and see that he’s licensed in states, X,Y and Z. What I can’t

We’re trying to create an automation in Airtable that sends an email from Gmail. Is there a way to hyperlink text with a URL that’s generated by a formula field? Basically each email that sends out will contain a unique URL that’s hyperlinked.

Can I embed the grid link in an html email to show the grid? What I’m looking for is an iframe or something similar that works with most email clients. background: I’m currently sending emails including a grid via the Airtable automation. I was asked if I could improve the design - e.g. include a logo. I’m doing this by sending the email via Zapier and outlook in html instead, but I can’t get the grid to show in the email.

I could have SWORN this was working before the new automations system overhaul a couple of months ago… So I have a little CRM set up. Three entities are involved here. Farms, Interactions, Tasks. Interaction - An interaction has a link to a farm (all interactions have a farm). This is the trigger of the automation. When a certain field of an Interaction is updated, the automation triggers. I want this automation to create a new record in the Tasks table, and use one of the fields from the Interaction’s linked farm to do this. So at the automation’s screen, I issue a: Create Record (task) Set the assignee of the Task to the “User” field of the farm, and to do this, in the automation screen: Click + next to assignee (one of the fields of the task record) Choose “record from step 1” (the interaction) Choose Farm, Continue… And this is where things fall apart. Instead of seeing all the fields in the linked farms table, I don’t see any! I have recorded this quick vid: https://vimeo.co

As of now, automation triggers are limited to one table. Is it possible we could have multiple table sources, doing the same automation, and the outputs are in one or multiple tables as well? For example: generating an assistant ID We have different sources of assistants per table. And we have a table that is a masterlist of all the assistant IDs. Instead of having to automate separately for different tables doing the same thing, is there a way that multiple tables can be chosen (or specific views per table) and theyd all flow into the masterlist table that we have? Thanks!

I have a column with single select option. Based on the option selected in Single select, I need a particular formula to be used to make calculations in the next column. There are around 10 options in the single select and 10 formulae corresponding to each option. Is there a way in Airtable (using Integromat) to achieve this?

I am trying to create an automation that would add a collaborator when adding a record to the airtable. So each record has a Program Specialist, that is part of a list linked to another table. I want a field where that same program specialist name is also linked to a collaborator for this row. Can automation help this become well automatic? Drew

I want to create an automation that emails a report to the managers on their employee’s individual progress at completing their monthly certifications. In my table, I have the names of the clients, the due dates, a drop-down for marking complete, the name of the employee, and the manager linked as a collaborator. One issue I keep running into is that the automation for sending an email to the manager doesn’t work. Even though I set the value to email. However, the next steps is to make a report that would show all the names of the clients and the individual status of their certifications. This way managers will see the progress of their employees.

I have a view that contains records filtered just by the coming week. Is there a way, maybe with scripting, to automatically advance the dates in the filter by 7 days, so each week the filter automatically updates with the current week’s records? Thank you!

I would like to be able to post to LinkedIn from Airtable using the automations but only when the record is ‘ready to post’ and at a specific date and time that it has been scheduled. Can anyone provide some guidance in the best possible way to do this?

After inadvertently triggering an automation several times recently, I started thinking - it would be great to have a confirmation dialog option where a dialog box could pop up with “Are you sure you want to…?” first, before the automation actually happens (in my case, sending out an email). Alternatively (or in addition to), it would be great to have an option to limit triggering the automation to only once per record, even if the conditions in the record change. Would anyone else use these features?

Hello Airtable community. I am trying to automatically create a revenue forecast in airtable but have gotten a little stuck. The use case is as follows… I create a single record for a project containing overall project value, start date, and end date. I then use a formula field to calculate the number of working days between the start and end dates. All good so far. Now, I want to automatically calculate what the average revenue(value) for that project will be during its lifetime. e.g. if the project is 12 months in duration, with a value of $120,000, I would like to be able to report $10,000 of revenue for each of those specific months. Using a relational database and some code, I would quite easily do this by creating 12 records (one for each month) with a unique key of date and project, with a value field of $10,000. My question is, is it possible to programatically do this with Airtable or, ideally, is there a slicker Airtable way of doing this?

Hello everyone! We have an issue with the Twilio app we added to a dashboard. Sending SMS directly from the base works really fine and that is great!!! However, when we use the alphanumeric sender which is well configured in Twilio, the receivers see “null” as sender. We have entered the alphanumeric sender in the field "Twilio phone number”. The SMS do go out, but the receivers see that they come from “null”. We have tested the alphanumeric sender in Twilio and it works. Is someone here familiar with that issue? Thanks for any response!