Automations

I have a table with a list of Products, with various details about the them.I have a linked table with the products' prices.The reasoning behind the decision to separate the two is that the prices change from time to time, and for different sales channels, the prices vary.I'd like to set an automated email that is fired when a new product price record is created.The email should include a grid table that shows:The records of the current and previous prices of the relevant product.I'd like to pull not only all the prices of the same product, but to also include some conditions.For example: all the filtered records should be the prices in the same country (e.g. Germany, or the United States).Please recommend the best practice to configure this requirement.

I have the following script to create records in a table. Event Name is a Single Select field. But I get an error "Error: Field "...." cannot accept the provided value." await passTable.createRecordAsync({ "Event Name": event, "Event Date/Time": date, "Notes": notes, }); }  I tried:  "Event Name": [{name: event.toString()}] and "Event Name": [{name: event)}]  but neither of them work. Any suggestions? 

Hi! I am trying to take my formula field (that is super long because it is a prefilled form) and make it into a hyperlink in automated emails. I have tried using the [words](formula), but it does not seem to be working. Any help would be appreciated, Thanks!

I've got an automation that creates new records based on content in the triggered record, but the linked info disappears after about 5 seconds and I see the attached screenshot.A more concrete example - I've got a project record that I can add defined tasks to from a task template table. I made a button to generate new task instances for those linked tasks in that project. Those task instances have a link back to the task template record.Initially everything works as expected, and I go to my tasks instance view and I see the new task instances that are linked back to the task template. But, after 5 seconds they disappear and I see the attached screenshot for the linked task template fields. 

Ok, here's the workflow I'm trying to create:User 1 creates a new ticket by completing a form. (Easy)Automation generates an email to User 2, notifying them of the new ticket, including a few details and a link that opens the record in another form, which includes the details from the original ticket submitted and the ability to update the status and other fields as needed, then submitting the form to update the ticket. (???)User 1 gets an automated email, notifying them of the updated ticket. (Also easy)Is it possible to generate url that will open the record in a form to be updated and submitted? If not, could I instead generate a link that opens the record in an interface that I design for that purpose? I'm trying to minimize the opportunity for either user to get confused by other records or the Airtable interface, since neither of them will be Airtable users.Any creative ideas?Thank you!!!

Hi,I would like to trigger an automation with a button in a list interface. That's not possible, but how then to handle the following?The listing groups all records (projects) into several buckets. The user can choose which bucket to list with a dropdown filter element. After finding the right selection, I'd like for the user to trigger an automation for that selection. The automation will (loop and) send out an e-mail to and update some fields for all the listed projects.Is there some clever workaround that could be used?Rgds,Björn

I posted in the ideas about my desire to have Page Designer integrated with the Interface Designer. I would like the employees at my company to be able to work within the Interface and generate letters for our clients through PDFs that are exported to the desktop.I know there are so many third party solutions to document generation, but I was wondering if it is possible to create a script that would be activated by a button in the interface to generate a letter that will save to the users desktop using one of the third party solutions.A click to download letter button.   

Hello!I am trying to create a way to track our recruitment conversion rates (for a large program where participants apply to be part of). I know it should be possible, but not sure how to configure it all. Here are the key elements:We have an existing airtable base where all prospective program participants apply via a form. A required field as part of the application form is "how did you hear about our program." There is a drop down list of options they can select from.Once an application comes into the view, we review and have new fields that we complete, such as: application ranking (single select), checkbox to offer interview, application status (interview offered, contract signed etc).I want to then be able to understand from each source (eg. newsletter, job fair, referral etc.), which applicants went on the following:Number of applicantsNumber of interviewsNumber of offersNumber completed placements The goal is that this will help us better understand what source we sho

Hoping someone smarter than me can helpI am looking to update a dropdown menu (to show a quote is accepted) on Airtable when a user approves a quote on our quoting software (Quotient)I am using a quoting software called Quotient, works with Zapier, I am successfully done the 'trigger > find record > but I cannot find how to update a dropdown.The record is found based on the same unique text in Quotient which marries up to the unique customer reference in Airtable.I've added some screenshots which may help to understand

I've created a button that links to a script. The script duplicates the line where the button sits and duplicates linked records housed in another table. However, the script crashes seven out of ten times. Is there any way to mitigate this? Is it my internet connection? I'm tearing my hair out as it's almost quicker to manually go around all tables and duplicate records and wire them back up by hand 😧

Hello,I am building a project management tool and want to send daily messages to the users on late tasks, upcoming etc...to do so, I have created my automation as follow: The idea is to run automation everyday, look for all users from a table 'participants', and for each one of them search for late tasks assigned to them. Generate an email and send it to each recipient. (I don't want to generate 1 email per late task.... too many messages)This works great as is, except that if there is nothing late in the queue for a user, he will still get an email with an empty table...anybody has a solution to add a condition on this automation?thanks!

I have a table of worklist items that are assigned to users. I want to create an automation that once triggered will execute the "find records" and would go through the distinct list of users that have open tasks.  Open tasks I can do with a filter, but how do I work it out such that if Joe has 3 tasks, the action only executes once for Joe?I tried the group but it didn't seem to do the trick (unless I'm doing it incorrectly). I could just do it all in a script, but I'd rather use the no-code tools to drive the automation. Thanks.

