Improve the presentation of detail and form views using Show
types as described in this section.
- What are Show types?
- Use a virtual column as a Show type column
- Use an empty column in your spreadsheet as a Show type column
- Configure the column as a Show type
For examples using Show
types:
- Create multi-page forms
- Create multi-page forms with conditional branching
- Configure card blocks in detail views for the new desktop layout
What are Show types?
Show
types correspond to table columns whose sole purpose is to improve the presentation of data in forms and detail views.
Show
type columns are only permitted in form views. To include Show
type columns in detail views, enable Include Show columns in detail viewson the UX > Optionspane in the Detail Viewsection.
There are six categories of Show
types that you can create based on the improvements you want to make, as summarized in the following table.
Category
Description
Page_Header
Creates a new page. For an example, see:
- Form view: Create multi-page forms
- Detail view: Configure card blocks in detail views for the new desktop layout
Section_Header
Creates a new section within the same page.
Text
Displays a description.
URL
Displays a clickable URL.
Image
Displays a static image that is not stored in your table.
Video
Displays an MP4 video.
There are two ways that you can implement Show
type columns:
- Use a virtual column in a table as a Show type column
- Use an empty column in a spreadsheet as a Show type column
Use a virtual column as a Show type column
To use a virtual column as a Show type column:
- Add a virtual column to the table .
- Set App formulato ""(empty value). This value is not applicable for
Show
type columns and will be ignored. However, it's a required field when configuring a virtual column, so you need to set it to some value. - Select Show in the Type drop-down for the virtual column.
- Click Edit to view the full set of properties for a specific column.
- Configure the column as a Show type
and click Done.
For example: - Create the detail
or form
view.
Explicitly include theShow
column in your view. See Control the order of the virtual column . - If you are using the Show column in a detail view, enable Include Show columns in detail viewson the UX > Optionspane in the Detail Viewsection.
- Save your changes by selecting one of the following:
- Save - Save the app.
- Save & verify data - Save the app and verify that it is runnable based on external dependencies.
Use an empty column in your spreadsheet as a Show type column
To use an empty column in your spreadsheet as a Show
type column:
- Open your source spreadsheet for the table and insert one or more empty columns.
For example, the following example shows a column structure for a Contact Us form. Columns
Page 1
,Page 2
, andPage 3
designate the empty columns that will be set as page breaks in the form.Note:- You will configure the empty column as a
Show
type column in the app editor. - You can enter a header name for the empty column, if desired, such as
Page 1
. If the header column is left blank, a default name will be added to the table using the following format:Column_ n
, wheren
indicates its position in relation to the visible columns. The column name is visible only to the app creator; it will not be visible in the app.
- You will configure the empty column as a
- Open the app in the app editor.
- Go to Data and select the table you want to edit in the list. We've made some improvements to the app editor .
You are opted in to the new editorby default, but you can switch back to the legacy editor at any time.If you are using the legacy editor
Go to Data > Columnsand expand the table you want to edit. - Perform one of the following steps:
- Add a new table using the spreadsheet updated in Step 1.
- For an existing table, regenerate the table schema . The empty column now appears in the table.
- Select Showin the Typedrop-down for the empty column.
- Click the edit (pencil) iconassociated with the column.
- Configure the column as a Show type
and click Done.
If you want to display a heading on the new page, enter it in the Contentfield. Otherwise, to just create a page break, leave the Contentfield blank.For example:
- Create the detail
or form
view.
Include theShow
column in your view. To reorder the columns, see Control column order . - If you are using the
Show
type column in a detail view, enable Include Show columns in detail viewson the UX > Optionspane in the Detail Viewsection. - Save your changes by selecting one of the following:
- Save - Save the app.
- Save & verify data - Save the app and verify that it is runnable based on external dependencies.
Configure the column as a Show type
To configure the column as a Show
type column..
Property |
Description |
Column name |
Name of the column. |
App formula |
Note: Displayed for virtual columns only; not displayed for empty table columns. Set to: "" (empty) Since a |
Show? |
Enable this toggle. |
Type |
Set to Show. |
Category |
Select one of the categories from the drop-down based on the information you want to display. |
Content |
Enter the content to display for the |
Show
type columns.