Using QuickChart in AppSheet

Audience: Beginner

QuickChart.io is a web service that generates static images of charts and QR codes on-the-fly via simple URL-based APIs in embeddable image files (PNG, SVG, PDF, WEBP).

What it’s used for:

  1. Embeddable Visuals: Adding dynamic charts to formats that don’t support JavaScript, such as emails, SMS, chatbots, and PDF reports.
  2. No-Code Integrations: Powering dashboards in tools like AppSheet and Google Sheets using basic image formulas.
  3. Automated QR Codes: Generating scannable codes for WiFi access, payments, locations, and app store links.
  4. Custom Graphics: Creating “smart” images like progress gauges, sparklines, word clouds, and data-driven social media thumbnails.

For exploring various different charts, check out Chart Gallery, Chart Types and QuickChart Documentation.

Note: Charts generated by QuickChart’s free version are public domain and hosted on a large cluster of redundant servers. There is a built-in rate limit of 60 charts/min (1 chart/sec) and 1,000 charts/month for free users.

How to use it:

  1. Create your chart API endpoint in QuickChart’s ChartMaker tool

    1. Visit ChartMaker: quickchart.io/chart-maker/

    2. In the Chart Assistant, create your chart by entering a prompt,
      for example: ‘Horizontal bar chart of top 10 performing employees by sales’, and clicking Generate.

    3. After the chart is generated, you can also modify it.

  1. After the chart is modified, click Save as API Template.

  2. In the subsequent dialog, copy or save your new chart’s API endpoint.

  3. Adding your Chart to an AppSheet app

  4. Create a ‘Blank app’ and add a new Image column to the table - or - Use an existing app with an Image column in a table.

  5. In the Table editor (Data > Table Name), click the pencil icon image of the image column to edit the column settings.

  6. Under the Auto Compute section, enter your chart’s API endpoint into the App formula field.

Important: Surround the formula expression in double quotes.

  1. Testing your chart in your AppSheet app

  2. Add a new record into your app, notice that the Image column will be auto-computed when a new record is created.

Other Examples:

  1. Visit ChartMaker: quickchart.io/chart-maker/

  2. In the Chart Assistant, create a Radar chart by entering a prompt: ‘Radar chart with 5 labels as Jan, Feb, March, April, May. Have data values for dataset 1 as [50, 60, 70, 180, 190] and for dataset 2 as [100, 200, 300, 400, 500]’, and clicking Generate.

  1. After the chart is generated, you can also modify it.

  1. After the chart is modified, click Save as API Template.

  1. In the subsequent dialog, copy or save your new chart’s API endpoint.

Additional Materials:

To leverage the existing knowledge already shared within the community, please refer to the following resources for further technical depth and implementation examples:

  1. External Template: Explore this Sample App to see pre-configured logic for dynamic line charts.

  2. Community Mention: Review the primary discussion thread on Using QuickChart in your apps on the community platform to explore various use cases.

5 Likes

Thanks for citing this post of mine! I hope this new post of yours will encourage others to take the QuickChart plunge. :slight_smile:

7 Likes

Is this AppSheet’s way of telling us not to expect improvements to the built-in charting features?

12 Likes

Yes it does feel like this is the message, here’s a workaround to the incomplete charts in our own platform…

Interactive charts are supposed to be the correct thing to do and keep up with competitors.

3 Likes

You might find the following video helpful:

Here are some additional live streams from back in the day where I expand the first integration into differnt charts:

5 Likes