Knowledge Base

Our Knowledge Base covers a wide variety of technical topics, from the basic to the complex.

How do I find the database ID (dbid) of a QuickBase table?

For all QuickBase users, you can find the database ID 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 must navigate to a form or view that is specific to your table to cause the proper dbid to appear in your browser's address bar. The DBID is after the "https://www.quickbase.com/db/" and before the first question mark "?" if there is one. For example the dbid in the following URL:

https://www.quickbase.com/db/6ewwzuuj?a=dr&r=ej&rl=bjd

is

6ewwzuuj

If you are an application 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://intuitcorp.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 application 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://intuitcorp.quickbase.com/db/" & [_DBID_PROJECTS] & "?a=td"

Comments

Post new comment

The content of this field is kept private and will not be shown publicly.
Type the characters you see in this picture. (verify using audio)
Type the characters you see in the picture above; if you can't read them, submit the form and a new image will be generated. Not case sensitive.

© 1997-2014 Intuit Inc. All Rights Reserved.

Online Database VeriSign Secured Web Based Software TRUSTe Certification Online Database SSAE Audit