Forum Discussion

EvanMartinez's avatar
EvanMartinez
Moderator
6 years ago

Re: 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
------------------------------

10 Replies

  • ProjectsForce1's avatar
    ProjectsForce1
    Qrew Trainee
    6 years ago
    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
    ------------------------------
    • EvanMartinez's avatar
      EvanMartinez
      Moderator
      6 years ago
      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
      ------------------------------
      • ProjectsForce1's avatar
        ProjectsForce1
        Qrew Trainee
        6 years ago
        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
        ------------------------------