Automations

I am building out an intake form for system issues. When a form comes in I want the ticket to be assigned based on who moves the ticket into in progress. I see that I can put conditions to assign to a certain person but not build it out based on how put it in progress. Any help would be great.

I have a "main" table, call it A.  It holds client names.  I have a second table, call it "B."  It will hold deadlines.  For every A record, i.e. client, Table B should have one corresponding record where a lookup field (call it "Name") populates with the "Name" field in Table A.  Then Table B holds deadlines specific to each "carried over" or "mirrored" record from Table A. It should be that when a record is created in A, a corresponding record (assuming auto-number-generated?) would be created in B, with the name lookup from A.  Then deadlines get logged in Table B, and an interface created to allow viewing of deadlines and other things from various other tables for the various clients in Table A. But Table A is the master table.The aim is to have sensible table size (one giant table with every imaginable deadline would be unwieldy) but not have to manually create Table B Deadline records for every Name/Client in Table A.Many thanks for any help!

Hi AT community,I'm trying to get around a script (as part of a larger automation, first step being a form submission) in which I want to:1. Grab the options available of a "link to another record" column (especially the id)2. Cycle through the ids and see if the "Email" from the form is contained in any of the ids3. Select all linked ids that match the condition beforeNot posting any details, since I want to understand the syntax approach and then implement it myself.Thanks!

 Hi, I need help with an automation that I can't get to work. I have set up 2 separate automations, both triggers "when record matches condition" (different conditions) one adds one linked record, to field "work" and the other automation adds another linked record to the same field. However, they seem to overwrite the existing linked record. How do I avoid this? I tried setting it up so that I pull in the actual linked record field and then separated by a comma the record id, but that made the automation pull in 2 different linked records, when I only wanted the one 🤔 🤔Any tips? Not a super advanced builder &#x1f605

