Forum Discussion

ChrisSipes's avatar
ChrisSipes
Qrew Cadet
6 years ago

Suggestions for how to ""snapshot"" the database

I have an app with several tables which keeps project information throughout the quoting, execution, and closing phases.  I want to get a "snapshot" when a project moves from quoting to execution ...
Tables and fields
AdeebAlgadban's avatar
AdeebAlgadban
Qrew Member
6 years ago
I think if you snapshot the Project table first, it will be better.
In the snapshot, copy the Original Project record id. Then trigger a Copy Record action when a Record is Added in the Project Snapshot by looking up each Record in the Part table based on the Project Record ID.