Hi All,
Quite a complicated one (for me anyway!).
I have a scenario where there is an ability to perform an action (dig a hole) 50 times a day. I know that I need to do dig 115 holes, taking 3 days. I have a date where these holes need to be dug by, and want to record when I need to start digging holes. I can do this, however what I also would like to record is the Qty on each date so:
Date Required date Days to Dig Holes Needed Quantity
15/12/17 15/12/17 3 115 115
14/12/17 15/12/17 3 115 115
13/12/17 15/12/17 3 115 65
12/12/17 15/12/17 3 115 15
Obviously there will be numerous orders, I have set a record Id for each order and generated extra rows for each date, and made a 'Days to Dig' field. I'm just not sure how to work back and dynamically change the quantity. In the end result I'll be putting this into a chat showing Date and Quantity, with dig times.
Hope it makes sense and that you can help,
Liam
