Hy there,
I needed some kind of sparkline for an application and decided to use SVG image to get it.
I don’t know if it will be the best way, or if anyone has a better solution.
To create the image I used a formula in Gsheet:
Earlier @Jonathon had shared some interesting charting possibilities with SVG. Now you have further extended it by adding Google Chart APIs. Thank you both for sharing these interesting charting possibilities insights.
I am still learning how to work with Appsheet and have realized that there are so many possibilities that we ended up doing more than we initially anticipated.
The possibility exists, getting it is more difficult.
That’s really really neat… Do you think if the whole community starts using it, we could rate limit since all the calls would be coming through appsheet? Regardless it’s even cheap to host if that’s an issue… Really cool find!
“There is a built-in rate limit of 240 charts/min (4 charts/sec) per IP.”
That’s a smart workaround! Using SVG directly inside a data URI is a clever way to build sparklines when AppSheet doesn’t provide them natively. Even if it’s not the “perfect” method, it definitely opens the door to lightweight, customizable visuals.
If you’re looking to refine it further, you might explore:
Using CONCATENATE() with AppSheet variables to make the SVG dynamic.
Running the SVG through an optimizer (like SVGO) to keep the string shorter and easier to manage.
Adjusting stroke, fill, and scaling so the sparkline adapts to different values more smoothly.
Either way, your example already shows how flexible SVGs can be in AppSheet. Thanks for sharing — it’s inspiring for others who need creative visualization options.