Substring is not working properly for multiple line items for table in Adobe Live Cycle Designer.

[former_member605610]

Hi,

I am customizing the standard form template of check forms "FIN_FO_PAYM_CHEKC_US_E" in Adobe Live Cycle Designer and I am binding the "ReferenceToPaidDocument" field in the table from the data hierarchy. Now the issue which I am facing that this field gives the value with prefix of Company Code(1710) and Suffix of fiscal year(2018)  eg:  "171019000000572019001" . I need to display only the document number (1900000057) in the table. To get only the document number I have used the "Substring" method,and its working fine for one line item but not for multiple line item. There can be multiple document number in the system. Below are the code which I put for the  "ReferenceToPaidDocument" field.

 Form.tableform.tblRemittance.rowRow1.ReferenceToPaidDocument::ready:layout - (JavaScript, client)

this.rawValue = tableform.tblRemittance.rowRow1.ReferenceToPaidDocument.rawValue.substring(4,14);

When system has multiple line items.

After previewing the attachments.We can notice in the column "Invoice Number" .

Kindly help on above.Thanks in advance. 

Regards,

Shipra