Auto calculate a record producers field depending on multiple field values

[kevinbruneau]

Hi everyone,

I need to calculate the Total number of hours depending on multiple fields.

If the agent selects any part-time options through the work schedule field, fields that we're hidden shows up (In this example, I'm using 2 weeks schedule) :

When clicking on any of the checkboxes, 'Number of hours' is displayed. If 'Other' is selected from 'Number of hours', 'Other number of hours' is displayed : 

I need to be able to auto calculate the number of hours for that specific week in the 'Total number of hours'. Ex.: 3h Monday, 6h Tuesday would automatically set to 9h in the Total number of hours field for that week. I tried creating an "onChange" Catalog Client Script, but my only problem is that we need to select a field to trigger the script. In this case, I would need to create a couple OnChange scripts.. Wondering if there are any cleaner solutions for my problem? Any guidance is appreciated !

Thanks!

Kev

[_Gaurav]

Hi @kevinbruneau 
You're on the right way, you have to create multiple onChange client scripts to calculate or just create a BR to calculate everything in a single go.
However for this you need to convince who has given you the requirement.


Please mark this as helpful and accept it as a solution if this works for you.
Thanks!