Update Manager name in CVOC object When Change in the User Object Automatically

[msonu719]

Hi team,

I have a field in the CVOC object with the name manger1 so i want it to be update automatically when change in the manager name in User Object.

[lazovic]

Hi msonu719,

Please tell me what relationships are set between CVOC and User entities? You can check it in the Administration > Entity Manager > CVOC > Relationships.

[msonu719]

In CVOC i have created a field team member 1 with lookup field on that bases i write the formula to get the data in the manager1 field the formula is

manager1 = teamMember1.cManagerNameName;

From this I get the manager name but when i change manager name in the User but it will not update in CVOC object automatically whenever i refresh the page or directly reflect in the CVOC object.

[lazovic]

msonu719,

You need to use a formula script for the User entity. E.g., when a certain field is User record changes, you need to update the field in the related CVOC record:

if (entity\isAttributeChanged('username') {
  record\update('CVOC', cvocId, 'manager1', username)
}