Automations

I feel like this has got to be a simple fix but I cannot for the life of me figure out how to make this work after looking through countless other topics on similar issues people have had. I have a Daily Fieldwork form that gets filled out when an employee does a task (there are several tasks to choose from). When that task is a “new install”, an automation creates a new record into another table (Table 2) that keeps track of all of our equipment ID numbers. That automation works great, it copies all of the fields into the new table without issue. I’m now trying to create a new automation to update specific records in Table 2 when another task (not new install) is selected in the Daily Fieldwork form or when a record is updated in the Daily Fieldwork Table where the form data gets inputted. It doesn’t matter to me which way to create the automation, I haven’t gotten it to work either way. Here’s a look at how I’ve been attempting to create this: I keep getting the error that either t

I’m having an issue when I try and tag an individual with their Slack ID in an automation I’m making. When I test the Slack message, it’s sending back the Slack ID number rather than their Slack name. I’ve attached a few screenshots of what is happening in both the testing area and in Slack itself. It’s obviously getting the information, but I’m not sure what I’m doing wrong that I can’t get it to list the person’s slack handle. Thanks for any help!

Hello, I’m trying to create an email automation, but I can’t seem to get users’ emails to generate in the “To” field. The email is able to populate emails from the users listed from the “Producer” field in the CC field as seen in the screenshots below. But, users’ email from the “TEST” field do not populate and I cannot seem to figure out why. Any recommendations would be greatly appreciated!

Hi, in my workplace we have 2 different bases. One of them is ‘duties’ and another one is ‘records’. We want to create record to the duties base if some conditions are met in records base. How can I achieve that I can not share pics because they are confidentials. Thank you

Aha! So I’m making some progress. I think I’m one step off making something work in Airtable. So I have two tables: AcademyEventsList and AcademyTriggerEvent. In the AcademyEventsList table is a list of all my online classes with students. The fields are: UserID (an automated number), Event Date (a date and time), Event Name (text field), DaysToGo (a formula that calculates how long between the event date and now), Hours To Go (same but hours) In the AcademyTriggerEvent table is just one record. Here are the fields: TriggerID which is just a number, TriggerEventDate (date and time), TriggerEventName (text). My automation intention is that: When DaysToGo= 5 ->the record in AcademyTriggerEvents is updated with the EventName and EventDate from the record in AcademyEvents that has 5 days to go. I’m almost there but I’m stuck on what the Record ID should be. I’m getting the error message “The record does not exist” when I test it. I can see that the Fields are bringing in the right infor

