Page Duplication

Using the hidden formula DuplicatePage() is is relatively simple to make one or more copies of an existing (template) section.

DuplicatePage(page, name, duplicateOptions, rowOptions?)

From the hidden formula’s documentation:

REQUIRED INPUTS

page: The page that will be duplicated

name: Name for the new page

OPTIONAL INPUTS

duplicateOptions: Behavior when the page has tables and views. If set to "CreateViews", edits to data in the new page will show up in the original tables too. If set to "DuplicateData", edits to data in the new page won't affect the rest of your doc. If set to "DuplicateTables", edits to views in the new page will show up in the original table, and other edits won't affect the rest of your doc. Defaults to "CreateViews".

rowOptions: This parameter is used to specify which rows should be included. It should be one of - All, Visible, None. If set to `All`, all rows including those hidden by a view will be included. If set to `Visible`, only visible rows will be included. If set to `None`, none of the rows will be included.

OUTPUT

Outputs an action (when run) which will create a duplicate page of pagewith the given name.

Single Copy

Create a Template page to duplicate:

Template⁠

⁠

Duplicate the page:

Duplicate [Template]

⁠

Multiple Copies

Using the same template page:

Template⁠

⁠

Specify how many copies to make:

How many copies:

There are no rows in this table

⁠

Make the specified number of copies:

Make Multiple Copies of [Template]

⁠

In case things get out of hand:

STOP

⁠

Reset

⁠

Helper Button

Make Multiple Copies (Helper)

⁠

Want to print your doc?
This is not the way.

Try clicking the ⋯ next to your doc name or using a keyboard shortcut (

CtrlP

) instead.