I am working to build a ticketing system app. Few columns which are important are UID(unique id for ticket), parent UID(parent uid if the ticket has a root), Assign To , Reassign(yes,no) .
I have a action which executes the group of statements : 1.sets reassign to yes 2.copies the current row and edits it 3. closes ticket
I am wondering if there is a way in the 2nd step to copy row and store the previous row details .Like in my case I want to have the previous rows uid to be set as current rows parent uid . Is there a way this can be achieved ?