Automations

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 e

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 great

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}`,         

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...

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(ful

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 {

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.up

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 "approve

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 #VersionIteration001A1001A2001B1002

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!!

I'm adding a row in sheets successfully but only 2 of 6 fields are being copied over. What could be the issue? Thanks.

Hi, I have multiple automations pulling data from formula fields, that have been formatted to include the euro sign. This works fine in the data, however when I pull the values into automations, the euro sign and formatting that I put in the formula field isn't applied. The base I am using is under a free account.  Could you let me know of any solutions?  Thanks 

I ran into an issue setting up an automation for some colleagues of mine. We all work in the same workspace, but depending on the team there are different tables within the workspace to manage their work. To keep things simple, lets say Team A works in Table A, and Team B works in Table B.Some of the work Team A does in Table A is for Team B. Team B asked for a way to see just that work in their production calendar on Table B. I created an automation pulling just the pertinent info from Table A to Table B so they can keep track of it. (I am oversimplifying this for the sake of my issue.)The automation has so far worked perfectly, with one issue. Team A uses a Date field for their Due dates without a time field, Team B uses a Date field for their due dates with a time field. For whatever reason, when the automation runs, it will change Team A's due date (ex. 1/2/24) to the day before at 7 or 8pm (ex. 1/1/24 7:00pm). Both date fields use the same date format of "U

https://airtable.com/apprdPguzaBCfjD56/shroyWamJGrG0yeMiIn the sample base above, I have two linked Tables. One is a list of projects, the other is information for a quarterly report. Currently, I am linking the tables to each other manually when updating project start and end dates. For example, if I add a new project scheduled to start today and end 3/1/2024, I'd add a new record with a start date of 11/30/22, the end date of 3/1/24, and then link it to the "2023 Q4" and "2024 Q1" records from the second Table. Projects don't often (if ever) end when planned, so I come back and update the end dates often which means I also have to go back to check the linked Quarter records to make sure they're still accurate. This seems like something that should be easily automatable.I don't necessarily even NEED the Quarter Table. There is no other information about each quarter that I collect.

Hi, is there a way I can send a webhook to an automation in another base via a button which runs a script?So like:press button on record on base A > runs script > script sends webhook to base B > webhook triggers automation to create recordI can achieve what i want via a checkbox and syncing but i dont want them to have to uncheck and check the box to do it againAny ideas?