Export entries to another table

931 2
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

My table consists of customer orders. Once the order has been completed, I would like to move the entry to out of my working table to another that is only completed orders. How can I set up the table to do this?

Thanks for your help!

2 Replies 2

Have you considered doing this with Views? You could use one table, and have three views set up using filters: All Orders, Completed Orders, and Orders In-Progress.

Generally, we don’t recommend using two tables to house the same type of data (in this case: orders).

Thank you! That helps a lot.