Hello,
I want to book hours in a Sharepoint list for tasks. Behind the hours is an hourly rate. So I can calculate the costs of each task.
This hourly rate may be changed in the future.
My question:
I book 10 hours today for 'task a'. The hourly rate for the employee is 50 $ per hours. So task a costs 500 $. Tomorrow the hourly rate will be changed to 60 $. The costs of 'task a' in my SharePoint list must be still 500 $. If I book 10 hours for 'task b' tomorrow, then I get 600 $ costs for this task.
My idea: 'list one' for the tasks, 'list two' for the hourly rates. Every time I create a new task in 'list one' a workflow copies the actual hourly rate value from 'list two' to a field in 'list one'.
Can this be realized with Nintex Workflow? If so, can you give me some hints how this can be done?
Thanks a lot.
panc
