- Fri Jan 16, 2015 10:41 am
#781651
hi liliana,
I'm using Processmaker 2.8 community edition.
MY master form XML Definition is below--
<?xml version="1.0" encoding="UTF-8"?>
<dynaForm name="51169043554a37b3e51d127072555830/54774039054a4d608b7d990022138802" enabletemplate="0" type="xmlform" width="900" mode="" nextstepsave="prompt" printdynaform="" adjustgridswidth="1">
<AddProject type="title" enablehtml="1" required="0" readonly="0" optgroup="0">
<en>Add Project</en>
</AddProject>
<FillNewProject type="subtitle" enablehtml="1" required="0" readonly="0" optgroup="0">
<en>Complete This Form</en>
</FillNewProject>
<SelectCustomer type="dropdown" required="1" readonly="0" optgroup="0" dependentfields="CustomerAddress" mode="edit">SELECT `id`,`customerName` FROM `CUSTOMERS`
<en>Customer
<option name="0">--Please Select--</option></en>
</SelectCustomer>
<CustomerAddress type="textarea" required="0" readonly="0" rows="5" cols="50" mode="edit" optgroup="0">SELECT `cust_address` FROM `CUSTOMERS` WHERE `id`= @#SelectCustomer<en>Address</en></CustomerAddress>
<CustomerContactNo type="text" maxlength="64" validate="Int" required="1" readonly="0" dependentfields="SelectCustomer" size="30" mode="edit" optgroup="0">SELECT `contactNo` FROM `CUSTOMERS` WHERE `id` = @#SelectCustomer<en>Contact Number</en></CustomerContactNo>
<CustomerEmailId type="text" maxlength="64" validate="Email" required="1" readonly="0" size="30" mode="edit" optgroup="0">
<en>Email ID</en>
</CustomerEmailId>
<SelectProcessType type="dropdown" required="1" readonly="0" optgroup="0" mode="edit">
<en>Select Products Type
<option name="1">--Please Select--</option>
<option name="2">Single Products</option>
<option name="3">Multi Products</option></en>
</SelectProcessType>
<SpecificationGrid type="grid" xmlgrid="51169043554a37b3e51d127072555830/57716184654b74eb27a7725097389668" addrow="1" deleterow="1" required="0" readonly="0" optgroup="0"/>
<DescriptionGrid type="grid" xmlgrid="51169043554a37b3e51d127072555830/77000481554b3b0f2058015014325750" addrow="1" deleterow="1" required="0" readonly="0" optgroup="0"/>
<SingleProcessWithDrawing type="yesno" readonly="0" mode="edit" required="0" optgroup="0">
<en>With Drawing</en>
</SingleProcessWithDrawing>
<MultiProcessSelection type="listbox" required="1" size="8" mode="edit" readonly="0" optgroup="0">SELECT id, products_name FROM PRODUCTS <en>Select Multi Process
<option name="0">--Please Select--</option></en></MultiProcessSelection>
<BOQ type="file" required="0" readonly="0" optgroup="0">
<en>Upload BOQ</en>
</BOQ>
<ProjectPO type="dropdown" required="1" readonly="0" optgroup="0" mode="edit">
<en>Project With PO
<option name="1">--Please Select--</option>
<option name="2">No</option>
<option name="3">Yes</option></en>
</ProjectPO>
<POPDF type="file" required="1" readonly="0" optgroup="0">
<en>Upload PO PDF</en>
</POPDF>
<DateGiven type="date" relativedate="1" beforedate="0m" afterdate="1y" mask="%Y-%m-%d" editable="0" required="1" readonly="0" defaultvalue_sel="empty" size="15" mode="edit" optgroup="0">
<en>Date For PO Upload</en>
</DateGiven>
<SubmitForm1 type="submit" required="0" readonly="0" optgroup="0">
<en>Submit</en>
</SubmitForm1>
<restForm type="reset" required="0" readonly="0" optgroup="0">
<en>Reset</en>
</restForm>
</dynaForm>
And My Grid XML Definition is-- I have made some changes i.e. i change some dropdown boxes to textbox.
<?xml version="1.0" encoding="UTF-8"?>
<dynaForm name="51169043554a37b3e51d127072555830/74668960654b91a406827c3069797464" enabletemplate="0" type="grid" width="500" mode="" nextstepsave="prompt" printdynaform="" adjustgridswidth="">
<SelectProducts type="dropdown" required="1" readonly="0" optgroup="0" dependentfields="ProductsModel" mode="edit"><![CDATA[SELECT id, products_name FROM PRODUCTS]]><en>Product Name
<option name="0">--Select One--</option></en></SelectProducts>
<ProductsModel type="dropdown" required="1" readonly="0" optgroup="0" dependentfields="ProductsType" mode="edit"><![CDATA[SELECT id, products_models FROM PRODUCTS_MODELS WHERE pro_Id= @=SelectProducts]]><en>Product Model
<option name="0">--Select One--</option></en></ProductsModel>
<ProductsType type="dropdown" required="1" readonly="0" optgroup="0" dependentfields="ProductsDescription" mode="edit"><![CDATA[SELECT id, model_name FROM PRODUCTS_SPECIFICATIONS WHERE prMdl_Id= @=ProductsModel]]><en>Product Type
<option name="0">--Select One--</option></en></ProductsType>
<ProductsDescription type="dropdown" required="1" readonly="0" optgroup="0" dependentfields="CopperPipeOne,CopperPipeTwo,InsulationSleeveOne,InsulationSleeveTwo,ProdWire" mode="edit"><![CDATA[SELECT id, CONCAT(star_rating, '--', TR) AS STTR FROM PRODUCTS_INVENTORY_DESCRIPTION_TWO WHERE prodSpecificId= @=ProductsType GROUP BY TR]]><en>Description
<option name="0">--Select One--</option></en></ProductsDescription>
<ProductQuantity type="text" maxlength="64" validate="Int" required="1" readonly="0" size="6" mode="edit" optgroup="0">
<en>Quantity</en>
</ProductQuantity>
<CopperPipeOne type="text" maxlength="64" validate="Any" required="1" readonly="0" size="30" mode="edit" optgroup="0"><![CDATA[SELECT prodDescription FROM PRODUCTS_INVENTORY_DESCRIPTION_THREE WHERE prodSpecificId= @=ProductsType AND prod_Inven_Desc_Id= @=ProductsDescription AND inventoryTwo_Id= 1]]><en>Copper Pipe One</en></CopperPipeOne>
<CopperPipeOneQty type="text" maxlength="64" validate="Int" required="1" readonly="0" size="6" mode="edit" optgroup="0">
<en>Quantity</en>
</CopperPipeOneQty>
<CopperPipeTwo type="text" maxlength="64" validate="Any" required="1" readonly="0" size="30" mode="edit" optgroup="0"><![CDATA[SELECT prodDescription FROM PRODUCTS_INVENTORY_DESCRIPTION_THREE WHERE prodSpecificId= @=ProductsType AND prod_Inven_Desc_Id= @=ProductsDescription AND inventoryTwo_Id= 2]]><en>Copper Pipe Two </en></CopperPipeTwo>
<CopperPipeTwoQty type="text" maxlength="64" validate="Any" required="1" readonly="0" size="6" mode="edit" optgroup="0">
<en>Quantity</en>
</CopperPipeTwoQty>
<InsulationSleeveOne type="text" maxlength="64" validate="Any" required="1" readonly="0" size="30" mode="edit" optgroup="0"><![CDATA[SELECT prodDescription FROM PRODUCTS_INVENTORY_DESCRIPTION_THREE WHERE prodSpecificId= @=ProductsType AND prod_Inven_Desc_Id= @=ProductsDescription AND inventoryTwo_Id= 3]]><en>Insulation Sleeve One</en></InsulationSleeveOne>
<InsulationSleeveOneQuantity type="text" maxlength="64" validate="Any" required="1" readonly="0" size="6" mode="edit" optgroup="0">
<en>Quantity</en>
</InsulationSleeveOneQuantity>
<InsulationSleeveTwo type="text" maxlength="64" validate="Any" required="1" readonly="0" size="30" mode="edit" optgroup="0"><![CDATA[SELECT prodDescription FROM PRODUCTS_INVENTORY_DESCRIPTION_THREE WHERE prodSpecificId= @=ProductsType AND prod_Inven_Desc_Id= @=ProductsDescription AND inventoryTwo_Id= 4]]><en>Insulation Sleeve Two</en></InsulationSleeveTwo>
<InsulationSleeveTwoQuantity type="text" maxlength="64" validate="Any" required="1" readonly="0" size="6" mode="edit" optgroup="0">
<en>Quantity</en>
</InsulationSleeveTwoQuantity>
<ProdWire type="text" maxlength="64" validate="Any" required="1" readonly="0" size="30" mode="edit" optgroup="0"><![CDATA[SELECT prodDescription FROM PRODUCTS_INVENTORY_DESCRIPTION_THREE WHERE prodSpecificId= @=ProductsType AND prod_Inven_Desc_Id= @=ProductsDescription AND inventoryTwo_Id= 5 ]]><en>Wire</en></ProdWire>
<ProWireQty type="text" maxlength="64" validate="Any" required="1" readonly="0" size="6" mode="edit" optgroup="0">
<en>Quantity</en>
</ProWireQty>
</dynaForm>
Thanks
Pratyush