Solved

Hey all, I am trying to update the Owner (type: User) of a record, when a status field is updated. However, I keep getting the error: Field “Owner” cannot accept the provided value: Could not find matching collaborator for string The automation is supposed to copy the value of the owner from a lookup field which basically holds the owner from a linked table. Please help.

Hi - I’m brand new to Airtable and am building a capacity tracker/task tracker for my team. In my capacity tracker table, individual team members are assigned an “at capacity” or “available” marker based on a formula that is triggered by the number of tasks they are linked to in the task tracker table. When a task is marked complete in my task tracker table, I want it to disappear from the column/rows it is linked to in the capacity table, so a team member’s capacity level is always accurate. I hope that makes sense. Is it possible to do this with an automation? I’ve been perusing the forums but can’t find anything that is super clear. Thanks!

I’m certain this is a lack of understanding of JS or synchronous/asynchronous operations on my part, but: if I want to call Airtable.base.create through the Node.js module and actually get the created records (or error) returned to be used elsewhere, how would I do that? Currently, my code looks like this: export async function createRecord(record) { base('example').create({ "field": record["field"] }, function(err, record) { if (err) { console.error(err); return; } console.log(record.getId()); }); } I can get the information logged to console just fine, but I’m not clear on how to properly return it or assign it to a variable and use it elsewhere.

Hey Community ! I’ve been searching here and there, and i don’t see the way to update multiple fields at the same time, in the same updateRecordAsync. Is it even possible ? Because doing one field update at a time is very slow. Any help or workaround appreciated :cowboy_hat_face:

Hello all, I have a question regarding the changes to the attachment url’s. I have images stored on Airtable that I fetch using the API and display them on my site. I am not using the any permanent link. Whenever a user accesses the site, it requests the data and gets the image url and displays it. Will the changes affect this use case? For example, I know that cloudfare may cache the temporary url and then feed it to the public, but does that mean that some users will get a blank image instead of the new url? Thanks in advance

I don’t see the option to select the field to update in a Record Picker Interface. In a different base I am able to set this correctly. What could be the issue?

I am getting a 503 response from Mailchimp API when making a simple GET request. The same request from Postman works. Any ideas why we get a 503? Thanks!

Hi… I am using Airtable as my backend for an app I am building in Appgyver. I am trying to experiment with Airtable’s query parameters and I just can’t seem to get some things to work. Currently, I am just trying to retrieve a list of records, but only certain fields for those records. The API Documentation for Airtable seems straightforward but I keep getting the same error: I received a response from a helpful Appgyver user who pointed out that “The HTTP 422 Unprocessable Entity Code indicates that the server has understood the type of query content and that the request syntax is correct but that the server has not been able to carry out the requested instructions. You have to formulate your request differently to access your data.” However, he stopped short of explaining exactly what this means. Any takers here able to help? Thank you!

I’m wracking my brain trying to figure out how I can make this work. I have an Items table. I have a Locations table. I have a Location Records table that joins the two. An Item has many Location Records, and belongs to a Location through its most recent Location Record, and it has a history of all its past Locations through the sequence of all its Location Records. In the Items table, I can Rollup Location Records–>{Date}–>MAX(values) to pull the {Date} out of the most recent Location Record. But how can I pull the {Location} out of the most recent Location Record, so that I can display an Item’s {Current Location}? I can Rollup Location Records–>{Location}–>ARRAYJOIN(values). I was hoping the {Location} value from the most recently added Location Record would be the first in the array – then I could use: LEFT( {Location Rollup}, SEARCH( ",", {Location Rollup} ) -1 ) to parse out the first value from the array. But, of course, this isn’t the case – ra

I am trying to figure out a way to trigger an action when a specific status record is updated. For example, when a person is moved to a "Pre-Qualified’ status, then trigger an action to send an email. Is this possible? I don’t need just a status record update, but a specific status record update. Thanks!

If all users have a record in the base, is there a way to prefill the user field on a form with the user who is signed in when they access the form URL? Not having luck creating a prefill formula that accomplishes this.

Here’s a short Loom video that explains my question with examples:

