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
<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>
Views
Replies
Total Likes
I created a sample ofr what I think you want .....
let me know if this does the trick.
paul
Views
Replies
Total Likes
Views
Likes
Replies
Views
Likes
Replies