I’m running an Order Management System with Airtable and I run into the 50 000 limit quite often. My solution is to make a copy of the entire table and clean the main table from most of the copied records.
This solution is quite effective but as I have many of these copies there is a problem where my team needs to find an archived record.
For this I have created a multibase PHP search that works quite well - but I don’t have any way to generate a clickable link to these record.
What I have:
What I need:
Is it possible to generate a clickable link while having a base ID and the record ID - or do I need anything else?
I’m writing the script in PHP.
Thanks for any help - much love to everybody ❤️
It doesn’t work :frowning:
An URL that I get from the SCRIPT - combination of “base ID” and “record ID” looks like this:
But the URL for the same record inside AIRTABLE looks like this (when I open it):
So the Record URL is there but I don’t know how to get these 2 numbers from the API:
Please help :slightly_smiling_face:
As I said, you can get a working URL without the viewID (which always starts with
viw). The baseID is prefaced with
app, the tableID is prefaced with
If you can’t get the table ID with the regular API, you probably have to use the Metadata API, which is in beta at the moment : https://airtable.com/api/meta