In a list that we use as ticketing tool, I have a field where I have to input my working hours every time.
I'm looking for a way in which I can just input a number in that field but also have another field where all the numbers that I input in the first one are being added.
Following the suggestions in this post, I did the following:
- I've created 1 column called "Nr of hours" as Number column with no other settings. This column is included in my Edit Form where I go to put how many hours I worked on something.
- I've created another column called "TotHours" as Number column with defalut value 0.
- In SPD, I've created a variable called "VarTotHours" as String
Also in SPD, I made a workflow that goes like
Calculate "Nr of hours" plus "TotHours"(output var "VarTotHours") then Set "TotHours" to "VarTotHours"
Set it up to be activated when an item is changed.
Either it doesn't work at all or it multiplies or keeps on adding without sense.
Any idea why?
Thanks in advance.