Create workflow to add or subtract feild in related entity

[etw5200]

i have a case with a feild i created called time used. In Accounts i have a feild i created called Total Time Used. How can i make a workflow that will take the time i used on a case and subtract ot add to the feild Total Time Used in Accounts?

[etw5200]

any help would be grateful

[tanya]

Hello
I current total in Accounts are correct calculated and you wont delete cases or reassign them to other accounts, it could be possible with Workflow. In other case its better to create a hook

https://www.espocrm.com/documentation/development/hooks/

But if you want to implement it with Workflow, create after saved record action for case.
in condition check if Time Used changed. In Actions - Update Related entity - Account
in formula set something like totalTimeUsed = totalTimeUsed + targetEntity\attribute('timeUsed') - targetEntity\attributeFetched('timeUsed')

[etw5200]

Thank worked! Thanks!