Facility Control

I'm currently trying to work out how to create data tables in dashboard.
The documentation on widgets and parameters is somewhat limited which is causing a lot of confusion in trying to work it out for myself so I need someone to point me in the right direction if possible.

Basically I'm looking to create a table (such as the one attached - borrowed from another post on this forum) but have it statically fixed (10 rows, 16 columns) with data input fields (ie. checkboxes, dropdowns, text input, etc) - values of which initially set via ogscript. I then want a single button below, which executes a piece of ogscript which will loop through all these fields to fetch the set values into variables/arrays. The data will be coming from ogscript events/variables, not XML for what it is worth.

I've been working with a few of the example grids available (in particular XML test) to work this out but even after pulling them apart and trying to replicate the layouts, I just cannot get a table to appear let alone populate.

Any help would be much appreciated since I'm pulling my hair out a bit here.

Hi Daniel.
I'm not sure exactly where you're running into trouble but perhaps try this example and see if it helps you get started.

It creates a table with 10 rows and 16 columns with OIDs "params.cCOLUMN_NUMBER".

When the panel loads, it clears all of the data in the table and leaves it free for the user to type something in or, all of the table data can be generated via script if you click "Init Table".
Clicking "Print Table" gets all of the table's current data and prints it to the debug view.

<abs contexttype="opengear" style="">
   <meta>
      <ogscript handles="onload">for (var col = 0; col &lt; 16; col++)
{
   for (var row = 0; row &lt; 10; row++)
   {
      var value = "";
      params.setValue("params.c" + (col + 1), row, value);
   }
}
</ogscript>
      <params>
         <param access="1" maxlength="0" name="Col 1" oid="params.c1" precision="0" type="STRING_ARRAY" value="TEST [0][0];TEST [0][1];TEST [0][2];TEST [0][3];TEST [0][4];TEST [0][5];TEST [0][6];TEST [0][7];TEST [0][8];TEST [0][9]" widget="default">
            <value>TEST [0][0]</value>
            <value>TEST [0][1]</value>
            <value>TEST [0][2]</value>
            <value>TEST [0][3]</value>
            <value>TEST [0][4]</value>
            <value>TEST [0][5]</value>
            <value>TEST [0][6]</value>
            <value>TEST [0][7]</value>
            <value>TEST [0][8]</value>
            <value>TEST [0][9]</value>
         </param>
         <param access="1" maxlength="0" name="Col 2" oid="params.c2" precision="0" type="STRING_ARRAY" value="TEST [1][0];TEST [1][1];TEST [1][2];TEST [1][3];TEST [1][4];TEST [1][5];TEST [1][6];TEST [1][7];TEST [1][8];TEST [1][9]" widget="default">
            <value>TEST [1][0]</value>
            <value>TEST [1][1]</value>
            <value>TEST [1][2]</value>
            <value>TEST [1][3]</value>
            <value>TEST [1][4]</value>
            <value>TEST [1][5]</value>
            <value>TEST [1][6]</value>
            <value>TEST [1][7]</value>
            <value>TEST [1][8]</value>
            <value>TEST [1][9]</value>
         </param>
         <param access="1" maxlength="0" name="Col 3" oid="params.c3" precision="0" type="STRING_ARRAY" value="TEST [2][0];TEST [2][1];TEST [2][2];TEST [2][3];TEST [2][4];TEST [2][5];TEST [2][6];TEST [2][7];TEST [2][8];TEST [2][9]" widget="default">
            <value>TEST [2][0]</value>
            <value>TEST [2][1]</value>
            <value>TEST [2][2]</value>
            <value>TEST [2][3]</value>
            <value>TEST [2][4]</value>
            <value>TEST [2][5]</value>
            <value>TEST [2][6]</value>
            <value>TEST [2][7]</value>
            <value>TEST [2][8]</value>
            <value>TEST [2][9]</value>
         </param>
         <param access="1" maxlength="0" name="Col 4" oid="params.c4" precision="0" type="STRING_ARRAY" value="TEST [3][0];TEST [3][1];TEST [3][2];TEST [3][3];TEST [3][4];TEST [3][5];TEST [3][6];TEST [3][7];TEST [3][8];TEST [3][9]" widget="default">
            <value>TEST [3][0]</value>
            <value>TEST [3][1]</value>
            <value>TEST [3][2]</value>
            <value>TEST [3][3]</value>
            <value>TEST [3][4]</value>
            <value>TEST [3][5]</value>
            <value>TEST [3][6]</value>
            <value>TEST [3][7]</value>
            <value>TEST [3][8]</value>
            <value>TEST [3][9]</value>
         </param>
         <param access="1" maxlength="0" name="Col 5" oid="params.c5" precision="0" type="STRING_ARRAY" value="TEST [4][0];TEST [4][1];TEST [4][2];TEST [4][3];TEST [4][4];TEST [4][5];TEST [4][6];TEST [4][7];TEST [4][8];TEST [4][9]" widget="default">
            <value>TEST [4][0]</value>
            <value>TEST [4][1]</value>
            <value>TEST [4][2]</value>
            <value>TEST [4][3]</value>
            <value>TEST [4][4]</value>
            <value>TEST [4][5]</value>
            <value>TEST [4][6]</value>
            <value>TEST [4][7]</value>
            <value>TEST [4][8]</value>
            <value>TEST [4][9]</value>
         </param>
         <param access="1" maxlength="0" name="Col 6" oid="params.c6" precision="0" type="STRING_ARRAY" value="TEST [5][0];TEST [5][1];TEST [5][2];TEST [5][3];TEST [5][4];TEST [5][5];TEST [5][6];TEST [5][7];TEST [5][8];TEST [5][9]" widget="default">
            <value>TEST [5][0]</value>
            <value>TEST [5][1]</value>
            <value>TEST [5][2]</value>
            <value>TEST [5][3]</value>
            <value>TEST [5][4]</value>
            <value>TEST [5][5]</value>
            <value>TEST [5][6]</value>
            <value>TEST [5][7]</value>
            <value>TEST [5][8]</value>
            <value>TEST [5][9]</value>
         </param>
         <param access="1" maxlength="0" name="Col 7" oid="params.c7" precision="0" type="STRING_ARRAY" value="TEST [6][0];TEST [6][1];TEST [6][2];TEST [6][3];TEST [6][4];TEST [6][5];TEST [6][6];TEST [6][7];TEST [6][8];TEST [6][9]" widget="default">
            <value>TEST [6][0]</value>
            <value>TEST [6][1]</value>
            <value>TEST [6][2]</value>
            <value>TEST [6][3]</value>
            <value>TEST [6][4]</value>
            <value>TEST [6][5]</value>
            <value>TEST [6][6]</value>
            <value>TEST [6][7]</value>
            <value>TEST [6][8]</value>
            <value>TEST [6][9]</value>
         </param>
         <param access="1" maxlength="0" name="Col 8" oid="params.c8" precision="0" type="STRING_ARRAY" value="TEST [7][0];TEST [7][1];TEST [7][2];TEST [7][3];TEST [7][4];TEST [7][5];TEST [7][6];TEST [7][7];TEST [7][8];TEST [7][9]" widget="default">
            <value>TEST [7][0]</value>
            <value>TEST [7][1]</value>
            <value>TEST [7][2]</value>
            <value>TEST [7][3]</value>
            <value>TEST [7][4]</value>
            <value>TEST [7][5]</value>
            <value>TEST [7][6]</value>
            <value>TEST [7][7]</value>
            <value>TEST [7][8]</value>
            <value>TEST [7][9]</value>
         </param>
         <param access="1" maxlength="0" name="Col 9" oid="params.c9" precision="0" type="STRING_ARRAY" value="TEST [8][0];TEST [8][1];TEST [8][2];TEST [8][3];TEST [8][4];TEST [8][5];TEST [8][6];TEST [8][7];TEST [8][8];TEST [8][9]" widget="default">
            <value>TEST [8][0]</value>
            <value>TEST [8][1]</value>
            <value>TEST [8][2]</value>
            <value>TEST [8][3]</value>
            <value>TEST [8][4]</value>
            <value>TEST [8][5]</value>
            <value>TEST [8][6]</value>
            <value>TEST [8][7]</value>
            <value>TEST [8][8]</value>
            <value>TEST [8][9]</value>
         </param>
         <param access="1" maxlength="0" name="Col 10" oid="params.c10" precision="0" type="STRING_ARRAY" value="TEST [9][0];TEST [9][1];TEST [9][2];TEST [9][3];TEST [9][4];TEST [9][5];TEST [9][6];TEST [9][7];TEST [9][8];TEST [9][9]" widget="default">
            <value>TEST [9][0]</value>
            <value>TEST [9][1]</value>
            <value>TEST [9][2]</value>
            <value>TEST [9][3]</value>
            <value>TEST [9][4]</value>
            <value>TEST [9][5]</value>
            <value>TEST [9][6]</value>
            <value>TEST [9][7]</value>
            <value>TEST [9][8]</value>
            <value>TEST [9][9]</value>
         </param>
         <param access="1" maxlength="0" name="Col 11" oid="params.c11" precision="0" type="STRING_ARRAY" value="TEST [10][0];TEST [10][1];TEST [10][2];TEST [10][3];TEST [10][4];TEST [10][5];TEST [10][6];TEST [10][7];TEST [10][8];TEST [10][9]" widget="default">
            <value>TEST [10][0]</value>
            <value>TEST [10][1]</value>
            <value>TEST [10][2]</value>
            <value>TEST [10][3]</value>
            <value>TEST [10][4]</value>
            <value>TEST [10][5]</value>
            <value>TEST [10][6]</value>
            <value>TEST [10][7]</value>
            <value>TEST [10][8]</value>
            <value>TEST [10][9]</value>
         </param>
         <param access="1" maxlength="0" name="Col 12" oid="params.c12" precision="0" type="STRING_ARRAY" value="TEST [11][0];TEST [11][1];TEST [11][2];TEST [11][3];TEST [11][4];TEST [11][5];TEST [11][6];TEST [11][7];TEST [11][8];TEST [11][9]" widget="default">
            <value>TEST [11][0]</value>
            <value>TEST [11][1]</value>
            <value>TEST [11][2]</value>
            <value>TEST [11][3]</value>
            <value>TEST [11][4]</value>
            <value>TEST [11][5]</value>
            <value>TEST [11][6]</value>
            <value>TEST [11][7]</value>
            <value>TEST [11][8]</value>
            <value>TEST [11][9]</value>
         </param>
         <param access="1" maxlength="0" name="Col 13" oid="params.c13" precision="0" type="STRING_ARRAY" value="TEST [12][0];TEST [12][1];TEST [12][2];TEST [12][3];TEST [12][4];TEST [12][5];TEST [12][6];TEST [12][7];TEST [12][8];TEST [12][9]" widget="default">
            <value>TEST [12][0]</value>
            <value>TEST [12][1]</value>
            <value>TEST [12][2]</value>
            <value>TEST [12][3]</value>
            <value>TEST [12][4]</value>
            <value>TEST [12][5]</value>
            <value>TEST [12][6]</value>
            <value>TEST [12][7]</value>
            <value>TEST [12][8]</value>
            <value>TEST [12][9]</value>
         </param>
         <param access="1" maxlength="0" name="Col 14" oid="params.c14" precision="0" type="STRING_ARRAY" value="TEST [13][0];TEST [13][1];TEST [13][2];TEST [13][3];TEST [13][4];TEST [13][5];TEST [13][6];TEST [13][7];TEST [13][8];TEST [13][9]" widget="default">
            <value>TEST [13][0]</value>
            <value>TEST [13][1]</value>
            <value>TEST [13][2]</value>
            <value>TEST [13][3]</value>
            <value>TEST [13][4]</value>
            <value>TEST [13][5]</value>
            <value>TEST [13][6]</value>
            <value>TEST [13][7]</value>
            <value>TEST [13][8]</value>
            <value>TEST [13][9]</value>
         </param>
         <param access="1" maxlength="0" name="Col 15" oid="params.c15" precision="0" type="STRING_ARRAY" value="TEST [14][0];TEST [14][1];TEST [14][2];TEST [14][3];TEST [14][4];TEST [14][5];TEST [14][6];TEST [14][7];TEST [14][8];TEST [14][9]" widget="default">
            <value>TEST [14][0]</value>
            <value>TEST [14][1]</value>
            <value>TEST [14][2]</value>
            <value>TEST [14][3]</value>
            <value>TEST [14][4]</value>
            <value>TEST [14][5]</value>
            <value>TEST [14][6]</value>
            <value>TEST [14][7]</value>
            <value>TEST [14][8]</value>
            <value>TEST [14][9]</value>
         </param>
         <param access="1" maxlength="0" name="Col 16" oid="params.c16" precision="0" type="STRING_ARRAY" value="TEST [15][0];TEST [15][1];TEST [15][2];TEST [15][3];TEST [15][4];TEST [15][5];TEST [15][6];TEST [15][7];TEST [15][8];TEST [15][9]" widget="default">
            <value>TEST [15][0]</value>
            <value>TEST [15][1]</value>
            <value>TEST [15][2]</value>
            <value>TEST [15][3]</value>
            <value>TEST [15][4]</value>
            <value>TEST [15][5]</value>
            <value>TEST [15][6]</value>
            <value>TEST [15][7]</value>
            <value>TEST [15][8]</value>
            <value>TEST [15][9]</value>
         </param>
         <param access="1" constrainttype="STRING_CHOICE" name="Table" oid="params.table" precision="0" type="INT16" value="-1" widget="table">
            <constraint>params.c1</constraint>
            <constraint>params.c2</constraint>
            <constraint>params.c3</constraint>
            <constraint>params.c4</constraint>
            <constraint>params.c5</constraint>
            <constraint>params.c6</constraint>
            <constraint>params.c7</constraint>
            <constraint>params.c8</constraint>
            <constraint>params.c9</constraint>
            <constraint>params.c10</constraint>
            <constraint>params.c11</constraint>
            <constraint>params.c12</constraint>
            <constraint>params.c13</constraint>
            <constraint>params.c14</constraint>
            <constraint>params.c15</constraint>
            <constraint>params.c16</constraint>
         </param>
      </params>
   </meta>
   <param bottom="59" evenstyle="f:bg#303030;f:fg#FFFFFF;t:bg#selectbg;t:fg#selectfg;" expand="true" left="6" oddstyle="f:bg#161616;f:fg#FFFFFF;t:bg#selectbg;t:fg#selectfg;" oid="params.table" right="6" showlabel="false" style="bdr:etched;bg#dark;fg#panelfg;" top="5">
      <config key="w.rowheight">40</config>
   </param>
   <button bottom="6" buttontype="push" height="51" left="8" name="Init Table" width="231">
      <task tasktype="ogscript">for (var col = 0; col &lt; 16; col++)
{
   for (var row = 0; row &lt; 10; row++)
   {
      var value = "TEST [" + col + "][" + row + "]";
      params.setValue("params.c" + (col + 1), row, value);
   }
}
</task>
   </button>
   <button bottom="4" buttontype="push" height="53" left="244" name="Print Table" right="9">
      <task tasktype="ogscript">for (var col = 0; col &lt; 16; col++)
{
   for (var row = 0; row &lt; 10; row++)
   {
      var value = params.getValue("params.c" + (col + 1), row);
      ogscript.debug(value);
      
   }
}</task>
   </button>
</abs>

#DashBoard

That is perfect and just what I needed.

Thanks so much!!
#DashBoard