Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

Show repeating table data in another subform

Avatar

Level 2

Hi,

I have made a repeating table with 2 fields and a script, but the data will not show up in the other subform:

The table data have to show up in 3 subform floating field areas.

Hope anyone can tell me what's not good or perhaps anyone has a better function.

The script is:

function doeIets() {

//    myOutput('BLAAT');

   

var vItems = form1.sub2aOverheidsorgaan.subTaakWerkzaamheden.dataAanvragers.tableAanvragers.Row1.txtOmschrijvingTaakOverheidsorgaan.all;

    for(i=0; i<vItems.length; i++) {   

   

                // Show the input

                vItems.item(i).sub3InhoudAutorisatie.presence = 'visible';

       

                // Show the output

                form1.sub3InhoudAutorisatie.subInladenTaak.Antwoord.all.item(i).presence = 'visible';   

               

                // Fill the output

                var txtOmschrijvingTaakOverheidsorgaan = vItems.item(i).txtOmschrijvingTaakOverheidsorgaan.rawValue;   

                form1.sub3InhoudAutorisatie.subInladenTaak.Antwoord.all.item(i).fltTaakOmschrijving.rawValue = txtOmschrijvingTaakOverheidsorgaan;

               

                break;

        }

    }

1 Accepted Solution

Avatar

Correct answer by
Level 10

In this scenario it is better to use a more generic function which is usable for multiple tables.

/** generic function to collect data

*   @param oTable:      object          table to take data from

*   @param oOutput:    object          textfield the results are written to

*   @param aCellNames:    array          variable array of field names in oTable to be analysed

**/

function collectData (oTable, oOutput, aCellNames) {

var oRows = oTable.resolveNodes("Row1[*]"),

i, cResult = "";

for (i = 0; i < oRows.length; i += 1) {

cResult += i > 0 ? "\n" : ""; // line break

aCellNames.forEach(function (cellName, iName) {

var oCell = oRows.item(i).resolveNode(cellName);

if (oCell) {

cResult += iName > 0 ? " " : "" // space

cResult += oCell.isNull ? "" : oCell.rawValue;

}

});

}

oOutput.rawValue = cResult;

}

You now call the function with a third parameter from the individual table cells.

EAAFscript.collectData (tableAanvragers, form1.page1.subTaakWerkzaamheden.subInladenTaak.Antwoord.fltTaakOmschrijving, ["txtOmschrijvingTaakOverheidsorgaan", "txtRegelgevingInstellingTaakOverheidsorgaan"]);

The scheme it as follows:

collectData (TableForInput, TextfieldForOutput, ["Field1InTableRow", "Field2InTableRow", …]);

View solution in original post

14 Replies

Avatar

Level 10

Hi,

We might need a bit more, can you share your form so we can have a look (post a link to it in this thread) or maybe add a screen shot of the hierarchy

Regards

Bruce

Avatar

Level 2

Hi Bruce,

Thanks for your reaction:

I cannot submit the form because of confidentional status.

Attached 2 screenshots.

Start subform with table to fill in data

subFormOrigine.PNG

Target subform where data has to come:

subFormTarget.PNG

Please let me know.

Regards,

Ed

Avatar

Level 10

Hi Ed,

Makes it tricky not seeing the whole thing but understand the conventionality stuff.

I don't understand this line;

var vItems = form1.sub2aOverheidsorgaan.subTaakWerkzaamheden.dataAanvragers.tableAanvragers.Row1.txtOm schrijvingTaakOverheidsorgaan.all;

The all property will return all like named objects so I would expect to see

var vItems = form1.sub2aOverheidsorgaan.subTaakWerkzaamheden.dataAanvragers.tableAanvragers.Row1.all;

if you add a line after that one "app.alert(vItems.length)" do you get the number you expect?

Avatar

Level 2

HI Bruce,

Thanks again. The counter does what it has to do.

Now only showing the output.

I will check this out.

Regards,

Ed

Avatar

Level 2

Hi Bruce,

I have checked it and made some corrections.

This is the new script:

function doeIets() {

//    myOutput('BLAAT');

   

                // Taken overheidsorgaan

                var vItems = form1.sub2aOverheidsorgaan.subTaakWerkzaamheden.dataAanvragers.tableAanvragers.Row1.all;

                for(i=0; i<vItems.length; i++) {

                app.alert(vItems.length)    //working

                // Show the input

                vItems.item(i).txtOmschrijvingTaakOverheidsorgaan.presence = 'visible';

               

                // Show the output

                form1.sub3InhoudAutorisatie.subInladenTaak.Antwoord.all.item(i).presence = 'visible';

                // Fill the output

                var txtOmschrijvingTaakOverheidsorgaan = vItems.item(i).txtOmschrijvingTaakOverheidsorgaan.rawValue;       

                form1.sub3InhoudAutorisatie.subInladenTaak.Antwoord.all.item(i).fltTaakOmschrijving.rawValue = txtOmschrijvingTaakOverheidsorgaan;   

                           

                break;

        }

    }

Still showing 1 input:

subFormTargetResult.PNG

I have made an extraction of the form with only 2 sections.

https://www.dropbox.com/s/3ptnzt79g9h1fq8/EAAF_taken.pdf?dl=0

Hope you can see what the issue is.

Regards,

Ed

Avatar

Level 10

Ok,

