Scheduled Pipelines - Suggestions for how to create records daily to archive a table's activity
Hello,
My original goal was to set up an automation for this task and then migrate to pipelines to see if I could follow the logic. It turns out you cannot migrate scheduled automation, which makes sense to me now since there is no trigger just a time and a place.
In any event, my goal is to copy all records of a table (Leasing units table) into another table on a daily basis, in order to capture all changes and adjustments into an archive of all activity.
I'm having trouble setting up the pipeline - I've figured out how to set up the scheduling part, but I'm not sure how to get the fields from the Units table into the Unit Archive/History table.
Does anyone have a suggestion about how to just copy records into another table on a daily basis?
Seems simple enough, so I'm definitely missing some foundational understanding.
Thank you for your suggestions,
Liz
------------------------------
Liz Chartrand
------------------------------
My original goal was to set up an automation for this task and then migrate to pipelines to see if I could follow the logic. It turns out you cannot migrate scheduled automation, which makes sense to me now since there is no trigger just a time and a place.
In any event, my goal is to copy all records of a table (Leasing units table) into another table on a daily basis, in order to capture all changes and adjustments into an archive of all activity.
I'm having trouble setting up the pipeline - I've figured out how to set up the scheduling part, but I'm not sure how to get the fields from the Units table into the Unit Archive/History table.
Does anyone have a suggestion about how to just copy records into another table on a daily basis?
Seems simple enough, so I'm definitely missing some foundational understanding.
Thank you for your suggestions,
Liz
------------------------------
Liz Chartrand
------------------------------
