Questions and discussion about developing processes and programming in PHP, JavaScript, web services & REST API.

Moderator: amosbatto

#824097
Hell PM Experts,

I have a GRID embedded in dynaform, I have set dependent field to pull price from of item selected in dropdown (independent field) but the price does not show immediately on change of dropdown variable/item, see below; I want to get Unit Price of item selected in PartNumber...both are in same PM table

<PartNumber type="dropdown" required="1" readonly="0" optgroup="0" dependentfields="" defaultvalue="--" mode="edit" sqlconnection="workflow" resizable="0"><![CDATA[SELECT MERAKIPN, MERAKIPN FROM PMT_T4GMERAKIEQUIPMENT WHERE STATUS=1 ORDER BY MERAKIPN ASC
]]><en>Meraki Part Number and Description
<option name="">-Select Meraki Part Number Description</option></en></PartNumber>

<UnitPriceList type="text" maxlength="64" validate="Real" mask="###,###,###,###.##" required="0" readonly="0" dependentfields="PartNumber,Description" size="10" mode="edit" sqlconnection="workflow" resizable="0" optgroup="0"><![CDATA[ SELECT UNITPRICE, UNITPRICE FROM PMT_T4GMERAKIEQUIPMENT WHERE MERAKIPN = "@#PartNumber"]]>
<en>Unit Price</en>
</UnitPriceList>
#824106
In the properties of your "PartNumber" field, you need to select "UnitPriceList" as a dependent field.

Your XML should be this:

<PartNumber type="dropdown" required="1" readonly="0" optgroup="0" dependentfields="UnitPriceList" defaultvalue="--" mode="edit" sqlconnection="workflow" resizable="0"><![CDATA[SELECT MERAKIPN, MERAKIPN FROM PMT_T4GMERAKIEQUIPMENT WHERE STATUS=1 ORDER BY MERAKIPN ASC
]]><en>Meraki Part Number and Description
<option name="">-Select Meraki Part Number Description</option></en></PartNumber>

<UnitPriceList type="text" maxlength="64" validate="Real" mask="###,###,###,###.##" required="0" readonly="0" dependentfields="Description" size="10" mode="edit" sqlconnection="workflow" resizable="0" optgroup="0"><![CDATA[ SELECT UNITPRICE, UNITPRICE FROM PMT_T4GMERAKIEQUIPMENT WHERE MERAKIPN = "@#PartNumber"]]>
<en>Unit Price</en>
</UnitPriceList>

I have two checkbox columns in my grid view. I nee[…]

Try it this way: //setup before functions var typ[…]

When the web entry form appears, is the name of th[…]

If the case doesn't exist in the APPLICATION table[…]