to collect the data of all rows use this function:

var oRows = oTable.resolveNodes("Row1[*]"),

i, cResult = "";

for (i = 0; i < oRows.length; i += 1) {

cResult += oRows.item(i).txtOmschrijvingTaakOverheidsorgaan.isNull ? "" : oRows.item(i).txtOmschrijvingTaakOverheidsorgaan.rawValue;

cResult += " "; // space

cResult += oRows.item(i).txtRegelgevingInstellingTaakOverheidsorgaan.isNull ? "" : oRows.item(i).txtRegelgevingInstellingTaakOverheidsorgaan.rawValue;

cResult += "\n"; // new line

}

oOutput.rawValue = cResult;

}

Call it from the exit event of you text fields within the table row.

EAAFscript.collectData (tableAanvragers, form1.page1.subTaakWerkzaamheden.subInladenTaak.Antwoord.fltTaakOmschrijving);

Hope this helps.

Avatar

Level 2

Hi Radzmar,

thanks, will check it.

Regards,

Ed

Avatar

Level 2

Hi Radzmar,

I place the function in the variable script and the exitscript on the origin fields.

But no result.

https://www.dropbox.com/s/zaig9rr0g24yrs9/EAAF_taken.pdf?dl=0

Perhaps something I missed.

Regards,

Ed

Avatar

Level 10

Hi Ed,

sorry, the previous script sample was incomplete for some reason. The function has to look this way.

function collectData (oTable, oOutput) {

var oRows = oTable.resolveNodes("Row1[*]"),

     i, cResult = "";

     for (i = 0; i < oRows.length; i += 1) {

          cResult += oRows.item(i).txtOmschrijvingTaakOverheidsorgaan.isNull ? "" : oRows.item(i).txtOmschrijvingTaakOverheidsorgaan.rawValue;

          cResult += " "; // space

          cResult += oRows.item(i).txtRegelgevingInstellingTaakOverheidsorgaan.isNull ? "" : oRows.item(i).txtRegelgevingInstellingTaakOverheidsorgaan.rawValue;

          cResult += "\n"; // new line

     }

     oOutput.rawValue = cResult;

}

Avatar

Level 2

HI Radzmar,

Thanks, this is working.

I now want to use the same function in a similar subform.

I did this with a second functioncollectData2:

function collectData (oTable, oOutput) { 

    var oRows = oTable.resolveNodes("Row1[*]"),  

         i, cResult = "";  

     

         for (i = 0; i < oRows.length; i += 1) { 

              cResult += oRows.item(i).txtOmschrijvingTaakOverheidsorgaan.isNull ? "" : oRows.item(i).txtOmschrijvingTaakOverheidsorgaan.rawValue;

              cResult += " "; // space

              cResult += oRows.item(i).txtRegelgevingInstellingTaakOverheidsorgaan.isNull ? "" : oRows.item(i).txtRegelgevingInstellingTaakOverheidsorgaan.rawValue;

              cResult += " "; // space      

              cResult += "\n"; // new line

         }  

         oOutput.rawValue = cResult;  

    } 

  function collectData2 (oTable, oOutput) { 

    var oRows = oTable.resolveNodes("Row1[*]"),  

         i, cResult = "";  

     

         for (i = 0; i < oRows.length; i += 1) { 

              cResult += oRows.item(i).txtOmschrijvingTaakDerde.isNull ? "" : oRows.item(i).txtOmschrijvingDerde.rawValue;

              cResult += " "; // space      

              cResult += "\n"; // new line

         }  

         oOutput2.rawValue = cResult;  

    }

Can I do this like above written script. Hope you can help me.

Regards,

Ed

Avatar

Level 10

Hi Ed,

what does the second table look like? I need to know its structure to answer this question.

Avatar

Level 2

Hi Radzmar,

The same sort of table with only a change in the field as: txtOmschrijvingTaakDerde.

Regards,

Ed

Avatar

Correct answer by
Level 10

In this scenario it is better to use a more generic function which is usable for multiple tables.

/** generic function to collect data

*   @param oTable:      object          table to take data from

*   @param oOutput:    object          textfield the results are written to

*   @param aCellNames:    array          variable array of field names in oTable to be analysed

**/

function collectData (oTable, oOutput, aCellNames) {

var oRows = oTable.resolveNodes("Row1[*]"),

i, cResult = "";

for (i = 0; i < oRows.length; i += 1) {

cResult += i > 0 ? "\n" : ""; // line break

aCellNames.forEach(function (cellName, iName) {

var oCell = oRows.item(i).resolveNode(cellName);

if (oCell) {

cResult += iName > 0 ? " " : "" // space

cResult += oCell.isNull ? "" : oCell.rawValue;

}

});

}

oOutput.rawValue = cResult;

}

You now call the function with a third parameter from the individual table cells.

EAAFscript.collectData (tableAanvragers, form1.page1.subTaakWerkzaamheden.subInladenTaak.Antwoord.fltTaakOmschrijving, ["txtOmschrijvingTaakOverheidsorgaan", "txtRegelgevingInstellingTaakOverheidsorgaan"]);

The scheme it as follows:

collectData (TableForInput, TextfieldForOutput, ["Field1InTableRow", "Field2InTableRow", …]);

Avatar

Level 2

HI Radzmar,

This function is great and works.

Regards,

Ed