Skip to main content Skip to complementary content

Creating dynamic views and charts

Dynamic views can be added from the Assets panel in sheet edit mode. You can add dynamic charts from your dynamic views to your sheets.

Dynamic views in the Assets panel when editing a new sheet

Dynamic views in the Assets panel of a new sheet

Creating dynamic views

When you create a dynamic view, you can limit how many rows are brought in as a part of the dynamic view. This can help prevent returning too many rows if your dynamic views are connecting to a very large data set.

  1. In the Edit mode of a sheet, click Dynamic views.
  2. Click Create new.
  3. After Name, enter a name for the view.
  4. After Template app, select a template app.
  5. After Row limit, optionally select to use a Row limit expression and optionally set a Maximum row count.
  6. Click Create.

Adding dynamic charts to sheets

Dynamic charts can be added to sheets from the Assets panel.

If you have editing permissions in the template app, you can edit the master chart upon which the dynamic chart is based.

To edit a dynamic chart, select a dynamic chart while the sheet is in Edit mode and select Edit source app.

Editing dynamic views

You can edit your dynamic views and change your row limits. You cannot change the template app used by a dynamic view.

  1. Select a dynamic view from the dynamic views drop-down.
  2. Click More information and click Edit.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!