1 Reply Latest reply on Apr 7, 2011 2:46 PM by George_Johnson

    rawValue to a table to give rawValue to another from table

    williamegiii@yahoo.com

      Sir,

       

      What I am trying to do is take the rawValue from TotalPoints and refer to the Table.cell 3 Values and go to Tabel1.cell1 vor a value that will fill the RiskFactor rawValue.  I have tried different scripts but to no avail.   Can you help please.    Below is the layout of the tabel and RiskFactor as well as the Total Points .

       

      simple    if TotalPoints.rawValue  = <30  == Table1.row1.cell3   than RiskFactor.rawValue = Table1.row1.cell1

                     if TotalPoints.rawValue  = 31 thru 60 ==  Table1.row2.cell3   than RiskFactor.rawValue = Table1.row2.cell1

       

      and so on.

       

      Can someone help with this problem I am drawing a blank on?

       

      Thank You

      Bill Grant

      williamegiii@yahoo.com

       

      <subform xmlns="http://www.xfa.org/schema/xfa-template/2.6/" name="Table1" layout="table" columnWidths="24.6632mm 86.4576mm 23.4201mm">
         <border>
            <edge/>
         </border>
         <subform layout="row" name="HeaderRow" id="HeaderRow_ID_copy1_copy1_copy1">
            <assist role="TH"/>
            <draw w="30mm" h="5.9177mm" name="Cell1">
               <border>
                  <edge/>
                  <corner thickness="0.1778mm"/>
               </border>
               <ui>
                  <textEdit/>
               </ui>
               <value>
                  <text>Risk Factor</text>
               </value>
               <font typeface="Myriad Pro" weight="bold" baselineShift="0pt"/>
               <margin topInset="0.5mm" bottomInset="0.5mm" leftInset="0.5mm" rightInset="0.5mm"/>
               <para vAlign="middle" hAlign="center" spaceAbove="0pt" spaceBelow="0pt" textIndent="0pt" marginLeft="0pt" marginRight="0pt"/>
            </draw>
            <draw w="30mm" h="5.9177mm" name="Cell2">
               <border>
                  <edge/>
                  <corner thickness="0.1778mm"/>
               </border>
               <ui>
                  <textEdit/>
               </ui>
               <value>
                  <text>Conditions</text>
               </value>
               <font typeface="Myriad Pro" weight="bold" baselineShift="0pt"/>
               <margin topInset="0.5mm" bottomInset="0.5mm" leftInset="0.5mm" rightInset="0.5mm"/>
               <para vAlign="middle" hAlign="center" spaceAbove="0pt" spaceBelow="0pt" textIndent="0pt" marginLeft="0pt" marginRight="0pt"/>
            </draw>
            <draw w="30mm" h="5.9177mm" name="Cell3">
               <border>
                  <edge/>
                  <corner thickness="0.1778mm"/>
               </border>
               <ui>
                  <textEdit/>
               </ui>
               <value>
                  <text>Point Range</text>
               </value>
               <font typeface="Myriad Pro" weight="bold" baselineShift="0pt"/>
               <margin topInset="0.5mm" bottomInset="0.5mm" leftInset="0.5mm" rightInset="0.5mm"/>
               <para vAlign="middle" hAlign="center" spaceAbove="0pt" spaceBelow="0pt" textIndent="0pt" marginLeft="0pt" marginRight="0pt"/>
            </draw>
            <border>
               <edge presence="hidden"/>
            </border>
            <occur max="-1"/>
            <?templateDesigner expand 1?></subform>
         <subform layout="row" name="Row1">
            <assist role="TR"/>
            <draw w="30mm" h="5.9177mm" name="Cell1">
               <border>
                  <edge/>
                  <corner thickness="0.1778mm"/>
               </border>
               <ui>
                  <textEdit/>
               </ui>
               <value>
                  <text>  1          Lowest</text>
               </value>
               <font typeface="Myriad Pro" baselineShift="0pt"/>
               <margin topInset="0.5mm" bottomInset="0.5mm" leftInset="0.5mm" rightInset="0.5mm"/>
               <para vAlign="middle" spaceAbove="0pt" spaceBelow="0pt" textIndent="0pt" marginLeft="0pt" marginRight="0pt"/>
            </draw>
            <draw w="30mm" h="5.9177mm" name="Cell2">
               <border>
                  <edge/>
                  <corner thickness="0.1778mm"/>
                  <fill>
                     <color value="51,153,102"/>
                  </fill>
               </border>
               <ui>
                  <textEdit/>
               </ui>
               <value>
                  <text>Normal Operations</text>
               </value>
               <font typeface="Myriad Pro"/>
               <margin topInset="0.5mm" bottomInset="0.5mm" leftInset="0.5mm" rightInset="0.5mm"/>
               <para vAlign="middle" hAlign="center"/>
            </draw>
            <draw w="30mm" h="5.9177mm" name="Cell3">
               <border>
                  <edge/>
                  <corner thickness="0.1778mm"/>
               </border>
               <ui>
                  <textEdit/>
               </ui>
               <value>
                  <text>  0   -   30</text>
               </value>
               <font typeface="Myriad Pro"/>
               <margin topInset="0.5mm" bottomInset="0.5mm" leftInset="0.5mm" rightInset="0.5mm"/>
               <para vAlign="middle" hAlign="center"/>
            </draw>
            <border>
               <edge presence="hidden"/>
            </border>
            <?templateDesigner expand 1?></subform>
         <subform layout="row" name="Row2">
            <assist role="TR"/>
            <draw w="30mm" h="5.9177mm" name="Cell1">
               <border>
                  <edge/>
                  <corner thickness="0.1778mm"/>
               </border>
               <ui>
                  <textEdit/>
               </ui>
               <value>
                  <text>  2            Low </text>
               </value>
               <font typeface="Myriad Pro"/>
               <margin topInset="0.5mm" bottomInset="0.5mm" leftInset="0.5mm" rightInset="0.5mm"/>
               <para vAlign="middle"/>
            </draw>
            <draw w="30mm" h="5.9177mm" name="Cell2">
               <border>
                  <edge/>
                  <corner thickness="0.1778mm"/>
                  <fill>
                     <color value="0,255,0"/>
                  </fill>
               </border>
               <ui>
                  <textEdit/>
               </ui>
               <value>
                  <text>Normal Operations</text>
               </value>
               <font typeface="Myriad Pro"/>
               <margin topInset="0.5mm" bottomInset="0.5mm" leftInset="0.5mm" rightInset="0.5mm"/>
               <para vAlign="middle" hAlign="center"/>
            </draw>
            <draw w="30mm" h="5.9177mm" name="Cell3">
               <border>
                  <edge/>
                  <corner thickness="0.1778mm"/>
               </border>
               <ui>
                  <textEdit/>
               </ui>
               <value>
                  <text> 31   -   60</text>
               </value>
               <font typeface="Myriad Pro"/>
               <margin topInset="0.5mm" bottomInset="0.5mm" leftInset="0.5mm" rightInset="0.5mm"/>
               <para vAlign="middle" hAlign="center"/>
            </draw>
            <border>
               <edge presence="hidden"/>
            </border>
            <?templateDesigner expand 1?></subform>
         <subform layout="row" name="Row3">
            <assist role="TR"/>
            <draw w="30mm" h="6.61mm" name="Cell1">
               <border>
                  <edge/>
                  <corner thickness="0.1778mm"/>
               </border>
               <ui>
                  <textEdit/>
               </ui>
               <value>
                  <text>  3         Medium</text>
               </value>
               <font typeface="Myriad Pro" baselineShift="0pt"/>
               <margin topInset="0.5mm" bottomInset="0.5mm" leftInset="0.5mm" rightInset="0.5mm"/>
               <para vAlign="middle" spaceAbove="0pt" spaceBelow="0pt" textIndent="0pt" marginLeft="0pt" marginRight="0pt"/>
            </draw>
            <draw w="30mm" h="6.61mm" name="Cell2">
               <border>
                  <edge/>
                  <corner thickness="0.1778mm"/>
                  <fill>
                     <color value="255,255,153"/>
                  </fill>
               </border>
               <ui>
                  <textEdit/>
               </ui>
               <value>
                  <text>Operational Cautions</text>
               </value>
               <font typeface="Myriad Pro"/>
               <margin topInset="0.5mm" bottomInset="0.5mm" leftInset="0.5mm" rightInset="0.5mm"/>
               <para vAlign="middle" hAlign="center"/>
            </draw>
            <draw w="30mm" h="6.61mm" name="Cell3">
               <border>
                  <edge/>
                  <corner thickness="0.1778mm"/>
               </border>
               <ui>
                  <textEdit/>
               </ui>
               <value>
                  <text> 61   -   80</text>
               </value>
               <font typeface="Myriad Pro"/>
               <margin topInset="0.5mm" bottomInset="0.5mm" leftInset="0.5mm" rightInset="0.5mm"/>
               <para vAlign="middle" hAlign="center"/>
            </draw>
            <border>
               <edge presence="hidden"/>
            </border>
            <?templateDesigner expand 1?></subform>
         <subform layout="row" name="Row4">
            <assist role="TR"/>
            <draw w="30mm" h="5.9177mm" name="Cell1">
               <border>
                  <edge/>
                  <corner thickness="0.1778mm"/>
               </border>
               <ui>
                  <textEdit/>
               </ui>
               <value>
                  <text>  4           High</text>
               </value>
               <font typeface="Myriad Pro" baselineShift="0pt"/>
               <margin topInset="0.5mm" bottomInset="0.5mm" leftInset="0.5mm" rightInset="0.5mm"/>
               <para vAlign="middle" spaceAbove="0pt" spaceBelow="0pt" textIndent="0pt" marginLeft="0pt" marginRight="0pt"/>
            </draw>
            <draw w="30mm" h="5.9177mm" name="Cell2">
               <border>
                  <edge/>
                  <corner thickness="0.1778mm"/>
                  <fill>
                     <color value="255,255,0"/>
                  </fill>
               </border>
               <ui>
                  <textEdit/>
               </ui>
               <value>
                  <text>Management Review / Approval</text>
               </value>
               <font typeface="Myriad Pro"/>
               <margin topInset="0.5mm" bottomInset="0.5mm" leftInset="0.5mm" rightInset="0.5mm"/>
               <para vAlign="middle" hAlign="center"/>
            </draw>
            <draw w="30mm" h="5.9177mm" name="Cell3">
               <border>
                  <edge/>
                  <corner thickness="0.1778mm"/>
               </border>
               <ui>
                  <textEdit/>
               </ui>
               <value>
                  <text> 81   -   100</text>
               </value>
               <font typeface="Myriad Pro"/>
               <margin topInset="0.5mm" bottomInset="0.5mm" leftInset="0.5mm" rightInset="0.5mm"/>
               <para vAlign="middle" hAlign="center"/>
            </draw>
            <border>
               <edge presence="hidden"/>
            </border>
            <?templateDesigner expand 1?></subform>
         <subform layout="row" name="Row5">
            <assist role="TR"/>
            <draw w="30mm" h="5.9177mm" name="Cell1">
               <border>
                  <edge/>
                  <corner thickness="0.1778mm"/>
               </border>
               <ui>
                  <textEdit/>
               </ui>
               <value>
                  <text>  5         Highest</text>
               </value>
               <font typeface="Myriad Pro" baselineShift="0pt"/>
               <margin topInset="0.5mm" bottomInset="0.5mm" leftInset="0.5mm" rightInset="0.5mm"/>
               <para vAlign="middle" spaceAbove="0pt" spaceBelow="0pt" textIndent="0pt" marginLeft="0pt" marginRight="0pt"/>
            </draw>
            <draw w="30mm" h="5.9177mm" name="Cell2">
               <border>
                  <edge/>
                  <corner thickness="0.1778mm"/>
                  <fill>
                     <color value="255,0,0"/>
                  </fill>
               </border>
               <ui>
                  <textEdit/>
               </ui>
               <value>
                  <text>Consider Alterative Actions / Plans</text>
               </value>
               <font typeface="Myriad Pro"/>
               <margin topInset="0.5mm" bottomInset="0.5mm" leftInset="0.5mm" rightInset="0.5mm"/>
               <para vAlign="middle" hAlign="center"/>
            </draw>
            <draw w="30mm" h="5.9177mm" name="Cell3">
               <border>
                  <edge/>
                  <corner thickness="0.1778mm"/>
               </border>
               <ui>
                  <textEdit/>
               </ui>
               <value>
                  <text>101   -   750</text>
               </value>
               <font typeface="Myriad Pro"/>
               <margin topInset="0.5mm" bottomInset="0.5mm" leftInset="0.5mm" rightInset="0.5mm"/>
               <para vAlign="middle" hAlign="center"/>
            </draw>
            <border>
               <edge presence="hidden"/>
            </border>
            <?templateDesigner expand 1?></subform>
         <break overflowLeader="HeaderRow"/>
         <keep intact="contentArea"/>
         <?templateDesigner rowpattern first:1, next:1, firstcolor:f0f0f0, nextcolor:ffffff, apply:0?>
         <?templateDesigner expand 0?></subform>