Change the Status field (Data Type Field) automatically after assigned User takes action

Question

Case: I have Process model which has two task assignment nodes. 
 I have a database field called Status --(Dropdown Options: Analysis, Approver, Complete) 
 When the task is added by the admin then Status field should be defaulted to " Analysis " --> Now the task goes to Analyst (when Analyst Submits the task the field should changes to " Approver "--> Lastly, the task goes to Approver (when approver completes the task then the Status field should change to " Complete " 
 
 How can I achieve this?

Pedro Simões · Answer

Hi abhishekw0001 , 
 Just a recap: you have 2 User Input Tasks in your process model: one for "Analysis" and other for "Approver". This approval flow is quite similar to this one ( https://docs.appian.com/suite/help/20.4/Process_Modeling_Tutorial.html ). 
 You just need to make sure that you update the CDT that is mapped to the DB table that contains the Status field (I'm assuming it's a table to contain some process instance data) and then perform a Write to Data Store Entity to update that Status value before the Analysis User Input Task. To update an array see the following https://docs.appian.com/suite/help/20.4/Process_Model_Recipes.html#updating-an-array