Discussions

Expand all | Collapse all

Solutions for inserting charts into Exact Forms Plus (Juiced Tech)?

Keith Jusas08-29-2018 02:45

  • 1.  Solutions for inserting charts into Exact Forms Plus (Juiced Tech)?

    Posted 03-20-2018 16:57
    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.


  • 2.  RE: Solutions for inserting charts into Exact Forms Plus (Juiced Tech)?

    Top
    Contributor
    Posted 03-20-2018 18:32
    You should be able to do this without generating an explicit file. Using script you can convert the HighChart to a format called a dataURL that represents an image for the chart.

    A dataURL for the QuickBase logo looks like this:

    <img src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAa8AAAB1CAMAAADOZ57OAAAAkFBMVEX///90SJ1yRZxuPplxQ5tsO5htPJlvQJppNZb+/f/08fiDXKfAr9HHuda7p86KZayEYKd9VKPq5PD6+Px6T6LVzODSxt/f1ei0osiQb7Gfhrnm3+2okMD39Pna0OTu6fNnMpWafLetl8TFtdWRcbF6UaGdgLmrlMONaq6wm8aki77MwNrWyuKYeLZeHpCYfLR9bQg2AAAWpElEQVR4nO1d55qrOBK1hUDghFO328Y5x533f7tFuA0SVJWETbt37t3zY775rhshdBQqq1Yri/780lmf97dxeLztz4evy0cUlG7k/3gH+tf1sc4dTwjOmQTnwvEcXu+eP6Pf7hyKxqLfXwx+uxfvRmO0DuueYHUITHj15vRj8dudzGPxcT42e7vhcNcL9+3+L/Zk0FgsZm+bNI3LpOkJDnKVceb2VhsrygYNClV1ejCf9Fwht4G4c4wLl20vM/QLMxR29yD7bYY8QzHRiFrnW9js9brh9tyKgO+b4R+vvDv/ehT9tfxukqxvyri7m46M7Q1uTQrnSqZhsDkWOs397gZuPAjT1w8LU260S3+8KY8H2/SfexesG4OPadP3vs+P+Pjw/N7+kmMlyMYjzBO27qlDYx7bWi2a2JGVrrLb3NDi4JjMegzuyqJXJnw2XajTzO1eoT8Phvzx+mVh2xz5j994qPLVTZ9x23AvZp2mnx88xv3hSaMlCB8N8V2Or46vDIyDzooM85svrMl6zOIjOCZKoz7ZgG943IzBZIlNMebvAXE2GKZ/7wN8pQ/rfKXPeDBfnTo4aerMcb/Uvwsff8V6Ol8bVx0WZFIoiI5L+tDCxqRJr7Eb2So7vrgj9nsO0byoF2XZn+Cr34PZSuA2lW0X4+vTU55YbkyfPTt7z7CVvNjbU3JDf0k+7Rq7RiLaGSQjrzCbfoCvtk+eIrye7SIIXyOmtLBsmT77sqNmqQmiTg36hNxkWdNOEIJhokseIXnCqufr5OXfmu+Em0oPMF+LoUKXfzJ89WLv2UsZcH9uuHC/oA9Fr2PoHdXxnnlTYMPcllg5XwcTXXV3kk5KkK+B+h3e2fDVV/IIsIMY4ifkml5gRaHaFrHUpjclVS/B8pJ9qK/gqvnqGOnyJllTEF/BWBkhxyQyfznPnlwqmLvGTIuNHbl6nYOhgygO2jxjzrA5nkwn3aGjv8+Zak9VzNc1TxfzZLdEJg94qpQK8XVWmhBbgwB2c+vVwN1iJ1GLfoXzpPEoUiUZ5oaf3wOwuOQUMk/TPavla5CbHMI9tub9KJq39/xOg3dT/x7g66SoPMIgL8+ar++F6buGiJw4aJILTDypNI+VfcHpaZzoWzzrqb9Vy5cuTbHlVGmyLdeYThfAV0ulq0tLX9Gwir0w7a1ALPcXeoEtnzL4X5XvdA/5zfigvtL9VH6plC9tjddFU29wNvbcvf6CAl9tZTPkPdqiOqqULnngw7pzMCbfw8dkL2EE26xNF1BYVDGAheqDVfKlLS9nlZ81wS1vYcnzNefZ3mMSvebD18T4IhiD7UtzeoE9Y5WKsiZdUGFZK1uir6zgKvlaqNY2cStKXIP8cZTjq19X6OL0PjOqnK74nXV4hf1DW6XC8m7rTEvgY/DpYJXNfaEwWiVf2iLu2SgmOl+q6IxtTg/0f4AuSRg4SSKD2dds38xhcMxGHZmWkTIWzYzSCvlSOhH/YGFSz/E1CLMpxfgn+eDAwjbwDJAz81yxVaqf9p7vsb85ZO/0s05VyNdC2eYZvMrz0PhaKVu2Y5iy47K+E1uILvS6hsHsW9YqdU2HykM9e8qidrPJXyFfbYUvzC+mI1D4mq2Vx32D3XtdlZpcBGwAO5GKXmmrVHp8sTo+ONl25WTzoUK+puqct9shMr6aZ4UCk0n++nN0xcMA7eSzvF1Ph5gCzxBIBWl8O1Q3RKX5CvlSpChuqfSH2Sgo55Fv2F4WtEnvRbA6tFhaBktKOaV59fhah/jUViq+8X/Sf6yOr8E4G0VhcoJ8NxRCAy/Whsf+qc4KBQHSRGqDJingCGKdAEjd1i4hln2muwjLzKgV8nXMvsiz9LuCfA0ND7WMLgAFSayPDPop8QxkcKi16UmCyw0QrPjK1HQl7qA6vhq9bEyobqgA+XK+yGdUpZoG95z6TsZi72/jnvQRWD4IamHBkbZKHe2++I50P0TiXxJc/yV8GfRPS1Geu862Nc+OosVos2eu3bNiC7zXZJX6sPvkBKk+Jwj3WSZv88y0Vx1fs7A0X+r5pY6kT9g2Ch42EI67h6x6o4NjFTwAavv/0EpzD3gEQ+exubIm/kdf6Q78I/Khat7wjDEydyjyvGbMImyHNnYoh58w037Q2hHBW9ngAyJHRC+wMrFSH+nAerjmts98vD+if62yDd4o4n03pOrLX4qRjjexz2ibVS/urClHzKxTN++KDjT4U8MCs7dK9TNVGJ3Zs0xr8TNh5mf0Zb61M1nr9ihlODDP8sC4vJh7M+lCi7NxiTEGfMCCFhFLWKVm4WNusyE2UopRgGczgeRLkSgt+FLlbG6XvKHxNVMd74ibfWNaXozZbMWXuslcDMr0dKheGatU5k9BI+JWoE2Y5OsCSZQoX33VxW23mev+lL4a/eFBW+oAFigzcKvMiHiphIY9ERQfBvQCKxErle1cmOZ2zd6lSm8KX0UlNxVjdAMTwpe6Piwjy3P+SjUaAJTqr7Qjqi66tlN8sDUYSUCvsSFaj1lbpZQYA9hT2FAG01PXSnaqiYJlOov2FxP1ZYi/UvHYWBro8/EA2oYDSPUrehszxVNp2NNjD5tA6eOzRKxUO5t5fFekedBV3MvaTpNZ/Vgzd+jMsjY1MQbjSw23ga2meRTibVQfGHPy3xHRa4J3y6SLBDe6teLxEONCPyNMGWXZ25WdnYn8zjbSzN8aLUq8cX5D/FK2UHXo0Hgb1cEMDd6sm/ueAl8z1ayaTzIyeKH4rpybd0BbmBzQZl2ZVWquTm7nOFfExOisHuSOfpAr0XVMT5qLsq7pI4fy1dYCbsL88DXGXl0/FYrxh1pchhhrnM+65G5UWI4mNEiDIiv0X2JuMPvSYQwqtGAy7nSnlyjq96PP05apv+TVupnCMz8qv0XKiacfbShfQU8dAJHLhZs3Rbz0NUsPEN97VQdEd1OMyLESljYVBXQkqAsKbpVZpWa63ZoJ1+Us/m8uW97Jyz3qCufNRxj3rKNGY+rCEh7fq8tvTOznjwkwG+2T/Fimmeag+PmOOojapkSminDIRmvCnmoRduJFtCJgJ2clmNv4C9yCs0IzoDK/ee60253JTrWLsqOmhBP5Djf9a7jbnJzacXvTZmoaVzVRMJ9ooi4jVZEjt0N7WVpBg/LNIDFDhlipob3MY3CpJQMIaNOhtgCZcFzX0anP6SIEX7O8q55x4cXtqbnnfkYYyJe+qy7TXSmiPsyz82jnQfs+wdST6qxSpkzUeFhuwFP0sVCXDnL9ASr/K7LwJvqpewDJr9SyXNzHqFGnDcOySwwgk09cWHj4MihuJXrywQx2MTD4p0Mb5RjPLXEyv7JvzkLwUkUPyV/WhLBUaqU2oieXF22QRKKeBnRwQakMvn5oGHswfnVKPcSH+W2Bzl/uNw2mOX9P58PWcjPoIdX3iGEqM6k1NIgFxhBtypDBZwj81xG0GDlcDmhGPeN2OdErvN5QH6CxorZl7rSyYxytv6EmWdadRKqfEY1q5rJyOODDBU/uGPSeXzJWajHhlM8blqOwNGDm3YqHrrFeSgv1CDJ3rGo1KF+DrZaaJHe7ETEPfXs1NQ/Ka4zJnBf6BBOlYqXiLnw1i4nmDyDpZdeeAzzgDDtQTRxjfZvFuQ41x7xmS20vQPnSazok7t5PYpD484UoB4SW4GKZXbShpXwGXzCahkPGY0m6CKRczKCzyxUNZB4/gEbboOk531hi6mH/VHfyzYluK1ecoOl+t+MV5LuR7yhYzqkIW9twYhCElx/1JX4YHGHPLPdgMfpsA7hgsUuDzzPzXc8TMTzP9Y9t7BCfX6/Xj2sC3AofzNdD35XtOXFr7jLsFLeJ+fWBeWGFjK4q5rUzLnfahveAICJCih6mB27VxUq9hMa13TpNp1+tS8k9GMZgdGm1DutW6/J6FdYxvgf5r3R2gctaDN3YIlppeWkC/SEgBO/lK1WcAkJAxKMDDVapFw7UPwVDfHicV9oNcOGB7dCnFrRM/0pdqT8ExGwmgmQtgAcZUMZbg1VKVFbd998Kgq/Q/DQBamvDR71Bh3KAdom/CgRfpXJDCiCiDBhRHOqH6kr9MSD4eqbCTIYvQrGjxFo6y7OkVerPAy5vMDCn3xrU+qL4+qSDIV3rWKk/Ezt8VF9TTwkDB7Uf0g6DeG1Cvsa/CE18aNhLDe8J3ZcMojTkq+TDOf8yHAl9+RXtFE56v2NIKuJb0sjxTFmpPwk3wh71irWLsm+Qqe+GqlIv1jr/14Ow9yKBFnag7IekIk4vL378u5eXkixTABw6bYkNbqggYxqvdE0pKgf7rwDhr3zJIEWYN6js/cBQ1vdvV7/oeIDnRbEBIZVTR5DBvEHkkf8lWBDz+QV/E1U7zMH3NEMNq6fj66pEdDmsjmEYbg+X/i8cpoSBlT1/uBMXpFAJyfQ1Fnb+r+t5qmDd6Vwim+sr+/FjZ2OBk9lmzF3BEwiXjTcF1ST6JFCB7kjJY3AuiQUW1CzA7VwRubos62e1fKHC8VxfhAfjl6zjxxyTiaCdu3WAu4Wr9TpLKLznO8ingvACQkB8/ninUv6JqMaVwbRh9W4oeJ857orWJu/hxbQKE0zuIaBCXnDI75drMH+iL15yPCvgi0yVK52sdwd5OwpeVelqiI+yqyWV8PWIYfO8R5KJAGtJpLgn5dMxc2P5N8wV58soikbtvZdEpHp6enfCF3zTI3cq4Isc2yetqwdq4HFrL23ptU07l3zxzeWOdquz7y3vkb7kHVrfGzh1rUSSmS2YUvV3k0TwuppjV/LFjmMQxypuqSYNCnYFuXMYUS3iNaNNFRgtP1Y24+gX77buV6cQ8cqPlEiiBG2Sliy2msgwW7n5aheSLzCpviqQKk+Z8k0pQnIGYDEzhrIp1rJ8wldOEBsk3jiGByKseF2cZdA/GiESyFAgXihtMfF1Bn+eLzJh7xmRg64vhB6JhmLZhmtfMkB81WqbZOfCjjBZRMgdyaB/dDrd/ajFLJV1bkL/OF/Bljw2SqQO30Hf1ovWLFvQu6G9XR7mK7k6hWMXn8U/xvu0LI/DsNubpFuOqrv9wI/zZSoHVFIJM1zpgdpMDFeQhtYJzAhfM9kvBi9SmXAtJ4QMIkfE16QOpY3H4uf5Mlz+WSyIQzZmuJ0VGMkEI9rtVcIuj/CVWKARl158hDNZ2z9gqPcgqRMhLMyXP88X6bqXhDH7FWa6nRWzzZtuAyuRKoPxJQcSTmWSyU/3yMZTzCmsJM2SSf2/wZepPhsTtndxGS97WyJfYihwuixhl8f4kh45eH1JUeLescUSk7CS9cX+N/giYt2/CeN2lvq2qYwBJm3ODG6vMsnmGF+yEIIPDnisgT52wfh/GVhwIinBahMh8Qa+zPVF687KLE7PpsYq2dgHG2R5y3tj7iD2Q1iblC7AhyQhTWJgpf7kqkWbfIt38DUwl/cQuw0toQWXprEmOmbeMlxWgFdPhoDwFUiVGDQ1x5IpSw3zPYYU/5VTykZKfQdfFvdx15k/pk6x+c2ioDkWiE0WnIpVolJuOIQvWeURzECUOUzZBTnJ05BIn5ShpC7S+cZb+AqgPPbCaPtHTP/42PoWN/M5SCLsyJDjUC5OC+ErnhPw6SlTmDJBQnruYMdNUhbWvNTfwhcVzqTOdJ+diksk6gxt2MKrG1V7dTbM1zpWsRzo9AoY014h1zq4DmfLxEM2NsiI7+GrRl/slI25cL3j1+eoITfyYBZ9dsaOa7M467hl60KrE9iF2xiK9vlYjOh6dQeOQ5COL1XlknW/4HNunuz43F9dqVMs4evnw4JIH0iOM8fh9eFwtxsOuYNUhIHGHboArKbVpoYAVmCnIPkS11GKefuwc4TjnuFRjhe3lumWaO5wZNiVJ+ds/N/9HKVM8uW1PyBUUmzggXWZ+7++PailHoDr6JnqopUvEZe40XgGxxWMjdfI26UdTLclS9UduXwrut0DAphwmusRPP0S/zJcoqXS1JoZ6bV6HZgvw5BiTnvxIYDxG7dWBK+IPc+7auQNXpjbL1Za3PswxZQdW9BUwuM3lPsXq4Ch5vGLQP1oU1pVbpYOqUv4EkoVH1kQiHnuETo+5W3JeeuJ1LRQL9LsMq5/mwWYOwQubMLjN5xX6gUB+PrB+2FRE4WhcC94HwSNJH7j0Mlw7tblKRsrkMXRldzk/Q99l75aqN8Kv2u/MY8XVLUkfiM8AghLXndrguFuwpeAxrHcDOko5T8jkQ/11w2uK6lxiIKEKJ1iRaOLvJKXLu6z2PSWyURj/iq3z75JPpSgK8e/AjSG7ZNe0+4TAUUtD/KJRCtfFgnNDaSMXSkuYemvMMZB9E88OShz4Wzv0r8SjOhknqeBxsqQhX7LX5idAObrzk2OBek0hi79SwLrjGM++EqK2ueOpXfyZWGof4ouNKKXvi/7uXLPGF+J5cLT/NRXJMAmacJC74u6CWGaOvBWvmwMv6Uhxpg7hCxU/2x+DMpXo7DA5OHpAHJ+4FgGZCW397Ke2sR7+TJ4op4BQ2/NNJUCsI+xUYHydde1lM4k5fuG50kBZ1mVhLrEOUViqtYCxd/MF13V+xngQUV9+rh8Mn8a50sWCFZTDqbf5qUikulilV4hl6h2zL6br9raEM1RFnisDH1P3LOVUXC+Ph3tAm5DbTEqr1BvU2P27XzVNhVLidjF6nPD8noyOYDmy8346uQNIapNpG55109fdpUr//B+vmL9o1I9DDm5DVE+pS50UGHNVyLsfCGQJ5hNVNZM/qGa5vcLfNVGQ/Pd1yUAF1g26A5Pl6bE+ZK/ZAJ9cpqhk0ImAcBXX+lYyL7+8vqKe7GtVK7nwEnQoLO9ytvlH8D5SmpLp7usLJiEV4q773NmAVX6DX/5/JIIvqq0TUERM6Zbsp/uOsqXLLmT9UTWPaJOKKld55IsIBOw1Pg1pe53+IqlgV6FS6xYKscQwlbixso8UL6kOJp15CxojUHeQq8XFztBwVFSxtSSGn+Lr9rs5FZnry98AR3C9oxd/gGMr4OrOrmlsYM1iTjUJM1KSbNobH0g+l5m/uoFKn6Nr3gDWVnFPdkgT4DBOfpKIj1inz9K8Sa7hFBGsdEpm1IeylzCH0wAeQQXqZLo0Tm/yFd8mo6rYszXjwKDXR69scMCkP9rvk/2Cjc9aO7ZYKS8nkTMpw21JDMsF37YkaaFnFX6jf4vCKObL6qQPJiWKtc2CBuF7+2PRqN+bR63EZnU6CQ+qpUGJW0653B4j+LyJ+lxJINqTLNCVozOBP5DYvZRr+CO7uVCcin5RHxUjKcsoqUQROehMY/BAuroBHRoFXC56GY1XG1q/5nWGkOT1SGJ33DSqCTP+b4ETChJNkn2gul+mOSIy3T9U2JF4KJ7uERR9Hka369j83OdxeOjXNd/z30Hi1boOOWi1wAoVmz6FgcwhTiQThleD9pDk1kRLAvBvPpEOVTmnk11rMRhlpHcvl/mxoTr+75733V4IUCbqm/z7P2tpTEYncKhh95WZ4WMBtPdvVDwwOwYf+rw0DnsjevLzcUlCc8bhh1NBFi5QvjGDPbRUghHCdBqHOr6TsPdsLBGO/nXqwVuiJstKkf/43SM51O8v/DneEsjdelbiDyQkIQvHnmttYmvdjPUcDx35jl5rSF9XnvzWZL8mXpeLr564j5tmQxtPgIza9MNcaCe259Cf/TZOu3HRBV0HOw7MiWgSwGcwW9K+PJqvcbUxmr+g4gu623Ya4b7zscvSIH/BdYXiCCH2QZ6AAAAAElFTkSuQmCC">




  • 3.  RE: Solutions for inserting charts into Exact Forms Plus (Juiced Tech)?

    Posted 03-20-2018 18:57
    Wow, that is a heck of a URL.

    Can you point me to some instruction on using script to convert my charts to dataURLs?  I will give it a shot.  I'm curious if Exact Forms Plus will play nicely with a dataURL.

    Thanks!


  • 4.  RE: Solutions for inserting charts into Exact Forms Plus (Juiced Tech)?

    Posted 03-21-2018 14:42
    If anyone else has any isight into this one, we'd really appreciate it.  We really need to be able to get charts into our EFP reports (but not at the expense of opening up our app permissions to everyone on the internet).  With all of the people presumably using EFP, I would be surprised if no one else has wrestled with this before. 

    I'm willing to try the dataURL method above, but unfortunately I can't find anything in the pastie database or anywhere else that suggests how to script the conversion of a normal HighChart URL into a dataURL within Quickbase,

    Thanks!


  • 5.  RE: Solutions for inserting charts into Exact Forms Plus (Juiced Tech)?

    Posted 03-21-2018 18:58
    Hi Josh,
      dataURL's currently work in Exact Forms Plus when displaying them in fields in a subtable.  I have to make a small tweek to Exact Forms Plus so that they will work in the Master field section of the template but it will fully work in Exact Forms Plus once I release the minor changes I made.
    See the attached pdf from my testinghttps://juicedtech.quickbase.com/up/bnje52n8u/g/rb/em/va/EFP%20Document_1.pdf


  • 6.  RE: Solutions for inserting charts into Exact Forms Plus (Juiced Tech)?

    Posted 03-21-2018 19:09
    Cool, thanks very much for the reply, Keith.  What's the current ETA on that update you're making?

    In the mean time, I'm still trying to figure out how to convert my HighChart URL into a dataURL.  Any insight on that?

    Thanks!


  • 7.  RE: Solutions for inserting charts into Exact Forms Plus (Juiced Tech)?

    Posted 03-21-2018 19:12
    probably by end of the day tomorrow.  I have a few other changes to implement with this as well


  • 8.  RE: Solutions for inserting charts into Exact Forms Plus (Juiced Tech)?

    Posted 03-21-2018 19:22
    A client of mine in the Biotech industry creates some really cool molecular structure images in dataURL format and they look great in EF+ (but in subtables right now).  I'm not sure what she's using to do the conversions but if you wait a bit Dan may have a solution for you


  • 9.  RE: Solutions for inserting charts into Exact Forms Plus (Juiced Tech)?

    Posted 03-21-2018 19:33
    Thanks Keith.  If you glean any info on that from your client, I'd love to know.  I've never worked with dataURLs, so I have some learning to do there.


  • 10.  RE: Solutions for inserting charts into Exact Forms Plus (Juiced Tech)?

    Posted 03-21-2018 19:39
    She says they use chemdraw but they have to manually upload the converted dataURL endcoding into their quickbase table after they complete their drawing

    it looks like a scripting solution is needed...since you want to generate the dataURL dynamically from a chart report


  • 11.  RE: Solutions for inserting charts into Exact Forms Plus (Juiced Tech)?

    Posted 03-21-2018 21:10
    Ah, I see.  Thanks for inquiring.

    Yes I agree, seems like a scripted method for converting the URL will be required to make this a workable solution.  We'd want the HighChart URL to be converted to a dataURL on the fly as the EFP report is run.


  • 12.  RE: Solutions for inserting charts into Exact Forms Plus (Juiced Tech)?

    Top
    Contributor
    Posted 03-21-2018 21:44
    > if you wait a bit Dan may have a solution for you

    There are multiple ways to to get an image from a chart but I am backed up at the moment. The issue is not really how to do it technically but the workflow and additional storage saving the image will consume and regenerating the image just prior to accessing the exact form.

    @Keith - What is the limitation on EFP needing to be open to everyone on the internet that supports this statement?

    "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."

    I don't understand the computational model of EFP and what authentication is needed. Is the issue that you have to have all data fields statically available when first initiating the generation of an EFP document (in other words there is not JavaScript environment available to dynamically generate the chart). 

    I will probably not look at the dataURL issue till the weekend but feel free to contact me via the information in my profile as you probably have other workflow issues involved that I do not know about:

    https://getsatisfaction.com/people/dandiebolt/">https://getsatisfaction.com/people/dandiebolt/">https://getsatisfaction.com/people/dandiebolt/


  • 13.  RE: Solutions for inserting charts into Exact Forms Plus (Juiced Tech)?

    Posted 03-21-2018 23:37
    Dan and Keith, many thanks in advance for continuing to look into this. I think loads of other EFP customers will be just as excited as I am for any solutions that lead to additional charting capabilities.

    I am more than happy to help test any potential workflows that may come out of the discussion.


  • 14.  RE: Solutions for inserting charts into Exact Forms Plus (Juiced Tech)?

    Top
    Contributor
    Posted 03-23-2018 07:33
    I have a simple script solution that does not use dataURLs (and consequently will not consume storage in your application. My solution does not involve any extra services and can be used with both Exact Forms and Exact Forms Plus from Juiced.

    Feel free to contact me off-world using the information in my profile if you want to pursue this solution:

    https://getsatisfaction.com/people/dandiebolt/">https://getsatisfaction.com/people/dandiebolt/">https://getsatisfaction.com/people/dandiebolt/


  • 15.  RE: Solutions for inserting charts into Exact Forms Plus (Juiced Tech)?

    Posted 08-23-2018 17:02
    I'm bumping this thread 5 months after I originally created it, because sadly we still haven't found a working solution for this.  Despite trying to push this along for many months, none of the solutions mentioned in the posts above have materialized, so we're still in need of a way to insert Quickbase native Highcharts into Exact Forms reports in a reliable and semi-automated fashion.

    If anyone knows of any other options for making this happen, we would love to know about it.  I see this as a sizable gap in QB functionality at the moment, and a huge opportunity for someone to develop an add-on/service that handles this.

    Thanks in advance!


  • 16.  RE: Solutions for inserting charts into Exact Forms Plus (Juiced Tech)?

    Posted 08-23-2018 17:54
    Josh,
    we have another add-on called XL Docs which generates Excel files from your quick base data.  It works very similar to EF+ where you start with an Excel template file and we merge that file with data from your table(s).  We have a lot of clients creating some very complex Excel files using this add-on.  You get the full capabilities of Excel so you can use all of the charting and graphing capabilities as you need.
    Here is a link to our demo app: https://juicedtech.quickbase.com/db/bj446yrpq

    also, here is a link to an output excel file from XL Docs that uses some charts.  It handles multiple worksheets as well
    https://juicedtech.quickbase.com/up/bdhzeparp/g/rgt/eg/vb/Sample%20Excel%20File.xlsx


  • 17.  RE: Solutions for inserting charts into Exact Forms Plus (Juiced Tech)?

    Posted 08-23-2018 18:49
    Thanks for the reply Keith, but Excel doesn't really work for us.  Our reports are varying mixes of graphics, tables, headers/footers, and bodies of text with specific formatting needs, so we need the word-processing and layout power of Word. 

    Do you have any other suggestions, perhaps more progress on the dataURL workflow you mentioned previously?  Above you said you already had at least one client using dataURLs to insert charts into subtable reports, and that you still needed to make some tweaks to get it to work in EFP overall.  What's the current status of that?

    Unfortunately I still have not uncovered an existing or easily scriptable method of encoding a HighChart image to a dataURL on the fly from within QB, so that hurdle still exists.

    Thanks.


  • 18.  RE: Solutions for inserting charts into Exact Forms Plus (Juiced Tech)?

    Posted 08-29-2018 01:45
    I have created a post on the QB user voice platform for this issue.  If you would like to see the ability to save QB charts into image attachment fields, and/or use them in custom report add-ons (like Exact Form Plus), click on the link below and upvote the post.

    https://quickbase.uservoice.com/forums/111823-quick-base-product-feedback/suggestions/35237287-add-a...


  • 19.  RE: Solutions for inserting charts into Exact Forms Plus (Juiced Tech)?

    Posted 08-29-2018 02:45
    sounds good to me Josh