Copy Record Options

Modified on Fri, 13 Nov at 8:42 AM

If you often fill out the same record more than once, Copy Record is a simple shortcut. The field values entered on the selected pages or stages are copied into a new record.

Copy Record is available for both single and staged databases, though it behaves slightly differently in each. For both types, you can choose which pages or stages are copied, or let users pick from those pages or stages. You can also exclude specific fields so their values aren't copied, which is useful for information that always needs updating on each record.

Whatever options are enabled, users can still update the copied values before saving.

Note: In staged databases, users are always taken to the first stage when copying a record, whatever options are selected.

Copy Record Settings

Go to your Database Settings page to configure what is copied when users select the Copy Record action. The Copy Record action is only available to users with permission to Create records on the database.

Next to Copy Record Options, click Configure (pictured below).

Copy Record Options setting with the Configure button

A popup opens with the configuration options (pictured below), each explained in the sections that follow.

Copy Record Options popup

Auto-Relate Records

The first setting is Auto-create Related between Original and Copy. When enabled, every copied record automatically gets a Related link between the original record and the copy.

Auto-create Related between original and copy setting

Copy Auto-Created Folder Content

If the Auto-Created Folders feature is set up on your database, you can also copy the content of the original record's auto-created folders. Any items in those folders are copied to the new folder structure once the copied record is published.

To enable it, turn on the toggle under Copy Content of Original Record's Auto-Created Folder(s) to New Folder(s).

Copy auto-created folder content toggle

Copied Pages or Copied Stages

This setting (pictured below) decides which pages or stages are copied when the user clicks Copy Record. If you unselect a page or stage, the fields on it are not copied. In single databases the setting is called Copied Pages (pictured below), and in staged databases it is called Copied Stages.

Copied Pages setting with all pages unselected

Database TypeSelected by Default
SingleAll Pages
StagedStage 1 only
  • Every page or stage selected here is supported by the Copy Record action.
  • If Allow User Selection is enabled, the pages or stages users can choose from are the ones selected here.
Warning: If every option is unselected (as in the screenshot above), the Copy Record action is hidden for all users on that database.

Allow User Selection

Enable this setting to let users (who already have permission to Create or Edit the record) choose which pages or stages to copy after clicking Copy Record. The options they see depend on what is selected in Copied Pages or Copied Stages above.

After clicking Copy Record, the user sees a popup (pictured below) where they can deselect pages or stages. All options are selected by default.

Copy Record popup for choosing Pages or Stages

Excluded Fields

Excluded Fields lets you choose fields that are left out of the copy. When a record is copied, the values in these fields are not copied.

For example, if you exclude the Team Members field pictured below, users need to fill it in again on every copied record.

Excluded Fields setting

  • The list includes every supported field on the pages or stages selected in Copied Pages / Copied Stages.
  • Excluding a field in a duplicable section excludes every instance of that field.
  • An excluded field still appears on the form for the user to fill in, just without the copied value.

These fields can't be excluded, because they are generated automatically or depend on other data:

  • Sequence ID
  • Notes
  • Calculation fields
  • Lookup Grids

Copying Single Database Records

To copy a record in a single database, open the record's actions dropdown menu and select Copy Record. This is a customisable term, so it may appear differently in your platform, such as Copy Project below.

Copy Record in the Record actions menu

A new duplicate record opens, with every value filled in on the selected pages of the original, including attachments in upload fields. You still need to save the record to create it.

Copying Staged Database Records

To copy a record in a staged database, open the record's actions dropdown menu and select Copy Record, just as in a single database (shown above).

A copied staged record always opens at Stage 1, as if the user were creating a new record. If the settings above copy values from other stages, those values only show once that stage is reached with the Continue action. They don't appear anywhere else, such as Data Reports or Dashboards, until that stage is saved.

Note: The terms 'Database' and 'Record' are customisable, so they may appear differently in your platform. See the related terminology.


Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article