AppSheet supports eight view types:
1. Deck and 2.Table-- views summarize the data as a scrollable list of rows. The Table view shows information in a very compact way allowing you to quickly scroll to find a row. The Deck view shows information about each row in a "deck-of-cards" format including an image. If the data doesn't have an image, you should consider adding a virtual column with a thumbnail image constructed with the formula TEXT_ICON(INITIALS([Column_Of_Type_Name]))
In addition to the image, the Deck view will display two text columns as well as any action buttons for phone numbers or emails. The display columns are chosen in the following order: Row Label, Virtual Columns of type Name, Name type columns, key columns, required columns, normal columns in sheet order.
3. Gallery-- this is the default view of data that has an image or thumbnail image column. The content is shown in a 'summary' view as an image gallery where each image is annotated with the row key. Clicking on any image opens up a full screen 'details' view of the image along with the other row columns. Once in the full screen details view, the user can swipe left or right to move to adjacent rows. This presentation has three sub-options that control the size of the images shown in the summary view:
- Small: appropriate for thumbnail images.
- Medium: fits two images side by side on a phone screen.
- Large: shows large images full-width with a vertical scroll.
As with the List view, you can choose a column to sort the order of presentation of the data. See how the gallery works in our Product Catalog sample app.
4. Slideshow-- this view is used to show details about a record and page left and right through multiple records. This view is automatically used when an item is selected in the Table, Deck, and Gallery view. You can configure this automatic view by creating a UX control of type "slideshow" and position "ref" based on the same data source. The view settings include options such as image presentation, column order, and QuickEdit columns.
QuickEdit makes columns editable directly from the row detail view so they can be updated without editing the full form. To use QuickEdit, the data source of the slideshow view must allow edits. Additionally, some columns will not be eligible such as:
- Key columns
- Columns marked read-only
- Columns computed by AppFormula or sheet formula
- System columns like row number
- "Change"-type columns
- Columns with Editable_If expressions that disallow edits
Some details to keep in mind when using QuickEdit columns:
- They can cause other column values to change through formula dependencies
- Valid_If and Required_If conditions will be applied, and changes that invalidate the row will be rejected
- Each edit is considered a separate row update, and as such, this feature is best used together with the DelayedSync option
5. Map-- this view displays Address and LatLong columns on a map. See how maps work in our Contact Directory sample app.
6. Chart-- we support a number of different chart presentations. In general, charting is a complex topic. As the designer of a chart, you typically have to make three choices:
- How many individual series 'lines' do you draw?
- What values are on the X and Y axes?
- What chart display type do you use?-- line, bar chart, etc.
We have tried to keep it simple by limiting the possible answers for each of these choices:
- Row Series chart-- this is appropriate for spreadsheet data where most of the data is numeric on a uniform scale (eg: monthly sales data). Every row forms a series, each of which is identified by the row key. You choose a subset of the column names that will be charted on the X axis. The Y axis is based on the numeric values in the row cells. You can choose a line chart, a bar chart, or a stacked bar chart as the display type. A good example of a Row Series chart is the 'By Month' view in the Sales Report sample.
- Column Series chart-- this is appropriate for spreadsheet data with just a few rows corresponding to items to compare (eg: monthly sales data by category). Every column forms a series, each of which is identified by the column name. Each row (using its row key column) forms one entry on the X axis. The Y axis is based on the numeric values in the row cells. You can choose a line chart, a bar chart or a stacked bar chart as the display type. A good example of a Column Series chart is the 'By Type' view in the Sales Report sample.
- Histogram-- this is a special kind of bar chart to show aggregate distributions. For example, if you want to see the number of customers who purchased each automobile model, you specify the column whose values will be aggregated. The X axis gets one entry for each unique value in this column and the Y axis shows the count of the number of rows that have that value in that column.
7. Form-- Your apps give you the ability to capture signatures, photos, and location services. You can use AppSheet for Google Forms to both distribute forms through a mobile app as well as use a mobile app to view and interact with form responses. But if you're only using your app to distribute forms, you probably don't want your app showing each user's response, and instead have each new user simply be able to fill out a new form with the app.
To do this, click the UX tab in either editor. In the Editor, click the UX tab, then 'Controls'. From there choose 'form' from the dropdown list of presentation view types under the Action field.
New guests to the form will only be able to fill out a new form and will not see entries made by previous users.
AppSheet also helps you unlock mobile-specific features for your Forms that the web cannot capture. Your apps give you the ability to capture signatures, photos, and location services.
8. Dashboard-- The dashboard view allows you to show multiple other views in one place. Currently Charts, Gallery, Deck, Table, and Slideshow views can be added to the Dashboard.
In addition to choosing which views to include, you can also specify them to be Large or Small. Large views will be twice the size of small views on the grid. On phones, the Large/Small option is ignored.
Note: Since we are constantly improving AppSheet, your views may occasionally be rearranged on the grid.
When you select a row from a table view or you edit a row, you are not taken to any of the top-level views that appear in either the menu or the buttons at the bottom of your app. Instead, you are taken to a Reference View (or Ref View for short). A Ref View is a hidden view that is only used when drilling down into your data or displaying a row via a Ref column.
You define Ref Views by creating a view and setting its position to "Ref". For example, if you create a Slideshow Ref View for your Customers table, you will see that view when you select a customer from a table or deck view, or you click a reference column that refers to a customer record in another table.
If you create a Form Ref View for Customers, that form is used when you edit a customer record.
A new app will not contain any Ref Views. When no Ref View is present for a table, AppSheet will fall back to defaults. You should normally create a Ref View to override these defaults. This allows you to display data in the way you wish. For example, you may have specified a column order in your Table view. By defining a Slideshow Ref View, you can specify its Column Order to match the Table View.