Display a sheet

Hi there

Is it possible to display a sheet in a view. I have an existing sheet with entries which updates total in a formatted sheet and would like it displayed. Thanks for any help.

Nope.

Steve is right that there is no view that shows a sheet. If what you need is to see the formatted totals inside the app, there is a workaround that I tested tonight: show the totals as a live picture.

  1. In the sheet, select your totals range and use Insert > Chart, then change the chart type to Table chart.
  2. File > Share > Publish to web. In the first box pick the chart (not Entire document) and in the second pick Image.
  3. Before you press Publish, open “Published content & settings” in the same box. Untick Entire document and tick only the chart. Leave “Automatically republish” ticked. If you skip this, the whole spreadsheet goes public.
  4. Copy the link it gives you into a cell in one of your app’s tables, like this, so the app does not keep showing an old copy:
="PASTE-THE-LINK-HERE"&"&t="&TEXT(NOW(),"yyyymmddhhmm")
  1. In AppSheet, regenerate that table and set the new column’s type to Image.

What I saw in my test: the table showed in the detail view, and when I changed a number in the sheet the picture in the app followed it after a sync. It is not instant. The published picture took between 2 and 5 minutes to catch up.

The limits: it is a picture, so you cannot tap or scroll it and the text is small on a phone. And the chart is public to anyone who has the link, so only chart numbers you are happy to have out there.