Auto add quantity depending of result of calculation

[James13009]

Ill tell you my problem,

We sell flooring online and we want the customer to be able to work out how many for tiles they need..

Eg the formular for 500mm x 500mm tile is as simple as
(Square M2 * 4 = amount needed) (i've worked out how to do this in php already but not with actinic

With this "amount needed" i want it to automatically put the result of the calculation in the quantity box.

Can anyone help?

James

[fergusw]

Hi James,
We have provided a similar solution for an existing Actinic customer recently. Get in touch or PM me if you want some more information on how our solution works as it sounds as if it is an almost identical issue that you require solving.

[NormanRouxel]

The quantity is held in a field like:

<input type="text" name="Q_<actinic:variable Name="ProductID"/>" size="4" value="<Actinic:Variable Name="DefaultQuantity"/>" class="form_input_general" />

So make a custom product layout containing

<script type="text/javascript">
function calculate(pid){
  document.getElementById('Q_' + pid).value = 4 * document.getElementById('XXX_' + pid).value * document.getElementById('YYY_' + pid).value;
}
</script>
Width in meters: <input type="text" id="XXX_<actinic:variable Name="ProductID"/>" size="4" value="0" class="form_input_general" onchange="calculate('<actinic:variable Name="ProductID" encoding="perl" selectable="false" />')" />
Depth in meters: <input type="text" id="YYY_<actinic:variable Name="ProductID"/>" size="4" value="0" class="form_input_general" onchange="calculate('<actinic:variable Name="ProductID" encoding="perl" selectable="false" />')" />

Code is untested. Preview in Firefox and use its Tools / Error Console to debug.

[fergusw]

There you go James - Norman has excellent solution for you.

Our solution was similar with just the original quantity field being hidden and a dynamic display of adjusted price showing on page.

[NormanRouxel]

Adding in a basic cost calulation we get.

The quantity is held in a field like:

<input type="text" name="Q_<actinic:variable Name="ProductID"/>" size="4" value="<Actinic:Variable Name="DefaultQuantity"/>" class="form_input_general" />

So make a custom product layout containing

<script type="text/javascript">
function calculate(pid){
  var numtiles = 4 * document.getElementById('XXX_' + pid).value * document.getElementById('YYY_' + pid).value;
  document.getElementById('Q_' + pid).value = numtiles;
  var tilecost = numtiles * 1.175 * <actinic:variable name="ProductPriceRaw" encoding="perl" selectable="false" />;
  document.getElementById('CCC_' + pid).innerHTML = tilecost.toFixed(2);
}
</script>
Width in meters: <input type="text" id="XXX_<actinic:variable Name="ProductID"/>" size="4" value="0" class="form_input_general" onchange="calculate('<actinic:variable Name="ProductID" encoding="perl" selectable="false" />')" />
Depth in meters: <input type="text" id="YYY_<actinic:variable Name="ProductID"/>" size="4" value="0" class="form_input_general" onchange="calculate('<actinic:variable Name="ProductID" encoding="perl" selectable="false" />')" />
Total cost: £<span id="CCC_<actinic:variable Name="ProductID"/>" >---</span>

Code is untested. Preview in Firefox and use its Tools / Error Console to debug.

[NormanRouxel]

And you could create a user Variable NumTilesPerSqM that you use instead of the hard-coded 4 above.