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.
Table of Contents
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).
A popup opens with the configuration options (pictured below), each explained in the sections that follow.
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.
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).
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.
| Database Type | Selected by Default |
|---|---|
| Single | All Pages |
| Staged | Stage 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.
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.
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.
- 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.
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.
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article