I have a simple form which has one repeat block, which contains unit cost, quantity and total.
I want every time "Unit Cost" or "Quantity" got changed, it will recalculate the total, and also go through all elements in repeats block, and add all the "Total" up and update "Grand Total"
My question is, how to I access each element in the repeat block from a scripting perspective? Is there any examples?
Hey Mike, you can do this using a calculation rule on the Grand Total field of type Script...
In the rule editor right click on the Total field inside the repeat and select Get sum of repeated data:
This should give you what you need.
Did this resolve your issue Mike?