Hello!! Hope anyone can shade a light here. Here’s some preliminary information to help you understand what I’m trying to achieve… I have 3 tables within one base: Inventory (primary field: Product_ID) Packs (primary field:Pack_ID) Sales Orders (primary field: OrderNo) The “Packs” table holds packs that are made of one or more products from the Inventory table. The Inventory table holds the individual products used to make packs. I’d like to count the total quantity per item in the inventory table that has been sold, in other words the qty “out” from the inventory. Sales orders are registered in its table and each sale is done by pack.

We host events that volunteers help to run. We have forms to let volunteers 1) create events and 2) choose events to help with on specific, future date-times (i.e. the only event times are Weds and Thurs 7-8pm). Form 1) needs an event date picker with pre-selected datetimes (i.e. Weds and Thurs 7-8pm for the next three months). Form 2) needs to only show events created with 1) that are in the future i.e. we don’t show past events. So we currently have one table (A) with a column of dates (manually created, though automatically would be great - different problem). Then a linked record field in the main events table (B) allows people to select one of the dates from that column. The problem is that, in Form), I’m not sure how to filter events with a future date because the linked record field that links dates from the dates table doesn’t treat linked items as dates. One way round it would be to just have a Date column in events table (B), but that can’t be a multiple choice column so we

Hi guys, have been sitting with this a couple rounds now and can’t get it right. Im extracting a telephone number from a column in Airtable, but when there is no phone number or the word message I get the famous #ERROR. How can I get Airtable to just show it as blank? My formula looks like this: IF({Telefon 1},(LEFT({Telefon 1}, FIND("Message", {Telefon 1}) -1)),BLANK()) Any advice is welcome Regards Jesper

