Jan 28, 2021 12:05 PM
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 ❤️
Jan 28, 2021 12:23 PM
The url for a record is always:
Jan 28, 2021 01:35 PM
Thank you so much for the answer.
Is the [tableID] the same ID that I use to connect to the API via PHP (the same that is at the top of each table API documentation?)
And is the recordID the record that I get in [“id”] in the main array of each record?
Thanks once more
Jan 28, 2021 01:51 PM
My answer is “yes?” to both questions. As far as I’m aware, IDs are consistent, there wouldn’t be another ID associated with a table, record, view, etc. that you’d pull from the API.
Jan 28, 2021 02:09 PM
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:
Jan 28, 2021 02:28 PM
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