Hi Radzmar,That is an excellent representation of what I need to do. However I need to be able to incorporate calculated values depending on the item selected in each field.  PipeType: if(pipetype = "110x50 Sq","DPS","DP")  // using excel 'if then else' formatUpstand = 110Soffit =  if ((this.getFiel...

Hi team,I'm building a partno calculator form which has to interpret fields from a row of dropdown entries to come up with the approriate PartNo.The fields are as in the row immediately below.PipeType  |  Upstand |  Soffit | Cladding | StudHeight|Options for each field is as below80mm Round |    65 ...