I have a table of products with ~5000 records. I’d like to grab a subset of these records (about 1000 of them) using the API, and I already have the list of Record IDs that I want.
I’ve figured out two ways to get this data using filterByFormula, but...
I have a table with a {Product} field, which is a single linked record to the Products table. I wanted to also add the Product’s ID as a new field. But the RECORD_ID() formula doesn’t accept any arguments – it just outputs the current record’s ID.
I’...
Hi all,
I run a small grocery store, and we’re gradually migrating our system of strung-together Excel spreadsheets over to Airtable.
We have already added tables for our 4,500 products, departments, categories, vendors, and brands – everything flows...
Chunking the IDs into batches of 100 is indeed a second or two faster for my query. Here is the code snippet I’m using with the airtbale-php library:
$product_records = [];
foreach (array_chunk(array_keys($products), 100) as $chunk) {
$...
Good question. I’m using this PHP client: https://github.com/sleiman/airtable-php
And I wrote my own helper function for stepping through all of the paged results:
// Recursive version of Airtable PHP client's getContent() method
// Including some bu...
We typically don’t receive partial orders. So our situations might be a little different. Perhaps you could add a Status column to the PO Line Items table, and then you’d have to mark each line item whether it’s been received or not.
