302 Found

Found

The document has moved here.

Knowledge Base

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

How can I embed a QuickBase report into a Web page on my own site?

1. Create the report that you want to embed. If you're not familiar with how to create a table report, the following link explains the steps.

https://www.quickbase.com/help/creating_a_table_view.html

2. In the HEAD section of your Web page, add the following <script> block:

<script lang="javascript" src="https://www.quickbase.com/db/dddddddd?a=API_GenResultsTable&qid=n&jht=1">
</script>

where dddddddd is the database ID (dbid) and n is the ID for the report (qid) that you want to embed.

To discover the dbid of a database please read:

http://quickbase.intuit.com/developer/node/2106

To discover the qid of a report please read:

http://quickbase.intuit.com/developer/node/2087

You have two options at this point. You can open your application up to the group "Everyone on the Internet". If you're not familiar with this group, the following link explains how to open an application up to the public. Be aware that you do not have to open the entire application up to the group "Everyone on the Internet", only those tables whose data you are trying to display.

https://www.quickbase.com/help/share_with_everyone_on_internet.html

If you do not want to open your application up to the group "Everyone on the Internet", another option is to create a new QuickBase account for this purpose and assign it a role that has "View" access to the table in question. The following link explains how to register an email address with QuickBase.

https://www.quickbase.com/help/registering.html

Then pass the username and password credentials of this new account as additional parameters:

<script lang="javascript" src="https://www.quickbase.com/db/dddddddd?a=API_GenResultsTable&qid=n&jht=1&username=viewonly&password=notsosecret">
</script>

3. In the HEAD section of your Web page, add the following style information:

<style>
td.m { font-family:verdana; font-size:70%; }
td.hd { font-family:verdana; font-size:70%; font-weight:bold; color:white; }
</style>

By changing the attributes of these CSS tags, you can modify the format of the resulting table.

4. In the BODY section of your Web page where you want the HTML table to display, add the following JavaScript code:

<script lang="javascript">
qdbWrite();
</script>

--------------------------------------
Here's a more complete example:

<html>
<head>
 
<script lang="javascript" src="https://www.quickbase.com/db/5rh82jcq?a=API_GenResultsTable&qid=5&jht=1">
</script>
 
<style>
td.m  { font-family:verdana; font-size:70%; }
td.hd  { font-family:verdana; font-size:70%; font-weight:bold; color:white; }
</style>
 
</head>
 
<body>
 
<h1>Example</h1>

<table cellpadding=5 bgcolor=lightgreen>
<tr>
<td valign=top nowrap><b>A QuickBase table<br>embedded in a<br>page of HTML</td>
<td>
<script lang="javascript">
qdbWrite();
</script>
</td>
</tr>
</table>
 
</body>
</html>

For full documentation on API_GenResultsTable please read:

http://www.quickbase.com/api-guide/index.html#gen_results_table.html

NOTE: QuickBase recommends that you use application tokens when working with API calls (read more about tokens at https://www.quickbase.com/help/app_tokens.html).

Comments

Database hosting by quickbase

How can I remove the "database hosting by quickbase" statement that is shown after the table?

Hi Andrew, The 'Database

Hi Andrew,

 

The 'Database hosting by quickbase' is a standard part of the report display, so unfortunately it can't be removed. I'm sorry for the inconvenience.

 

Thanks,

Brian

Didn't work for me

I followed the directions using the second user method. I am getting:

Error in call to API

Invalid Application TOden (API Error)

Any ideas how to fix this? Also, is there not a contact number to call someone for help? I tried to reach my "coach" but have as of yet to hear back from him regarding some quickbase questions.

Thanks.

some debugging ideas to try

Hi Wendy --

Sometimes API calls take a couple of tries to get all the details right. Here are some things to check:

The "src" attribute of the first <script> tag is very important. It should contain:

  • the name of the database you want to get the data from (5rh82jcq in the example; you will need to fill in a value from a QuickBase you have access to)
  • the name of the API call you're making (should be correct in the sample, no need to change)
  • a valid authentication ticket returned by API_Authenticate
  • a valid application token (if your application requires them)
  • the identifier for the query (report) you're running (5 in the example)
  • jht=1 (this makes the call return the HTML needed to make the qdbWrite() call work)

Also, it's important to give the user that you use in API_Authenticate access to the table and report that you're embedding. If possible, log in as the user and run the report manually to make sure that all the permissions are correct and the report contains the data you think it will.

If none of these things work and you're still having issues with getting the report to run, please contact QuickBase Support directly to work through this issue: http://quickbase.intuit.com/support.

Regards,

--Sybil

Question: View/Edit Buttons

I noticed that this does not add the "edit" or "view" buttons.  Does anybody know of a way to do that?

 

View/Edit Buttons

Hi Vanessa,

 

Unfortunately, the View/Edit did'nt really show on the report but you can do a work around by creating a new field with a field type Formula -URL and put the right formula on it. After that you may add those field to your report.

 

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.
302 Found

Found

The document has moved here.