Question Re: AdobeForms - count entries in table (JavaScript) in Technology Q&A

AdobeForms - count entries in table (JavaScript)

former_member246634 — Fri, 25 Jun 2021 13:52:47 GMT

Hi everyone,

How can I count rows in table in SFP using JavaScript code? I am using xfa.resolveNodes function as I've seen somewhere else, but it only returns value "1", even if the table has much more rows.

I know that I can do this by counting rows in interface, but I wanted to do this using JavaScript directly on form's layout. Did I choose wrong event or something? Or maybe I am using wrong path in resolveNodes?

I'd be grateful for all help.

Re: AdobeForms - count entries in table (JavaScript)

Gourab_Dey — Fri, 25 Jun 2021 17:00:42 GMT

Hi Barlomiej,

I have simulated your requirement. Below is the interface, as you can see I have a table "IT_MARA" whose count will be displayed on the adobe form.

Below is the code to find out the count and assign the count to the "TextField1". The code is written using java script in "Initialization" Event of the text box in AdobeForm

 xfa.resolveNode("TextField1").rawValue = xfa.resolveNodes("$record.IT_MARA.DATA[*]").length;

Below is the output. I am passing 30 lines to the table IT_MARA.

Alternate Approach:

As you have already added the field "GV_ITEM_COUNT" to the interface, you can also count the line of the table and assign to GV_ITEM_COUNT in interface itself using ABAP instead of doing it with JavScript.

Hope this answers your questions.

Thanks,
Gourab

Re: AdobeForms - count entries in table (JavaScript)

former_member753791 — Sun, 27 Jun 2021 07:57:08 GMT

First of all change layouts.ready -> Events with script.

Write down the below code.-

xfa.resolveNode("GV_ITEM_COUNT").rawValue = xfa.resolveNodes("$record.IT_PO_ITMEMS.DATA[*]").length

Re: AdobeForms - count entries in table (JavaScript)

former_member246634 — Sun, 27 Jun 2021 17:43:08 GMT

Thank you for your answer. I have made a mistake in my code, it looked like this:

this.rawValue = xfa.resolveNodes("$record.IT_PO_ITEMS[*]").length;

And it should look like this:

this.rawValue = xfa.resolveNodes("$record.IT_PO_ITEMS.DATA[*]").length;

I completely forgot that I am trying to get size of DATA inside IT_PO_ITEMS, not the IT_PO_ITEMS itself... 🙂

Anyway, thank you again for your help!