Hi Chad,
So the other part is styling for that example table, I realize I should have taken that out of my example since I was more focused on the formatting for the request. You can instead format your request like this:
<script src="https://xxxxx.quickbase.com/db/xxxxx?act=API_GenResultsTable&apptoken=dr96jzmbvukuwsckbtrzxc9uqt2x&qid=52&jht=1" lang="text/javascript"></script><script lang="text/javascript">qdbWrite();</script>so you would just need to make sure your app token, etc was all set with your URL and instead of building that table below with html use the script snippet at the end there. You would also want to make sure in this instance that you have an everyone on the internet role that is set to view the data you are pulling out to that table since it looks like your request isn't using an Auth ticket. The steps would be:
- Add the Everyone on the Internet to your target application. Make sure it has "view" role permissions to the data you need to display elsewhere. Alternatively, if you don't want to open your application to everyone in the world you would have to utilize the API_Authenticate command whenever you query your database.
- Create a token in your target application
- Create a report in your target application and select the appropriate filter, sorting & grouping, and columns to display section you would like to appear in your report. Save this report and mentally or physically note the qid generated.
- Paste that code into the site you need your embedded report to appear
- Replace the DBID (currently xxxxxx) with your table ID, the report ID (currently 52) with your report ID, and your application token with the token you just created.
Important: If your code is in a website other than on quickbase.com, make sure to include before your table ID.
------------------------------
Evan Martinez
Community Marketing Manager
Quick Base
------------------------------