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:
- I have the base ID that I’m searching
- I have the record ID
What I need:
- An https link that opens the record in Airtable so that my team doesn’t have to open the table manually.
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 <3