The Community forums are being phased out in favor of a new Slack group.
Add your email address below to get an invitation to join the community slack group
Field Calculations - online quote form
Hi, new to using Formidable Pro. Have a client who wishes to have a basic online quote form.
1: The height (in mm's)
2: The width (in mm's)
3: Total in per square metre in £'s
Tried to found a guide for this, but no joy. So hoping if someone could point me in the right direction, thank you.
November 25, 2017 at 12:10 am
The easiest way to do this is with jQuery. What is the formula?
November 27, 2017 at 12:56 am
Hi Victor
Thank you for replying.
My client is asking for:
"
These prices are based on per square metre
Antique £230
Bermuda £252
Cuba £276
Fiji £324
Java £324
Sumatra £360
"
Again thank for your help.
Kind regards
Guy
November 27, 2017 at 4:29 am
Okay, so that's not a formula. It's a list of product prices. Do you have a link to your form?
November 27, 2017 at 4:47 am
Hi Guy
I assume the formula is A (height) x B (width) = C (total Square Metres).
Then the calculation will be C x D (prices) right?
You can do this with Formidable without adding extra jQuery if you wanted to.
All you need to do is add a Radio button list (D) for your products and assign values (prices) to each item.
Then create your width & height fields (A & B)
Add a hidden field (C) for the initial calculation of A x B and then use that field to calculate your Total Price (C x D).
There are several ways of doing what you need but this way lets you make any future updates as required nice and easily.
Hope that helps.
Chris
November 28, 2017 at 7:08 am
I looked up the formula for converting square mms to square meters. It seems to be:
((length x width) * 1000) * price
Is this correct?
November 28, 2017 at 12:54 pm
Works great Chris, thank you for your help.
Guy
Discussion closed.