Mirrored Data got removed together when Data in Source Board got deleted

Platform discussions monday apps & integrations
,
1

Seeking any advice, appreciated. I mirrored a column from Board A to Board B (connected the 2 boards, one way). However when I remove the data from Board A, the mirrored data in Board B also got removed. Try restricting edit for the column in Board B, but issue persist. I need the mirrored data as a reference for Last Used Date, hence need the date to stay in there. Any option using Monday.com’s automation. Many thanks!

2

Hi! Maybe one of these workarounds could work for you?

Possible Workarounds

1. Convert the Mirrored Data to Static Data

  • Goal: Keep a snapshot of the date in Board B even if it’s removed from Board A.
  • How:
    1. Use Monday Automations:
    • Trigger: “When [Date Column in Board A] changes”
    • Action: “Set [Date Column in Board B] to match this date” (requires an actual date column, not a mirror).
    1. This will copy the date into a normal date column on Board B that will remain even if the original is deleted.

2. Use a Formula or Rollup Column

  • Instead of a mirror, consider using a Connected Board + Rollup Column that pulls the last date.
  • Once you have the date in Board B, combine it with an automation to push the value to a static column when changed.

3. Automate a Snapshot to a Static Column

  • Create a separate Date column in Board B called “Last Used Snapshot.”
  • Automation:
    • When [Mirrored Date] changes → set [Last Used Snapshot] to [Mirrored Date].
  • This way, if the mirrored value disappears, the snapshot will remain.

4. Use Integromat/Make or Zapier (Advanced)

  • If Monday’s native automations aren’t flexible enough, tools like Make (formerly Integromat) can:
    • Detect changes in Board A
    • Push that date into a static column in Board B automatically
    • Keep a permanent record even if the original is deleted.
3

Hi Derrick,

This is actually the intended behavior. When you use a mirrored column in monday.com to display data from a source board (Board A) in another board (Board B), the data in the mirrored column is directly linked: if you delete or update the data in the source board, it will also be reflected (or removed) in the mirror column of the connected board. Restricting editing permissions in Board B does not prevent this, as the data is controlled by the source (Board A), not the destination.

Workarounds & Solutions

  1. Sync Mirror Data to a Native Column via Third-Party Apps
  2. Manual Copy/Automation via API or Integrations
  3. Workflow Redesign (If Possible)
4

Thanks Trevor and Kat! I’ve redesigned my workflow by splitting it into two boards. (1) I’ve added and mirrored an additional ‘Last Used’ date column, which automatically updates to today’s date whenever the ‘Check Out’ date changes (and when the ‘Check Out’ date field is not empty). This helps track the latest status. (2) I’ve also set up another automation that creates a new item in a separate board whenever the ‘Check Out’ date changes, capturing a complete activity log for comprehensive tracking when needed. Your suggestions have really helped trigger my logic thinking. Cheers!