View Categories

How Copy/Paste Works

1 min read

This page explains how the Content Tracker handles duplication and large pastes.

Copying Rows #

If you copy an entire row and paste it elsewhere, the system treats that pasted row as a new item.

When a pasted row initializes, the system:

  • Assigns a new ItemID
  • Resets Version to 1
  • Rebuilds system fields (Active, dates, SnapshotPeriod, ChangeNote, ChangeType)
  • Prevents duplicate ItemID + Version pairs

This keeps pasted rows from merging into existing version history.

Bulk Pasting #

Pastes affecting multiple rows or multiple columns trigger extra checks.
These may take a moment, especially in larger sheets.

During a bulk paste, the system:

  • Detects and fixes duplicate ItemID + Version combinations
  • Restores checkbox and dropdown validation
  • Re-enforces protected system fields
  • Re-stamps LastUpdated and SnapshotPeriod when needed

Safe Pasting Tips #

  • Paste plain text when possible
  • Avoid pasting into ItemID, Version, Active, or date columns
  • Don’t paste over system fields unless you want the script to replace them
  • Give the sheet a moment to finish processing before continuing

Fixing Blank or Broken System Fields #

If a pasted row ends up with missing system fields (ItemID, Version, dates, ChangeNote, ChangeType), select those rows and run:

Content Tools → Admin → Generate System Fields for Selected Rows

This safely regenerates all system values without touching your content columns.

Why This Matters #

These safeguards prevent version corruption and ensure each item maintains its own clean history, even after large copy/paste operations.

Shopping Cart