Hello community, I already searched through the forum and found a helpful formula - with a minor problem based on that formula that I am trying to fix. Our datetime_format is D-M-YYYY. Background: We have a field called {start date} for when a new client relationship starts. Let’s say one client started on 1st September 2022 (past date) and another client will start on 1st November 2022 (future date). We have a report automation that we want to send out every year. The first report will be sent out one year after the client was onboarded, that process starting now. That means we do not want to send out multiple reports for a client that started on 1st July 2010, instead they will receive their first report on 1st July 2023. In our understanding we need a date formula adding one year to the {start date} and also consider the current year. Formula: IF({start date}, DATETIME_PARSE(DAY({start date}) & “-” & MONTH({start date}) & “-” & (YEAR(NOW()) + IF(DATETIME_FORMAT(DATEA

So I have the following: IF( TODAY() > {Date Due}, “OVERDUE” ) I have a Column named ‘Days’ for days left to do my task, so I made the following, using the nested IF tutorial: IF( TODAY() > {Date Due}, “OVERDUE”, IF({Days} < 5, “Soon”) ) I’m trying to figure out how to add my ‘done’ column to this but I keep on getting errors. So far I tried: IF( TODAY() > {Date Due}, “OVERDUE”, IF({Days} < 5, “Soon”) IF({Done} = Yes, “Done”) ) but it says invalid. idk how to return text from a multiple choice??

Hi Airtable Community, I have a base that receives and manipulates data coming in using a webhook. Data comes in as a single record (so each webhook brings in a single record of data) and that single record needs to be processed completely before the next record can be considered. In other words, the automation needs to run to completion on one record before the automation starts again for the next record. The automation consists of 1 create record action followed by 5 script actions, and is initiated by the receival of a webhook. The automation runs as expected when tested, however I have started to notice missing data assignments that should have been completed by one or two of the script actions. I suspect this may be because a number of webhooks are received within quick succession, which leads to automations kicking off before the previous one has been completed? Does this sounds plausible? And if so, are there any suggestions on how to resolve this issue? Cheers, Ryan.

Dear Airtable Community, I have created an automation that has multiple actions: Triggered by a webhook (beneficiary data comes in with various traits) Creates a new record in Table 1 with this new data as is (no manipulation) Runs a script that assigns a unique ID to beneficiary (based on this new record in step 2) Runs a script that assigns a household ID to beneficiary’s household (based on this new record in step 2) Runs a script that cleans record (created in step 2 with new assigned variables created in steps 3&4) and then creates a new record in Table 2 I have tested the scripts and they all run as expected - however, in steps 3 and 4 I use the .updateRecordAsync function: Step 3: var recordID = inputConfig.NewRecordID; await tableRaw.updateRecordAsync(recordID,{“Household Member ID Generated”: idFinalString}); Step 4: var recordID = inputConfig.NewRecordID; await tableRaw.updateRecordAsync(recordID,{“Map Block Code”: codeBlock,“Household Unique ID” : HhUniqueID}

Hello. Let me preface this by saying I am not great at scripts, so your patience and clear explanations would be greatly appreciated. We currently have a script (no idea who wrote it ages ago) in one of our tables that works by the pressing of a button. I am trying to get the same script to work by triggering it with a checkbox so I can use it in an automation. Thinking I could just copy/past the script, but that clearly doesn’t work. I get the error : TypeError: input.recordAsync is not a function at main on line 2 I know I have to make some changes for it to work properly, I’ve seen similar responses but couldn’t figure out exactly what to do. The original working script that is currently triggered by a button is: let mapperschedule = base.getTable("Mapper Schedule"); let record = await input.recordAsync('Pick a record', base.getTable('Mapper Schedule')); let topaste = record.getCellValue('Update Mapper Schedule Name - To Paste'); let name = record.getCellValue('Name'); output.markd

HEy All I’m trying to create a CURL API request that Searches for records that are {WEEK} = “24” AND{PAGE} contains “22”. My PAGE field is a look up so it might have more than one page number in it. If PAGE has one one record in it I can use filterByFormula=AND(%7BWEEK%7D%3D%2224%22%2C%7BPAGE%7D%3D%2222%22) I think I need to use SEARCH or FIND but I cant work out the syntax. Thanks in aadvance

Hi all – sorry if this has been discussed before, I had a search around and couldn’t find anything. I’m using an Interface as the front-end to an Airtable → Zapier → Webflow CMS integration. The interface contains a bunch of fields for content — headlines, body text, banner images etc – that I want users to be able to tinker with. However, I’d like to prevent changes from being sent to my Zapier automation until a user clicks “Save” … rather than the cells updating one-by-one as the user works their way through the interface. Is there a straightforward way to make an Interface only commit the changes to the base on a button click? Or is my best bet to do this manually … i.e. make my Last Modified column only update when a certain button is pressed? Many thanks in advance Dave

I am using pre-filled forms to collect records from users. The form fields include linked records. I’ve just realized that anyone with the URL can simply remove the parameters at the end of the URL link to view the base form URL and as a result, will be able to see all of the linked records in those fields. For example, we have a link for a vendor to add a bid. It is pre-filled with that vendor’s information from a linked field. If the vendor is smart, they can remove the parameters from the URL to see the base form and then view all of the vendors in our table from that field. How can we collect data from users with pre-filled parameters in a way that they cannot access the base form?

Hello, I apologise in advance for my simplistic coding effort. It has been 40 years since I dabbled in Visual Pascal and PHP :slightly_smiling_face: I am writing an update script for use via Airtable web form submitted updates. The record created in the update table is polled by the script and only the completed fields in the update record, ie only fields that were filled in on the web form, are updated in the original record, contained in a separate (original) table. A series of “if-then-else” statements determine which fields in the original record require updating and an array named fieldsArray, containing the field name and the associated field value for each field that requires updating, is constructed. The recordID of the original record (that is to be updated) is passed to the script via inputConfig and I construct an updateRecordAsync() function using that recordID and the fieldsArray. My problem is that I cannot work out how to construct the updateRecordAsync() function

Hi community, I’ve built a labor tracker where we will track hours worked per Person/Project/Day. Based upon an 8 hour day, I want to calculate the percent of their day worked on that particular project. For example, if Veronica works on Project P-035.1 for 4 hrs, she submits that through a form by entering her name (linked field), the date she worked, the project (linked field) and the hours she spent on that project that day. In the case of working 4 hrs, the percentage worked on that project for the day should be 50%. I’m hitting a total blank on how to do that with a formula. (right now the % field is just a manual thing, because I don’t know what the formula should be) After that, I’m hoping to figure out how to calculate percentage worked on the project for the Month, because that’s how our budget predictions are created, and I want to compare and contrast predictions with actuals. Any help would be greatly appreciated!