Hi! So, I tried an automation to send an email to some designated people from a list on Table 2 when a record enters a view on Table 1. The users are coming from a linked record from T1 to T2, but when I configured the automation, the system apparently didn't read the emails are emails so, so it failed to send anything. Am I missing something on how to do it?  Background: All of the users are Airtable users but they don't have access to the email accounts linked to those emails.

Hi everyone.I am looking for a solution where I have an interface created and I want to automate the process of sending the interface data via Automation or Scripting. I have tried the scripting route, but it asks for installation of node.js libraries. I am not an expert at programming and have recently started learning, so I was unable to proceed with the same.Any help in this regard would be welcome. Thanks!

Hey there! I've got a cool idea to streamline our database for easier use. Here's a Video Demo: Database Automation for Content Publishing 🤖 | LoomCurrently, I have a content database filled with records from a form, and I've set up automation to fill out most of the fields. I'm exploring ways to automatically assign a publish date based on a rolling schedule I can pre-set. I'm looking to avoid manually setting dates and want the system to add content to the schedule automatically. I'm not sure if I need to create a formula for this or another table to reference back to. Let me know your thoughts Airtable community!

Hello.Very new to Airtable. I am a designer working with a marketer for an events org. We are using Aritable to manage all our projects. I need a unique number for all the projects and am wondering if it's possible to auto number across multiple tables in a base, as that is how she is going to organize (tab for brochures, tab for print ads, etc.)I also would like an alpha prefix because we will have another base for another events org that we work on simultaneously.Ideally, I would like to have all projects in both bases just be auto assigned a unique number, but I don't know if that is possible either.Thanks for any help!

Hi, I am having trouble creating an automation to update a record in a table. When I try to set up the "Find Record" step, I'm getting an error that "cannot assign list of string to string" and I don't know how to proceed or how to fix my data set up in order for the automation to work.The issue (I think) is that in the table I'm trying to update has a linked field which is the unique identifier I need for the automation to find the value I want to add to the table I am updating.  I'll try to explain the data structure and what I'm trying to do. Table 1: ContractsTable 2: Contract Items (this is a list of "products" that are associated/organized with Contracts for clients in Table 1)Table 3: Books (this has an association with Contracts (from Table 1) to a book). One book can have several contracts. One contract can have several books. Table 4: Results (Products from Table 2 is the primary organizing principle for this table, and this is the one I am trying to updat

Is it possible to delay an action from happening? I really like Slack notifications for new records, but I’d like the action to wait say, 1 minute after the record is created so that I can finish adding all of the fields. Is that possible?

I have a date field that contains "2020-11-26" and another field of type selection. I would like to put the date "2020-11-26" in the selection field by transforming it into "26/11/2024". How can I do this?

I am creating an automation script in transferring data from a source table to a target table. The source contains AI generated responses so everything is in text. I have 4 fields in the target table as single-select fields and I found out that the error I am getting is for those fields. Here's the code below. Hope someone can help. let sourceTable = base.getTable('Update Repository'); let targetTable = base.getTable('UPdates');  let inputConfig = input.config();let recordId = inputConfig.recordId;let newRecord = inputConfig.newRecord;// Fetch the record from the source tablelet record = await sourceTable.selectRecordAsync(recordId);// Fields where AI responses are stored in the source tablelet flag1 = record.getCellValue('Name change - AI'); let&nbs

Greetings mighty Airtable community,We are trying to set up a very simple automation called "FIND SIMILAR RECORDS" within our blog article base (hundreds maybe thousands of records/titles/articles) that would look like the example below. When a new record is created, we'd like to automatically Find and Group (and Sort) similar records in order to look for redundancy or duplicates. Meaning:Every time someone goes to "create a new record"When "specific service" field is [current item] entered into the new recordAnd/Or "keyword" is [current item] entered into the new recordAutomatically Find and Group similar records in order to look for redundancy or duplicatesWe'd like this to be an automation rather than to set it up as a simple search option.It seems like a simple request but the free version will not play nice. When we asked Airtable support if the app will do this, they said they cannot help with automation setup. For example, we're not sure:-- if this would be a script to run,

In the Change Request form I've created, users can enter information about a change request -- item, change type, notes, screenshots, etc -- and then they can use a multiple select dropdown to choose up to four Regions where the changes should apply.I'm using a Repeating group to cycle through the Regions input to create a separate record for each Region. 4 Regions chosen, 4 rows, 3 Regions chosen, 3 rows, etc. Beautiful! The trouble is, it also creates a single row with ALL 4 or ALL 3 regions etc on it. How do I stop that?

I need my company logo to appear in every record in a table so that I can have it appear on the sales brochure I create in extensions (unless someone can explain how to do this using the static element there but I can't find a way to attach it there).Is there a way (possibly an automation?) to have that field auto-fill with the attachment whenever a new record is created? Thank you

hi! I have an error in my base that when a project name is changed, the allocation column is deleted. I do not want this to happen, please give guidance on how to adjust automations so that project name changes will not delete allocations. Thanks!

I'm trying to connect MS Power Automate to Airtable. A lot of info seems to be stale out there. I have this flow, which parses data. I found this step HTTP Webhook. I'm hoping to make this a trigger for an Airtable automation. However, when I run the flow, it gives me a bad request error at this step.Does anyone know if this is possible to set up like this?