If I generate the URL to the record, it doesn’t need the VIEW_ID, only the Base_Id and Table_Id are needed. But I can’t find way to get the base ID and Table ID.
The issue is if I duplicate the whole table, the URLs pointing to the records or tables are wrong, they point to the original Base.
I know the way to solve it is to add a field in the base that stores the string for the Base and Table. But that needs to be edited every time I duplicate the base.
Is there a way to get the Base_Id and Table_id?
I should be able to do it via Make and Zapier and fill in the record but it seems to me too complicated for something so simple.
I was hoping there was perhaps a trick to do that.
In short, no. Its something tou have to hardcode in the formula.
How many of these formula fields are you modifying, and how often are you duplicating the base?
Well, it’s something I use for convenience, quite a bit because the button fields are customizable.
But the links would point to linked tables so I can use the linked fields instead to achieve the same thing and they will not break.
It’s just it would be nice to be able to use buttons. I guess this is something Airtable omitted. It may very well be on the wish list of the features here in this forum.
They could allow us just to put in the formula expression like THIS_BASE or THIS_TABLE and that would solve this nicely.
There is no way to get a base ID in a formula without hardcoding it.
There IS a roundabout way to get a table ID in a formula field. I did a writeup with screen shots in this page of Kuovonne’s Guide to Airtable.
If you get pop-up asking you to sign-up for Coda, but are not ready to create an account, you can reload the page to make the pop-up go away.
2 Likes
Ha, what a hack. I need to sign up for Coda now because all good tricks for Airtable are now on Coda.
Everybody left to Coda now looks like…
Okay, I see why… Very good thank you for sharing.
