JoshWeeman
8 years agoQrew Assistant Captain
Solutions for inserting charts into Exact Forms Plus (Juiced Tech)?
We are using Juiced Tech Exact Forms Plus for our reporting. I am attempting to include QuickBase charts/graphs into these EFP reports, but running into some issues...
There is a Juiced-approved method of streaming a live chart into an Exact Forms Plus report, using a URL call like this: <img src=?https://mysite.quickbase.com/Chart/chart.aspx?realmhost=mysite.quickbase.com&dbid=bheiqafsq&qid=47&generate=image?>
(More info on the Charts tab of this page: https://juicedtech.quickbase.com/db/bknf8jnve?a=dr&r=g&rl=hti )
Unfortunately according to Juiced, in order for this to work, your application has to be open to the Everyone on the Internet role, which won't work for us.
So question number one: Has anyone has found a creative workaround solution for this permission issue with EFP and charts?
My next thought is to render out the live charts to PNG files, upload them to a file attachment field, then have the Exact Form Plus report pull the image file from the attachment field into the report (which is easy to do and has no permission issues associated with it). However that inserts a few manual steps into the process, which I would prefer to avoid.
So question number two: Does anyone know of a creative way to automatically render a chart into a static image (png or jpeg) AND upload it into a file attachment field? Perhaps a script that could run when the record is edited/saved?
Thanks in advance.
There is a Juiced-approved method of streaming a live chart into an Exact Forms Plus report, using a URL call like this: <img src=?https://mysite.quickbase.com/Chart/chart.aspx?realmhost=mysite.quickbase.com&dbid=bheiqafsq&qid=47&generate=image?>
(More info on the Charts tab of this page: https://juicedtech.quickbase.com/db/bknf8jnve?a=dr&r=g&rl=hti )
Unfortunately according to Juiced, in order for this to work, your application has to be open to the Everyone on the Internet role, which won't work for us.
So question number one: Has anyone has found a creative workaround solution for this permission issue with EFP and charts?
My next thought is to render out the live charts to PNG files, upload them to a file attachment field, then have the Exact Form Plus report pull the image file from the attachment field into the report (which is easy to do and has no permission issues associated with it). However that inserts a few manual steps into the process, which I would prefer to avoid.
So question number two: Does anyone know of a creative way to automatically render a chart into a static image (png or jpeg) AND upload it into a file attachment field? Perhaps a script that could run when the record is edited/saved?
Thanks in advance.