Automations

Ideal Solution Goal: Every 4 hoursUpdate first record in "GolfNomadContent_StagingTable" where Status = NO, to Status = YESWhen Status changes to YES > Copies row to "GolfNomadContent_ProdTable" with YES Status--I understand the Automation tool only handles one record at a time. Using Zapier (as an alternative), I can also update/change records However, using Zapier, you're required to use a "RecordID" which appears to be unique to each record (therefore if I'm moving the record from the table, the next time the automation runs it will search for a "RecordID" that's no longer on the table. --Use Case: We are helping a local marketing company to scale their content creation by asking multiple people at the company to write content into a form, which we're aggregating into the "StagingTable" - Then, our marketing team wants to use Zapier to distribute th

Hi all,I'm working on building a base for my team, and am having an issue with automating a copy-and-paste function.I have a formula which calculates the due date for tasks based on a set number of workdays from the start date. However, sometimes we need to edit due dates of individual tasks and don't want to edit the start date or the number of workdays—so, I need to figure out a way to copy the data in the due date formula field to another field where it can be edited. (I know I could just edit the workdays on each task, but for a variety of reasons I think that will be too complicated for my users/set up.) In order to copy-and-paste data to make it possible to edit dates, I have been using this automation:  

Hi, I have a simple automation.  The test works fine but it clicking the "on" button doesn't work. I've tried making new automations. They too have the same problem. Any advice? Thanks

Hi!     In my project plan I need to use hierarchical (or outline) numbering such:1  ~ 1.1 ~ 1.2 ~ 1.2.1 ~ 1.3 ~ 1.4 ~ 1.4.1 ~ etc. (print 1)     I've be doing this manually, but it would be great to have it being created automatically.     I got the formula below from the internet, but I stuck in the error showed in the print 2.     I also pasted, lower, the instructions I received.     Please, can someone drive me to a easy way to have such WBS numbering (Work Breakdown Structure)?     I thank you all in advance.The formula I'm using: "IF(LEN({Parent}) = 0, {Autonum} & ".", {Parent.Autonum} & "." & {Autonum})"Print 1: (the need)Print 2: (The error)

I wrote a script in my automation to create a linking table of sorts that carries over records from two different tables. I have a field that is a formulated value in both source tables and in the target table I want that to be single-select. Is this possible? I cannot get the values to match up! The formulated value in source tables are based on dates, depending on what range the date falls in the output will be either one of 4 values: "Q1", "Q2", "Q3", or "Q4".Now when I log the output of the target field value of each record (there are hundreds) I get:"Q2, Q4, Q3, Q3, Q3, Q3, Q2, Q2, Q4, Q1, Q3, Q4, Q1, Q2, Q3, Q4, Q4, Q3, Q4, Q3, Q3, Q3, Q3, Q3, Q4, Q3, Q1, Q3, Q2, Q4, Q3, Q3, Q3, Q4, Q2, Q3, Q4, Q3, Q4, Q3, Q1, Q3, Q3, Q3, Q3, Q3, Q3, Q3, Q3, Q3, Q2, Q2, Q3, Q1, Q3, Q3, Q4, Q3, Q2, Q3, Q4, Q4, Q3, Q3, Q3, Q3, Q3, Q2, Q2, Q1, Q3, Q3, Q3, Q3, Q3, Q3, Q2, Q3, Q3, Q4, Q3, Q1, Q1, Q2, Q3, Q3, Q4, Q2, Q2, Q3, Q3, Q3, Q2, Q2, Q3, Q1, Q2, Q4, Q3, Q4"Can a

Using airtable for project management, so far the set up etc is fine. One thing I am trying to set up is a script (can be put into a field as a button) that deletes the record that the button is in but also deletes all linked records in the sub task section. Therefore you are removing an entire project and sub task. At the moment the following naming conventions existProject (table) which links to Sub Task (table). When a sub task is added it links to the Project. Therefore the script must delete the Project and all linked records in a Sub Task section. Can anybody help with the script for this?

I have a table with several "linked to another record" fields and a multi-select list with one option for each linked field. I would like the list to be updated automatically based on the following logic:If the linked field is empty, the option related to that field shall not be selected in the multi-select.If the linked field is not empty, the option related to that field shall be selected in the multi-select.It looks quite easy to do with a script, but laborious with an automation because of the way automations update lists. They do not add or remove options based on what has changed but instead is asking me to tell what options shall be selected and which ones not. This forces me to start my removing all the previously selected options in the multi-select list, and then define the automation based on all the potential combinations of empty and non-empty linked fields. With a limit of 25 conditional actions in an automation, I can have up to 5 lin

Hello, It is my company's first attempt at using Twilio. We already have our account and phone number. Was wondering how do I set it up so we can test if the message was successfully sent to this number.  Such as updating a Single Select field in AirTable corresponding to the record that would say "SUCCESS" or "FAIL". Is that possible?  What would I need to do to set it up?  I know there is a statuscallback URL within the AirTable Twilio automation action, do I do it through that?   How about collecting received responses?  

Greetings. My automation receives a webhook from a form. In subsequent steps, I'm unable to reference the field values: it's gray, and hovering displays the error "Cannot assign list of collection of complex types to collection of complex types."How can I reference these values, or at least reference the raw JSON in a scripting step?

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

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++){ 

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!