I really appreciate your help. This is what I have and what I get.
<html>
<head>
<script lang="javascript" src="https://xxxxx.quickbase.com/db/xxxxx?a=API_GenResultsTable
&apptoken= xxxxx
&qid=41&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 Quick Base table<br>embedded in
a<br>page of HTML
</td>
<td>
<script lang="javascript">
qdbWrite();
</script>
</td>
</tr>
</table>
</body>
</head>
</html>
When I add this, this is what I get:
------------------------------
ProjectsForce
------------------------------
Original Message:
Sent: 11-05-2019 14:42
From: Evan Martinez
Subject: Table Report in HTML
Hi Chad,
yeah the QID=5 is where you are dictating what report in Quick Base you want to use. In my example I would change the 5 to a 1 to use the report that URL goes to. So you would want to build the report in Quick Base that you like, then you would look at the URL of that report when viewing it and find the QID, then once you have that reports specific QID you plug it into the API call instead of the 5, so if it was report 23 you would be 23 in instead of 5.
------------------------------
Evan Martinez
Community Marketing Manager
Quick Base
Original Message:
Sent: 11-05-2019 14:37
From: ProjectsForce
Subject: Table Report in HTML
This is how I have it right now.
<html>
<head>
<script lang="javascript" src="https://xxxxx.quickbase.com/db/xxxxx?a=API_GenResultsTable
&apptoken= xxxxx
&qid=5&jht=1">
</script>
------------------------------
ProjectsForce
Original Message:
Sent: 11-05-2019 14:31
From: Evan Martinez
Subject: Table Report in HTML
Hi Chad,
What could help is to actually build a report that is set up the way you want it to display on your HTML in the table in Quick Base, then you would make sure specifically this part:
&qid=5
is set to the correct report qid. You can see the QID of a report when you look at the URL in Quick Base when you have the Report open. So seeing a report URL it would look like https://myaccount.quickbase.com/db/XXXXXXXX?a=q&qid=1. Do you have your qid set to an existing report that has the data you want to pull?
------------------------------
Evan Martinez
Community Marketing Manager
Quick Base
Original Message:
Sent: 11-05-2019 14:18
From: ProjectsForce
Subject: Table Report in HTML
Evan, this is exactly what I was trying to use, but it just returns a green box with the text in it stating a Quickbase table in a page. I do not know how to add the Clist to it or to identify the fields I want to make up the report.
------------------------------
ProjectsForce
Original Message:
Sent: 11-05-2019 14:15
From: Evan Martinez
Subject: Table Report in HTML
Hi Chad,
Do you have an example of the API set up you are using right now? You would just want to replace any UserIDs, Auth Tickets or App IDs with XXXX and same for something like your app URL. Then we can see if something might be missing from the syntax of the URL. Should be something like the below example.
<html><head><script lang="javascript" src="https://quickbase.com/db/5rh82jcq?a=API_GenResultsTable &ticket=auth_ticket&apptoken=app_token &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 Quick Base table<br>embedded in a<br>page of HTML </td> <td> <script lang="javascript"> qdbWrite(); </script> </td> </tr> </table></body></head></html>
------------------------------
Evan Martinez
Community Marketing Manager
Quick Base
Original Message:
Sent: 11-05-2019 11:45
From: ProjectsForce
Subject: Table Report in HTML
Evan, Thanks for your help sir! I have, I just cannot seem to get it to actually generate and display the report. I think I am missing a step, and since I have not actually seen a working example, trying to trouble shoot to find the issue.
------------------------------
ProjectsForce
Original Message:
Sent: 11-05-2019 10:53
From: Evan Martinez
Subject: Table Report in HTML
Hi Chad,
Have you tried making use of the API for API_GenResultsTable that would be the call that is used to embed a table into an HTML page. The documentation I linked would go over what other parts are needed to make the call. I hope that suggestions is helpful.
------------------------------
Evan Martinez
Community Marketing Manager
Quick Base
Original Message:
Sent: 11-05-2019 10:41
From: ProjectsForce
Subject: Table Report in HTML
Looking to add a table report to an HTML page. I cannot seem to find any examples and have played with the options that are available with no success. If anyone is willing, looking to add a table report to an HTML page.
------------------------------
Chad
------------------------------