aderatis
Forum Replies Created
-
Forum: Plugins
In reply to: [Calculated Fields Form] RE: Rounding Up to the next whole numberHi again,
I must be getting this wrong somewhere because its still not giving the correct results for me.
Here is the form source code I have pulled from a site which calculates the same as we do, although they also have and adhesive calculator underneath, but we don’t need that, only the wallpaper calculation:<form name=”cp_calculatedfieldsf_pform_1″ id=”cp_calculatedfieldsf_pform_1″ action=”?” method=”post” enctype=”multipart/form-data”>
<!--noptimize--><script>form_structure_1=[[{"form_identifier":"","name":"fieldname2","shortlabel":"","index":0,"ftype":"fnumber","userhelp":"","userhelpTooltip":false,"csslayout":"","title":"Width of wall (CM)","predefined":"eg. 360","predefinedClick":true,"required":true,"size":"small","thousandSeparator":"","decimalSymbol":".","min":"","max":"","dformat":"number","formats":["digits","number"],"fBuild":{}},{"form_identifier":"","name":"fieldname3","shortlabel":"","index":1,"ftype":"fnumber","userhelp":"","userhelpTooltip":false,"csslayout":"","title":"Height of wall (CM)","predefined":"eg. 240","predefinedClick":true,"required":true,"size":"small","thousandSeparator":"","decimalSymbol":".","min":"","max":"","dformat":"number","formats":["digits","number"],"fBuild":{}},{"form_identifier":"","name":"fieldname4","shortlabel":"","index":2,"ftype":"fCalculated","userhelp":"","userhelpTooltip":false,"csslayout":"","title":"Calc 1 width of wall\/130","predefined":"","required":false,"size":"medium","toolbar":"default|mathematical","eq":"fieldname2\/130","optimizeEq":true,"eq_factored":"(fieldname2\/130)","suffix":"","prefix":"","decimalsymbol":".","groupingsymbol":"","dependencies":[{"rule":"","complex":false,"fields":[""]}],"readonly":true,"hidefield":true,"fBuild":{}},{"form_identifier":"","name":"fieldname7","shortlabel":"","index":3,"ftype":"fCalculated","userhelp":"","userhelpTooltip":false,"csslayout":"","title":"calc 2 Round up calc 1","predefined":"","required":false,"size":"medium","toolbar":"default|mathematical","eq":"CEIL(fieldname4)","optimizeEq":true,"eq_factored":"(CEIL((fieldname2\/130)))","suffix":"","prefix":"","decimalsymbol":".","groupingsymbol":"","dependencies":[{"rule":"","complex":false,"fields":[""]}],"readonly":true,"hidefield":true,"fBuild":{}},{"form_identifier":"","name":"fieldname5","shortlabel":"","index":4,"ftype":"fCalculated","userhelp":"","userhelpTooltip":false,"csslayout":"","title":"Calc 3 Height of Wall\/100","predefined":"","required":false,"size":"medium","toolbar":"default|mathematical","eq":"fieldname3\/100","optimizeEq":true,"eq_factored":"(fieldname3\/100)","suffix":"","prefix":"","decimalsymbol":".","groupingsymbol":"","dependencies":[{"rule":"","complex":false,"fields":[""]}],"readonly":true,"hidefield":true,"fBuild":{}},{"form_identifier":"","name":"fieldname6","shortlabel":"","index":5,"ftype":"fCalculated","userhelp":"","userhelpTooltip":false,"csslayout":"","title":"Calc 4 height*no. of drops","predefined":"","required":false,"size":"medium","toolbar":"default|mathematical","eq":"fieldname5*fieldname7","optimizeEq":true,"eq_factored":"((fieldname3\/100)*(CEIL((fieldname2\/130))))","suffix":"","prefix":"","decimalsymbol":".","groupingsymbol":"","dependencies":[{"rule":"","complex":false,"fields":[""]}],"readonly":true,"hidefield":true,"fBuild":{}},{"form_identifier":"","name":"fieldname8","shortlabel":"","index":6,"ftype":"fCalculated","userhelp":"","userhelpTooltip":false,"csslayout":"","title":"Calc 5 10% waste","predefined":"","required":false,"size":"medium","toolbar":"default|mathematical","eq":"fieldname7*0.1","optimizeEq":true,"eq_factored":"((CEIL((fieldname2\/130)))*0.1)","suffix":"","prefix":"","decimalsymbol":".","groupingsymbol":"","dependencies":[{"rule":"","complex":false,"fields":[""]}],"readonly":true,"hidefield":true,"fBuild":{}},{"form_identifier":"","name":"fieldname9","shortlabel":"","index":7,"ftype":"fCalculated","userhelp":"","userhelpTooltip":false,"csslayout":"","title":"Calc 6 Required","predefined":"","required":false,"size":"medium","toolbar":"default|mathematical","eq":"fieldname6+fieldname8","optimizeEq":true,"eq_factored":"(((fieldname3\/100)*(CEIL((fieldname2\/130))))+((CEIL((fieldname2\/130)))*0.1))","suffix":"","prefix":"","decimalsymbol":".","groupingsymbol":"","dependencies":[{"rule":"","complex":false,"fields":[""]}],"readonly":true,"hidefield":true,"fBuild":{}},{"form_identifier":"","name":"fieldname10","shortlabel":"","index":8,"ftype":"fSectionBreak","userhelp":"","userhelpTooltip":false,"csslayout":"","title":"","fBuild":{}},{"form_identifier":"","name":"fieldname1","shortlabel":"","index":9,"ftype":"fCalculated","userhelp":"","userhelpTooltip":false,"csslayout":"","title":"Metres required:","predefined":"0","required":false,"size":"small","toolbar":"default|mathematical","eq":"CEIL(fieldname9)","optimizeEq":true,"eq_factored":"(CEIL((((fieldname3\/100)*(CEIL((fieldname2\/130))))+((CEIL((fieldname2\/130)))*0.1))))","suffix":" Metre\/s","prefix":"","decimalsymbol":".","groupingsymbol":"","dependencies":[{"rule":"","complex":false,"fields":[""]}],"readonly":true,"hidefield":false,"fBuild":{}},{"form_identifier":"","name":"fieldname12","shortlabel":"","index":10,"ftype":"fCalculated","userhelp":"","userhelpTooltip":false,"csslayout":"","title":"Calc 7 Adhesive Required","predefined":"","required":false,"size":"medium","toolbar":"default|mathematical","eq":"fieldname1\/16","optimizeEq":true,"eq_factored":"((CEIL((((fieldname3\/100)*(CEIL((fieldname2\/130))))+((CEIL((fieldname2\/130)))*0.1))))\/16)","suffix":"","prefix":"","decimalsymbol":".","groupingsymbol":"","dependencies":[{"rule":"","complex":false,"fields":[""]}],"readonly":true,"hidefield":true,"fBuild":{}},{"form_identifier":"","name":"fieldname11","shortlabel":"","index":11,"ftype":"fCalculated","userhelp":"","userhelpTooltip":false,"csslayout":"","title":"Adhesive Required:","predefined":"0","required":false,"size":"small","toolbar":"default|mathematical","eq":"CEIL(fieldname12)","optimizeEq":true,"eq_factored":"(CEIL(((CEIL((((fieldname3\/100)*(CEIL((fieldname2\/130))))+((CEIL((fieldname2\/130)))*0.1))))\/16)))","suffix":" Tub\/s","prefix":"","decimalsymbol":".","groupingsymbol":"","dependencies":[{"rule":"","complex":false,"fields":[""]}],"readonly":true,"hidefield":false,"fBuild":{},"predefinedClick":false}],{"0":{"title":"","description":"","formlayout":"right_aligned","formtemplate":"cp_cff_elegant"},"formid":"cp_calculatedfieldsf_pform_1"}];</script><!--/noptimize-->
<div id=”fbuilder”>
<div id=”fbuilder_1″>
<div id=”formheader_1″></div>
<div id=”fieldlist_1″></div>
</div>
</div>
<div class=”clearer”></div>
</form>Is it possible to pull the information needed there, and if so could you tell me exactly which equations I need to put in which boxes please, I’m sorry to be a pain, just want to get this working.
Am I correct in understanding the only thing that needs to be set in the width of wall and height of wall fields are the field labels? and the actual calculation (whatever that might amount to) needs to go onto the ‘metres required’ field?Kind Regards
Forum: Plugins
In reply to: [Calculated Fields Form] RE: Rounding Up to the next whole numberJust to clarify my previous message, the actual width per sheet is 130 and height 100.
so when someone types in 100 as the width they still need to have the minimum width which is 130 x the required height in multiples of 100.thanks.
Forum: Plugins
In reply to: [Calculated Fields Form] RE: Rounding Up to the next whole numberThanks for the quick reply, I am trying to calculate wallpaper to round up when displaying the result, the width is 130 and the height is 100, the current formula is CEIL(fieldname8/130*fieldname9/100) but when I type in 100 for the width (fieldname8) and 240 for the height (fieldname9) its displaying 2 metres, when it should be showing 3 metres.
Thanks in advance.