BrianCafferelli
8 years agoQuickbase Staff
How do I find the database ID (dbid) of a Quickbase table?
How do I find the database ID (dbid) of a Quickbase table?
Quickbase uses an alphanumeric database ID, or DBID, to uniquely identify each app and each table on our platform. You can find the DBID of a table in the address bar of your browser when you're looking at any page of the table. The home page of all Quickbase applications has a DBID that does not refer to any of the tables in the application. You can view a record or a report on one of your tables, then look in your browser's address bar to see that table's DBID. The DBID is after the "https://mycompany.quickbase.com/db/"; and before the first question mark "?" if there is one. For example the dbid in the following URL:
https://login.quickbase.com/db/6ewwzuuj?a=dr&r=ej&rl=bjd
is
6ewwzuuj
If you are an app administrator, you can find the DBID for your application and for all tables in the application by following these steps:
1. From your the home page of your app, click Settings.
2. Select App management.
3. Click Show app statistics.
A window appears that displays all stats for your app. The first DBID you see is your App ID. DBIDs for all tables in the app appear below.
One thing to keep in mind using a specific DBID in your formula is that, if you copy your app, the formula will need to be updated since the app copy will not have the same DBID. You can use the DBID() function to automatically insert the DBID of the current table, which would look like this in your formula field:
"https://mycompany.quickbase.com/db/"
& Dbid() & "?a=td"What if you want to link to another table without having to worry about having to update the DBID down the line?
If you are an app administrator, you can find a table alias for the table which will insert the DBID of that table into your formula. An app admin can find a table's alias by following these steps:
1. From your the home page of your app, open the table you'll be linking to.
2. Click Settings.
3. Choose Advanced settings.
Scroll down to the bottom of the page and the table alias appears.
In your formula field, the alias will look like this:
"https://mycompany.quickbase.com/db/"
& [_DBID_PROJECTS] & "?a=td"