After searching for a few days and not finding a solution I figured I'd try you all for some greatly appreciated help..
We have a Server Request InfoPath form that has a repeating table. When users request a new server we ask them to enter the amount of Ram, Disk Space, CPU's and the OS they need.
When they enter their values into each field we calculate the cost amount for each item( Ram, disk, cpu and OS) through data connections to the price per item stored elsewhere.
So as an example: when the user enters the amount of Ram to the "RAM" field, we have this Rule running in the Ram field to set the "CostRam" field that is outside of the repeating table( where "." is the "ram" field in
the repeating table)
. * Cost[Title = "RAM" and Category = ResourceType] this same formula is used for CPU, Disk, and OS
Right now we have a Total field in the repeating table , with the formula CostRAM + CostDisk + CostCPU + CostOS for the default value and it works fine .. until we try to add a row to the repeating table.
Adding a 2nd row carries over the previous value for the total column and changes to any item ( Ram, Disk, OS, CPU) on the 2nd row changes the Total column for both rows.
I'm trying to figure out a way to keep the first row cost total displayed and stored and then when the next row is entered, reset the Cost fields back to zero to recalculate the next added resource so that when they fill in all rows, the total cost field in
the footer of the repeating table displays the overall cost for all resources requested.
Thanks for your help,
Shane
- Edited by shanemeisner 22 hours 15 minutes ago add text