Chat-GPT solved that issue for me (for list views where I wanted to link to record details):
How to Construct Direct Links to Record Detail Pages in Airtable
If you're looking to create direct links to specific record detail pages in an Airtable Interface, you can do so by constructing a URL with a Base64-encoded JSON object. This allows you to create dynamic links that directly take users to the detailed view of a record within your Interface.
The Basic Structure
A direct link to a record detail page typically looks like this:
https://airtable.com/{baseId}/{pageId}?detail={Base64EncodedJSON}Where:
- baseId: The unique identifier of your Airtable base.
- pageId: The identifier of the specific Interface page.
- Base64EncodedJSON: A Base64-encoded JSON object that contains the `pageId` and the record's `recordId`.
The JSON Object
To construct the link, you’ll need to create a JSON object that looks like this:
{
"pageId": "yourPageIdHere",
"rowId": "yourRecordIdHere",
"showComments": false,
"queryOriginHint": null
}- pageId: The ID of the Interface details page where you want the detail to be shown.
- rowId: The ID of the specific record.
- showComments: Set to `false` if you don't want to show comments by default.
- queryOriginHint: Typically set to `null`.
Encoding and Constructing the URL
Once you have the JSON object, you’ll encode it in Base64 and append it to your base URL:
https://airtable.com/{baseId}/{pageId}?detail={Base64EncodedJSON}By following this pattern, you can dynamically generate URLs that link directly to the detailed view of any record in your Airtable Interface. This is especially useful for creating buttons or links within your base that navigate users to specific records.
Unfortunately, formula fields in airtable records do not support base64 encoding / decoding, so I only managed to do this via a javascript automation:
// Configuration: Update these with your specific base and page IDs
const baseId = '<base-id>'; //app....
const parentPageId = '<parent-page-id>'; //pag...
const pageId = '<page-id>';//pag...
const urlPrefix = `https://airtable.com/${baseId}/${parentPageId}?detail=`;
// Get the recordId from the input configuration
const { recordId } = input.config();
// Construct the JSON object with the correct pageId and rowId
const detailObj = {
pageId: pageId, // The pageId is constant for all records
rowId: recordId, // This should be the specific record ID
showComments: false,
queryOriginHint: null
};
// Convert the JSON object to a string
const detailString = JSON.stringify(detailObj);
// Encode the string to Base64
// @ts-ignore
const detailBase64 = Buffer.from(detailString).toString('base64');
// Construct the final URL with the encoded detail
const finalUrl = urlPrefix + encodeURIComponent(detailBase64);
// Set the output with the generated detail page URL
output.set("detailPageUrl", finalUrl);