Hi, I am currently using CSV import to fill out a table1. In this table1, a groups of records will have duplicate field values(Item#). Then in Table2 I have a single record for each group of matching Item#'s that are all linked. My automation wont trigger until at least 3 of the fields are filled(in case of manual entry) on Table1. Then it looks to see if Item# exists on Table2. If not, it creates a record. If so, it fills out the linked record field in Table1 to link it to the existing record in table 2. If I input the records to Table1 one at a time it works without an issue. When I use CSV import or do a bunch at once, it doesn’t register that there is a record in Table2 and creates a bunch of duplicates in Table2. I can look to see that it creates a record and that its still in progress for another record but still creates a duplicate anyways. I can provide more screenshots or info if it helps!

Hi, I am trying to set up automations so that when a record is created in my Airtable content calendar, an event is automatically created in my Outlook calendar. I also want an automation that updates the Outlook calendar event when the record is updated in Airtable. I’ve tried setting up these automations but they weren’t successful. Please help! Thanks!

Hi, I want to create an automation to update a long text field with rich text formatting enabled, with the following text: This item will already be marked complete This item will be not be marked complete Another checklist item Yet another item When I copy/paste the text in my automation, line breaks disappear and I can’t add them: Thank you for your help.

Hi - Can you send a Grid view in Email automation? Such as a table based on the requested fields?

Hello! Trying to run a script to extract an Array into multiple fields for each submission. For example, we have a form where a user can select from multiple options which inputs the results (Array) into one field. Using automation would like to extract that Array and place it into another table. See below: New to this, what am I missing: // Create three records in the Merchant Selection table console.log(`The value of "SelectedNonprofit" is ${inputConfig.["SelectedNonprofit"]}`); console.log(`The value of "MerchandName" is ${inputConfig["MerchandName"]}`); let table = base.getTable("Merchant Selection"); let rawInputs = input.config(); let inputArray = []; rawInputs['SelectedNonprofit'].forEach( (SelectedNonprofit) => { inputArray.push({ fields: { "MerchantName": rawInputs['MerchandName'][0], "SelectedNonprofit": rawInputs['SelectedNonprofit'][0], } }); }); let recordIds = await table.createRecordsAsync(inputArray); console.log("Created " + inputArray.len

So maybe I’ve been working too long today but I just can quite seem to figure out setting up these automations. I have a list of properties that I am going down the list and clicking a checkbox, which I want to create the contact by copying the info over to the Contacts table. If the record doesn’t exist, it should create. If it exists, it should update. One problem is the automation is creating multiple Donald records on multiple check boxes. The spreadsheet has many duplicates so I want to not have to worry about them. (Side note: I guess it should be setup where if the Full Name has different company, a new contact should be created (since I don’t know which company the contact belongs to currently) Another thing, not super important, is for every new contact, I want to relate its company to the Companies table. If exists, nothing should be done I guess and if doesn’t exists, it should create the new Company record and relate. Anyone mind helping? I believe I’m confused over the Fin

Can I make Airtable do this: If there is a record for a person in my Contacts table, can I ask AirTable to automatically save a copy of any email I send to that person? Likewise, can I ask AirTable to automatically save any email that comes in from that person through gmail?

Hey all, I have a database set up and I am hoping to create a monthly automated email that sends to the listed collaborators each record. I am able to set up the monthly trigger and can find the records I want sent, however, I can’t seem to configure the “To:” box to send to the listed collaborator. Can anyone help with how to set this up? Thanks so much, Jacqui

Hello! I’d greatly appreciate your help on the following automation/script. I have updated a record’s status from “Available” to “Booked”. Now I want to update all records status to “Booked” for records that belong to the same bundle in the same calendar week (which is a linked field to my table) Here my example: If I change the status of any record, all other records - which have the same Option & CW value (column 3) should also change their status to “Booked”

I am trying to create a custom quoting system and because all of the items I sell are custom and have varying prices, I have come up with a way to create the quotes using 2 tables. But I want to know if there is away to automatically add several records from one table into a single record on another table via the linked field. I start by creating several records on the “Quoting” Table, and they are grouped by the “Deal”. Once all of the items are listed, I click “Create Quote” on the first record and it creates a quote in another Table called “Quotes”. Because they are linked, it copies over the “Deal” and that one record that I ticked the box on. But I want to add all of the records from the “Quoting” Table that are grouped under the same “Deal”. I tried creating an automation to find records and update, but couldn’t figure out how to make it work. Any ideas?

Hello the community, I am a little bit lost today with something I don’t understand. At this point I don’t know if it is me or an unreleased feature of Airtable… In AUTOMATION, I want a specific item in Table 1 to be changed when something is modified in Table 2. I have the item ID of Table 1 thanks to a LINKTO field in Table 2. But… I can’t use the value in LINKTO field and same if I use a LOOKUP field : the values are grayed. Is it normal ? Did I miss something obvious ? Thanks everybody :winking_face:

I wish to automate the changing of a record status on a particular date. I know this should be simple, but I’m missing something. For example, I have vacancy records, each of which show a status (eg OPEN, CLOSED). On a set date I want the status to change, from OPEN to CLOSED. Kindly assist me with the steps to be included. Thanks.

Hi experts, I have a table (let’s call it Table 2), with multiple records, each record represents a company ie. Apple, Google, Microsoft and each record has multiple fields with associated company information. These records are copied from another table (let’s call it Table 1) [which is a synced table]. I have setup an automation where: If a record is updated on Table 1, the corresponding record is found on Table 2 and is overwritten with information from the updated record. So, if company information on (say) Apple changes on Table 1, Apple is found on Table 2 and updated. This automation works fine - it’s a “When record is updated on Table, find record (using Record ID) & update record on Table 2” Annoyingly, it breaks whenever there is more than one Apple on Table 2 (we have several instances of the same company listed - but with different tags attached) Is it possible to setup a script that will find and update each record, one after another … so if there’s 3 records with Apple

Hi there, I want an automation to email multiple (3) email addresses (entered manually as text) when a certain thing happens (a tickbox is checked on an entry). I separated the emails by commas, but it seems to only send to the first email address. I’ve tried separating with commas and spacebars, and also semi colons. Any suggestions? Thanks!

Hi! I’m trying to transition most of my workload from using AT and Asana to strictly using AT. One feature that I like about Asana is that every few tasks that get completed, they have a small popup appear on the screen in celebration. It’s a completely irrelevant thing and has no bearing on workflow, but it does make you feel good to see it. LOL I’m wondering if there is some type of script I could use to make something like this pop up when certain fields are updated in Airtable? I’d love to keep that ‘happy’ if possible? Again, it has nothing to do with the workflow… I just wondered if anyone knew if it was possible? Thanks!

I have created an automation to add in a specific google calendar an event when the date and time is indicated in a specific field called “Follow-up Meeting” in my airtable database. It works. Now, I would like to update the event in google calendar if the date and time in the field “Follow-up meeting” in airtable is updated. I have created a trigger but I have a problem as I cannot inform the “Event ID”. What should I do?

I’ve setup an email automation where I have a list of employees that need to have certification that requires updating. I’ve listed the certification required and the expiry date of the certification. I have started the automation with: TRIGGER - At a scheduled time ACTION - Find records (Name, Last Name, Certification Name, Expiry Date) Find records based on a CONDITION CONDITIONS Where (Name of Certification) is one month from now ACTION - Email PROBLEM In the body of the email I want to insert ONLY the expired records that are found (in the first action, find records) in a grid list view , however it is inserting the ENTIRE grid of records which are mostly blank because the certification is not expired. How do I insert only the records that are found to be expired??

Objective: create employee resume pages (via Documint) for project proposals. These resume pages have employee info and list previous pertinent project experience. The resume page for John Doe for the ABC Hospital project will have different project experience listed than the John Doe resume page for XYZ Stadium. Our base has these tables: PROJECTS PEOPLE PROJECT TICKETS (join table between PEOPLE and PROJECTS) PROPOSALS PROPOSAL PAGES (Each PROPOSAL PAGE is linked to one PEOPLE record, one PROPOSAL record, and multiple RESUME TICKETS records.) RESUME TICKETS (join table between PROPOSAL PAGES and PROJECTS) Currently I have interfaces that: Create a PROPOSAL record. Create PROPOSAL PAGES records linked to the PROPOSAL record and PEOPLE record. (this is the resume page to print/.pdf) Show me a grid view of all of the PROJECT TICKETS for the individual whose resume PROPOSAL PAGE I am creating. I can filter this grid view to only include the projects I want to list on the resume page. T

Hey there, I have a table on Airtable that has multiple forms inside it. We send each of these forms at each step of a custom onboarding journey. Some of the fields in these forms are the same, so I would like to know if there is a way to prefill data in forms for users who submitted a form previously in the same table. Thanks :slightly_smiling_face:

Hello Right now Im on airtable pro trial plan and Im trying to use automation script but it tells me that its not available for my current billing plan. I was wondering whats the point of pro trial if I cant access its features? Then I tried to upgrade my plan to plus and Im only able to select yearly plan for billing and I cant choose monthly. As you see the image Im upgraded to plus but still not able to use this script feature. Thanks for reading