Adding a graph or timeline to exact form - getting error

  • 0
  • 2
  • Question
  • Updated 7 months ago
  • Answered
It seems we are able to add pie charts and bar charts to exact forms, but I seem to stuck on timelines and gauges. Does anyone seem to have an answer to this?

~="<img width=500 height=300 src='https://xxx.xxxx.com/Chart/chart.aspx?realmhost=xxx.xxx.com&dbid=xxxxxx&qid=x&generate=image'\/>"~

Is the formula I've been using to add bar charts or pie charts. If anyone has to trick to adding timelines or gauges, please share!!
Photo of Coreen

Coreen

  • 10 Points

Posted 3 years ago

  • 0
  • 2
Photo of Daniel A

Daniel A

  • 40 Points
Hello Coreen,

It could be that if you attempting to size the URL Chart with the image tags, that may cause the error. You can attempt to insert this style of HTML format and just change the Table ID and qid for your specific Chart ID:

Example:

<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>~=qdb.GetURL("bji7iw9jh", "API_GenResultsTable^qid=32^ts=" + new Date().getTime());~</span></p>


The GetURL will go to the Table id (replace with yours) and the API will pull the Table query ID for you display.

Try this, otherwise you may want to try Exact forms Plus! It will be more versatile:
http://quickbase.intuit.com/partners/add-ons/exact-forms-plus

Best,
QuickBase Customer Care
Photo of Jason

Jason

  • 1,406 Points 1k badge 2x thumb
Coreen and Daniel,
Thanks for the information I can now put both charts and summary reports in my forms and in notifications as well!!
Photo of mvelicu

mvelicu

  • 110 Points 100 badge 2x thumb
It doesn't work for graphs. It gives me the error : Unknown report format
(Edited)