How to update field through workflow?

[Ankit Kashyap]

I have created a table in which user can change their department by entering their present department and new department.

I have a requirement that when user submit the request then their manager's approval will be trigered and after  the manager's approval their department will be changed and auto updated in sys_user table.

Here is the table 

[Ankur Bawiskar]

Hi Ankit,

you can use set value activity to set value from workflow

Mark Correct if this solves your issue and also mark Helpful if you find my response worthy based on the impact.
Thanks
Ankur

[Ankit Kashyap]

Hi Ankur ,

could you please explain me how can i achieve that and is it possible to update other table's field using set values activity in workflow.

Thanks 

Ankit

[Vijayata Manche]

Hi Ankit,

To update values in other table you can make use of 'run script' avctivity.

Thanks,

vm1104

[Ankur Bawiskar]

Hi Ankit,

You can only use set value activity of workflow to set current table's field and not other.

for other table you need to query and update

Mark Correct if this solves your issue and also mark Helpful if you find my response worthy based on the impact.
Thanks
Ankur