Skip to main content
January 13, 2021
Question

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

  • January 13, 2021
  • 1 reply
  • 0 views

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?

1 reply

pedro.simoes
January 14, 2021

Hi [mention:cb641242762d45d9b02e6c6bb323c684:e9ed411860ed4f2ba0265705b8793d05],

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