Is it possible to show a graph or chart while recording data?

I have watched several videos, reviewed a number of apps, and I think Iโ€™m just confusing myself. Is it possible to show a graph or chart while recording data in an AppSheet?

I have an app that records health data into a table. I have another table of months of previously recorded data where, for instance, weight was recorded on several dates. I want to show that history as a bar chart or graph in another window as the nurse enters the field or statically from the time the patient is identified which is the first action in the app. For the history, I have created a slice for just the weight and have sought to use that in a dashboard view, but Iโ€™m guessing this doesnโ€™t work in the fashion Iโ€™m suggesting.

Any help is greatly appreciated!!

0 1 456
  • UX
1 REPLY 1

What you are looking to do is not possible in the Form view.

One solution is to use a detail view with QuickEdit columns instead of a Form view and the chart could be displayed at the bottom as an inline view.

You could use a Dashboard but unfortunately you cannot have a Form view within a dashboard.

If you are using Gsheets, another solution may be to create a chart server side and point to it in the Form (using a Show column) or Detail view but unfortunately it is not trivial to do this. You could look at this, for example: https://developers.google.com/apps-script/reference/charts/

There are more possibilities but I am afraid, they all involve some coding.

Top Labels in this Space