I am working in the Customer Invoice form template where my table(Dynamic) is overflowing even though I have wrapped my table in a sub-form and made the allow page breaks true in the necessary locations. When the data is large, the table is getting started on the second page, making the first-page b...
Hi Mayank, Yes, there are two totals in the table one for Original Amount and the other one for Remaining Amount.I need to remove the direst binding as I need to do the same calculation for the other one as well. Thanks.
@Mayank_Tiwari, Yes, it is automatically changing to rawvalue even when I give rawValue. I don't know why this is happening. Here is the link for the XML file,https://drive.google.com/file/d/1wdckbXpFK7LEXtxl4SgAABqfYtOO4MC_/view?usp=sharing
@Mayank_Tiwari , That's a typo, but still, it doesn't work. I have tried your script, as stated above, but that is not working on my form. Please have a look at my form.https://drive.google.com/file/d/1D_eJKfWe_elQ9N_lS0WQTF78qzCTPKjS/view?usp=sharing Let me know if am missing any.
Hi Mayank, I have used the below script, could you please let me know if I am making anything wrong here,var oRows = xfa.resolveNode("tblOpenItemTable.rowFooterRow[*]");iTotal = 0;for(var i=0; i<oRows.length; i++){if(tblOpenItemTable.rowOpenItems(i).colID_18448.rawValue == "Customer Invoice"){iTotal...
Hi Mayank, Thanks for the update. The table is already repeatable. All I need is a script to calculate the totals based on the document type. I would rather say it as conditional Sum. Thanks.
I have a requirement as below.The table has one header and two rows, one row is for repeating the Items in the transactions, and the other one is to display the total.There is a field called Document Type, and when the value of this field is "Customer Invoice" and "credit Memo," then the total shou...