Field 1. FormThirdPartyLogisticsRequest.frmBody.tblMain.rowSetSection.rowMain.colQuantity
Field 2.
I want it to appear in FormThirdPartyLogisticsRequest.frmBody.tblMain.footerRow.TotalQty .
In Field 2. after sub-table configuration
script 2.
sum(rowMain[*].colQuantity)
has been utilized.
However, the current value is output as 0.
Since I can't newly connect Binding in ALD and I have to solve it with the existing linked data, I have no choice but to use Script.
Data related to the value
Field 3.
Looking at the FormThirdPartyLogisticsRequest.frmBody.tblMain.rowSetSection.rowRemarkRow.frmBaseQuantity.decQuantity field, it contains the values I need to sum.
script 3.
if(this.rawValue <> null & this.rawValue <> "")
then
FormThirdPartyLogisticsRequest.frmBody.tblMain.rowSetSection.rowMain.colBaseQuantity.rawValue = FormThirdPartyLogisticsRequest.frmBody.tblMain.rowSetSection.rowRemarkRow.frmBaseQuantity.decQuantity.formattedValue
endif
Field 1 seems to be outputting the value of script 3.
At this time, what script should I use to output the sum of field1 to field2?
Best regards,
Solved! Go to Solution.
Views
Replies
Total Likes
I have checked your form, I added the below script in the mentioned field, and its working.
FormPurchaseOrderConfirmation.PageA.tblTable.footter.GrandTotal::calculate - (FormCalc, client)
this.rawValue = sum(rowTableSection.rowTableItem[*].colQuantity[*]);
var oFields = xfa.resolveNodes("Subform2[*].NumericField4"); var nNodesLength = oFields.length; var nSum = 0; for (var nNodeCount = 0; nNodeCount < nNodesLength; nNodeCount++) { nSum += oFields.item(nNodeCount).rawValue; } TextField1.rawValue = nSum;
You need to use script something like this for repeating table calculation.
Thanks for the related script examples!
But would you please take a look at this before using that example?
I var oFields = xfa.resolveNodes("Subform2[*].NumericField4"); I think xfa() in is not working properly.
Please look at my screen. (simple test)
I think the value "total" should be printed in field 'nd'.
However, the value "Object162098848" is output.
Views
Replies
Total Likes
You are putting the object reference in the field, not its values.
If you can share the forms on google drive (vkatoch07@gmail.com).
I'll have a look.
Thank you again for your comments!
I sent you email.
check plz!
Views
Replies
Total Likes
I have checked your form, I added the below script in the mentioned field, and its working.
FormPurchaseOrderConfirmation.PageA.tblTable.footter.GrandTotal::calculate - (FormCalc, client)
this.rawValue = sum(rowTableSection.rowTableItem[*].colQuantity[*]);
A perfectly working script!
(Let's find out more about how to solve the object reference problem.)
And I also applied it to other forms that have the same table structure as that form.
But it doesn't work.
If possible, can I see my drive again?
* The differences between the two forms are as follows.
Quantity value using Binding function
imported from another subform
Views
Replies
Total Likes
Views
Likes
Replies
Views
Likes
Replies