Forum Discussion

CoreenCoreen's avatar
CoreenCoreen
Qrew Member
9 years ago

Adding a graph or timeline to exact form - getting error

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!!
Forms
Formulas and functions

3 Replies

Sort By
  • ArchiveUser's avatar
    ArchiveUser
    Qrew Captain
    9 years ago
    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
  • JasonJohnson's avatar
    JasonJohnson
    Qrew Assistant Captain
    8 years ago
    Coreen and Daniel,
    Thanks for the information I can now put both charts and summary reports in my forms and in notifications as well!!