Hello!Is there a way to get a public expiring url of an attacement through a script?I use this code to get the cell value: let aTable = base.getTable("Table Name");let queryResult = await aTable.selectRecordsAsync({fields: [aTable.getField("Attachment field")]}); for (let recordInd = 0; recordInd < queryResult.records.length; recordInd++){     let attachmentCellValue = queryResult.records[recordInd].getCellValue('Attachment field)}//attachmentCellValue.url is a private url and I would like to get it as a public expiring urlThanks!

Hello community! I would like support to create a custom script that finds a specific:1. Table2. Record within that table3. Cell within that recordAnd it removes an email (inked record) from that cell.The 'email to be removed 'and 'RecordId' are updated automatically using input variables in the scripting code using input.config().I would really appreciate any help with this. Thanks in advance!I tried using ChatGPT to create the script but I kept getting errors. Here's an example of the script it provided:// Airtable script to remove an email from a list of emails within a specific cell// Replace 'YourTable' with your actual table nameconst table = base.getTable('YourTable');// Replace 'EmailsField' with your actual field name containing the list of emailsconst emailsField = table.getField('EmailsField');// Replace 'LinkedEmailsField' with your actual linked records field name for email addressesconst linkedEmailsField = table.getField('LinkedEmailsField');// Extract the input variable

I've set automation to create record which get value from a field when a value is entered to that field (use trigger type "when record matches condition"). But the automation is real-time triggered when the typing has not finished yet, so the getted value is incomplete. For example, enter "300" but only get "3". How do I fix it please? Thank you a lot. 

I am attempting to use Airtable as a month end close tracking form. Is it possible, that once a task is completed, it will create a new task for the same day in the next month? As an example, this task would be completed on December 15th, then once completed it recreates the task with a deadline of January 15th.

Hi! Is it possible to create an automation that will email someone the results from one column (not the full record) of a grid?We are doing an exercise where staff fill out an airtable form saying what they value about other people on the team (long text responses).  So each record has the feedback about every staff member from each person that fills out the form.  Is it possible to have an automated email go out to individual staff members with just the responses from their column?Hopefully this makes sense - thank you!

Hi everyone, I know I certainly need automation. But I am not sure what I am going to do.Description of the problem:I created a delivery driver pickup form (in Table 1) for volunteers to submit their pickup schedules for one or more schools. Right now, I will need 3 information (name of the pickup person, pickup date, and pickup time) submitted in this form to be automatically updated in an existing classroom table (table 2).I have tried different ways. However, it seems like I am having difficulty for the information in table 1 to be correctly matched with the information in Table 2. I think the problem is I don't know which Record ID I should pick and the system keeps saying there is an error when I was setting my automation.My goal is that I am hoping if a volunteer submits that they will pick up materials for school A, the 3 required information I need will automatically update in the same school in table 2.Thanks so much, any feedback is greatly appreciated! Table 1: Tab

I have a javascript code that basically displays a recording menu that allows you to record your voice, and then I added that on stop you can click to send the file to airtable. But I keep getting 422 error. I read somewhere that when sending attachment it need to be on publicly available url. Any ideas how can I solve this?$.ajax({        url: apiUrl,        type: 'PUT',        headers: {          'Authorization': `Bearer ${apiKey}`,          'Content-Type': 'multipart/form-data',        },        data: formData,        processData: false,        contentType: false,        success: (response) => {          console.log('Audio uploaded to Airtable successfully:', response);        },        error: (error) => {&

I have a script that takes a fuel price increase in a single cell and applies it in each cell in a row of fuel prices at various Fuel Stations. The code is copied below. How can i optimise the code to run in as little time as possible?let table = base.getTable("Customer Deals"); let queryResult = await table.selectRecordsAsync({fields: ["Petrol Price", "Price Increase"], sorts: [{field: "Price Increase", direction: "desc"}]}); let firstRecord = queryResult.records[0]; let increase = firstRecord.getCellValue("Price Increase"); if (!(increase === 0)) { for (let record of queryResult.records) { let newPetrolPrice = record.getCellValue("Petrol Price") + increase; await table.updateRecordAsync(record, {'Petrol Price': newPetrolPrice}); } await table.updateRecordAsync(firstRecord, {'Price Increase': 0}); } 

Hi everyone,It appears that I cannot use the "Find records" action with a condition on a date field "is within" "this calendar month".It is fine if I choose any other "is within", such as "the past month". But it won't work if i choose "this calendar week", "this calendar month" or "this calendar year".The error is not clear, it simply states "A condition is incomplete or invalid".What am I missing? 🤪See attached screenshots:

I'm trying to adjust the column width in an digest email but the truncate fields doesn't change the layout and I'd like the columns to be spread out more. Is there any way to set this? Even adjusting the view I'm pulling from doesn't change anything.  

My data schema is such that I have Programs which contain projects, each has its own table. I then have workers as a separate table, where I can link the workers to programs and/or projects. I am trying to set up an automation that checks if a worker is linked to a program, and if so, automatically links them to the projects which are part of the master programs.I've seen a few other questions similar to mine that seem unresolved... so not sure if this can even be done.Trigger: when record matches conditiontable: Workerscondition: when 'linked program' is not empty Action 1:in table "projects", find projects where linked program is record ID of program identified in the trigger (this seems to work)Action 2: Update record in projects tableRecord ID: make new list of "project name" from find projects (action 1)Fields: Workers - add worker name... It just says 'received invalid inputs'. worker name is the key field in the workers tab, and is computed from first + last name.

Dear AllI am trying to automate "master project status" in the base, hopefully through creating a formula. "Master project" is a made of all small "projects". Logic as below: - If all of "project status" is "concluded", then "master project status" is to reflect "concluded" automatically- If all of "project status" is "planned", then "master project status" is to reflect "planned" automatically- If all of "project status" is "onhold", then "master project status" is to reflect "onhold" automatically- If one of the "project status" is "ongoing", then "master project status" is to reflect "ongoing" automatically Thanks a lot!

When I click 'activate options' no options are showing. I've double checked that activate options isn't already ticked on any other orders. It's been working fine, so not sure why it is suddenly not working. It's not working on multiple devices, and I have logged out and back in with no luck.Any ideas??

Hello,I'm working on an automation that, when triggered by a new record being created, runs a script. The script should take that record, parse a comma-delimited list, then create new records in a separate table. The new records are include the unique names, the count of each unique name, and a link back to the original record. I mostly have this sorted now thanks to some awesome older forum posts, but I'm having trouble understanding how to write new records.The error I'm getting is on the last line of code where the records are being created: Error: Field "fldjndAnd48IHziyd" cannot accept the provided value.I believe the issue is with how I'm assigning the records. I do not understand the correct syntax, so any help would be highly appreciated!   let inputConfig = input.config(); let fullnameList = inputConfig.fullnameList; let sourceID = inputConfig.sourceID; const uniquenames = [... new Set(fullnameList)]; //gets unique array elements see https://codeburst.io

I want to send a webhook when a button is pressed on a record :// Use recordAsync to get the record associated with the buttonlet record = await input.recordAsync();// Check if the record existsif (record) {// Construct the URL based on the fetched record IDlet url = `https://hooks.airtable.com/workflows/v1/genericWebhook/appXXXXXX/wflXXXXXX/wtrXXXXXX/${record.id}`;// Fetch data from the constructed URLawait fetch(url);} else {console.error("Record not found");}but I'm getting this error:ERRORTypeError: Invalid arguments passed to input.record(label, source, options): • label should be a string, not undefined • source → source should be a Table, not undefined or source should be a View, not undefined or source should be a RecordQueryResult, not undefined or source should be an array, not undefined at main on line 2Can anyone help here please? (I don't know scripting)

Is it possible to embed a calendar view in an automated email?

Hi all,I have an automaton where at X time, once a week, records are scanned for any projects that are within the next coming week, the status is to be changed to "Upcoming". I am recieving an error message on the update record part. I have attached a video below for you to see.Does anyone know what the problem is and a solution?Kieran

Title.I am still getting the hang of scripting, Airtable, and scripting for Airtable. Goal of script:User chooses up to two options in multi-select field.Those multi-select options are 1:1 with the names of the records that are being linked. (IDs are included regardless).Link those up to two records from the Signature Hardware Vendor multi-select field into the Vendor(s) linked records field.Ill gladly take hints on updating or fixing my bad code leading up to the portion in question, but I can confirm everything shown below is working BESIDES the linking of two different records.  const { recordId , QASubtype, SHVendor} = input.config(); const table = base.getTable('tblFvUDsFR14aJ8Nu'); if (QASubtype==="Signature Hardware Quick Add"){ await table.updateRecordAsync(recordId,{ "Manufacturer(s)": [{ id: 'recBUCS8K6yzHS1Nd' }] }); if (SHVendor==="Signature_Hardware - 1481"){ await table.updateRecordAsync(recordId,{ "Vendor(s)": [{ id: 'recyW5pRLYxqFIMkt' }]

Hello all!I don't believe this is possible with how automations work with Airtable as I know them, as they seem to be restricted to only automating one table and that one table's records. Regardless, I'm hopeful there's an extension or something that can get around this, as this seems like something that would be extremely useful to most people. I'm going to lay out an example for what I'm trying to do/the parameters around it, rather than trying to explain it with a block of paragraphs.An existing table's records is a list of projects. These projects are labeled as either approved/denied/pending/submitted in this table, and each of the project records were spawned from a submitted form. Once a project is labeled as "approved," it would make my job/my company's job easier if a new table(s) can be spawned, based on pre-saved table templates (though, honestly, I don't even know if it's possible to save a table template). So for example, once a project is labeled "approved," a table label

Hello! Here's my situation.I have a table 'Part List' that is automatically updated with parts from an external base that I do not control. One of the data entries inputted is "version" and "iteration". So I could have the following table:Part #VersionIteration001A1001A2001B1002A1003A1003A2Where the rows in red are the most recent parts (red is only shown here for emphasis, not in airtable). Deleting rows is not an option because I do not control the data source. I want to create a column that will have checkboxes, and it will be checked if it is the most recent iteration.Dedupe does not work because I cannot merge cells that I cannot edit, and I have thousands of entries so that would take too long.I've tried to adapt the Mark Duplicate example but I get the "Api request failed: Request Entity Too Large" error. But also I wouldn't know where to go from there.The closest I've gotten is below where I can mark a checkbox in a "Is Duplicate" column if it is some iteration of a duplicate p

Hello!I'm fairly new to Airtable, but I have found myself stuck on something and I'm unsure the best approach.  I have a base that is receiving data from submitted forms for security requests.  These requests are worked on by 3 different staff members.  I've built interface views for each member and I am now trying to add a button on each interface that once clicked, would update a record with a blank "Assigned to" field to their name and thus populate into their interface view.  Is there anyway to do this in Airtable? It could be I need to think about it in a different way rather than updating a field, that's why I am reaching out!Thanks!!