How to auto calculate with unique formula/math equation after choices selected
Hello, I notice some topic covered already. But I’m not sure if its really what I need.
Anyway, this is what I plan
After user keyin number in (1), make choice of option in step (2), and all the column in (3) will automatically calculated accordingly.
of course when the same choice have been made the selected column in step (3) will use the same value as keyin, instead of using the formula.
Can you explain more about how the choice in step 2 will affect the number in step 3?
Hi, thanks for reply.
for example as image below
Let say i put number 250 in the entry box, and choose ‘relong’. All the sqft, sqm, acre and hectare will automatically calculate as it change units.
when i put 250 and click ‘relong’, meaning, this 250 is in relong unit. so the field area above will maintin the 250 for relong table. While the sqm, acre and hectare will calculate accordingly base on formula i set up later.
same goes if I click sqft. so i write down 250 and click sqft. Meaning, right now 250 is in sqft unit. Table field above will maintain the 250 sqft and relong, sqm, acre and hectar to calculate accordingly as the 250 in different units.
Got it, you should do this instead.
Set the right column to the “from” part, the “to” unit will be static.
Hello, how can I make it visible on front end?
I paste the link from glide plugin already as below
but compenent should I select to show it
That column should be added to your ‘Sizes Calculator’ table and used to convert the number before using it in your calculations.