ProcessMaker Forum | BPM Workflow Simplified

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>

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>