creating a pipeline
Hello,
I've followed the various tutorials for creating pipelines, but none seem to fit my needed scenario.
I need a record to move to another table if a field contains a certain selection, and then after that record is moved to the new table I need it to delete from the previously located table.
And - if someone needed to go back and change the record field to move it back to the previous table and delete it again from that table.
Scenario 1) Status is changed > move to the closed records table> Delete the record from the open records table
Scenario 2) Status is changed > move the record from the closed records table to the open records table > delete the record from the closed records.
------------------------------
Lorrie B
------------------------------
I've followed the various tutorials for creating pipelines, but none seem to fit my needed scenario.
I need a record to move to another table if a field contains a certain selection, and then after that record is moved to the new table I need it to delete from the previously located table.
And - if someone needed to go back and change the record field to move it back to the previous table and delete it again from that table.
Scenario 1) Status is changed > move to the closed records table> Delete the record from the open records table
Scenario 2) Status is changed > move the record from the closed records table to the open records table > delete the record from the closed records.
------------------------------
Lorrie B
------------------------------
