Skip to main content

Hi Airtable community,


I am new to Airtable and looking to create an easy (not overwhelming) way to present all of the Tables/Tabs that need to be filled out by our clients.

Currently, we have a number of Tables which creates many Tabs that have to be scrolled horizontally at the top. This is not ideal, as there isn’t a way to see all Table names at once.

I am thinking of creating an Executive Summary Table which becomes the 1st tab in the list that has a Vertical list of Table/Tab names linking to the Tables/Tabs that way.

However, I need help in creating these links.

What do you suggest?

Is there an easy way (automated) to create this Executive Summary?

If not, how can I link to the Tables/Tabs themselves? Are there anchor links I can use?


Thank you in advance!

The three dashes in the left corner of the Tables tabs allows you to see a searchable list of tables where clicking on one takes you directly to that table. Similarly, the CRTL+J keyboard shortcut lets you search for tables.


Otherwise you could make your first table have one row per table that includes a link to that table. All table links are predicatable: https://airtable.com/[base id]/[table id]. You could fill this out yourself, or run this script once:


let baseId = base.id

let tables = base.tables



let summaryTable = base.getTable("Name of Table")



let updates = tables.map(x => {

    return {

        fields: {

            "Name": x.name,

            "Table Id": x.id,

            "URL": `https://airtable.com/${baseId}/${x.id}`

        }

    }

})



while (updates.length > 0) {

    summaryTable.createRecordsAsync(updates.slice(0, 50))

    updates = updates.slice(50)

}

Welcome to the Airtable community!


I have done this often. I use a button field for opening different tables/views. The button field uses the “Open URL” action. The formula for the button field is a url field.


So my table has the following fields:



  • table / view name (single line text)

  • url of table / view (url field)

  • button field (open url)

  • help text explaining purpose of table (long text field)


You can get the urls from your web browser when you open Airtable in a web browser.

Reply


Terms & Conditions