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

Slack Signup
Newsletter Optin
Help Desk

Field Calculations - online quote form

Labels

This Discussion is public

Notifications

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.

The easiest way to do this is with jQuery. What is the formula?

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

Okay, so that's not a formula. It's a list of product prices. Do you have a link to your form?

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

I looked up the formula for converting square mms to square meters. It seems to be:

((length x width) * 1000) * price

Is this correct?

Works great Chris, thank you  for your help.

Guy

Discussion closed.