Help adding excel addition formulas to my gravity form please?

Gravity Support Forums » Plugin Support » Gravity Forms

lukewatson81
Member

Hi There,
I seem to have a very easy request in that i want to create a form that a user can fill out where they select a few items that have costs associated with them.
ONce they have selected their items I simply want the total to be added at the bottom of the form.
THat is it.
So you might have
item 1 - cost $1
item 2 - cost $2
item 3 - cost $3 etc etc.

Then the user might select 2 x item 1 and 1 x item 3 so I need a calculation of this to give them the total of $5....

Can someone show me how to achieve such a basic request?
I don't know where to find out how to do this?
Thanks in advance.

Posted 12 years ago on Monday November 12, 2012 | Permalink
Chris Hajer
Key Master

If you use product fields in your form, with quantities, the total field in the form will be updated just as you describe, without having to use any formulas. Is there a reason you can't use product fields for this functionality?

The product fields are available in the "Pricing Fields" section on the right side of the form builder.

Posted 12 years ago on Monday November 12, 2012 | Permalink
lukewatson81
Member

Ok let me extent on this a bit:
Primary Sch Secondary Sports Levy
Oldest Child $1,622.00 $1,957.00 $60.00
2nd Child $1,372.00 $1,657.00 $60.00
3rd Child $1,222.00 $1,457.00 $60.00
4Th Child $- $- $60.00

So you essentially have 4 products (oldest child, 2nd, 3rd, 4th etc) Then you have choices for these products, ie options....

I tried simply adding options...but it keeps telling me I need a product??

Posted 12 years ago on Thursday November 15, 2012 | Permalink
lukewatson81
Member

I am not truely confused...why can't you have a checkbox for products...only radio boxes...what If I have a few options in a product they can choose?

Posted 12 years ago on Thursday November 15, 2012 | Permalink
Chris Hajer
Key Master

Do you have an example of what you're trying to accomplish online now, either in Gravity Forms with the progress you've made so far, or an example form you're trying to emulate?

Posted 12 years ago on Saturday November 17, 2012 | Permalink
lukewatson81
Member

Thats a good question.
Something like this perhaps
http://www.kidspot.com.au/Tuition-Calculator-kidspot.asp?gclid=CLPjnO3L1bMCFTBTpgoduGwAiw

So bascially the first childs fee will differ to the second childs fee etc etc and then you get a final costing.
http://webpub.com.au/CCS/?gf_page=preview&id=1

Now that is the form I have, so you can see what is needed, but this isn't working as it is supposed to.. Firstly I cannot even enter this form into a page as it says "error: validation required on one of the fields????"

But this form isn't anywhere near as elegant as it should be.

You can see from my example, that you are able to choose to pay anually, per semester or per term and a sports levy.

These values change as the number children you have is added.....

I HOPE SOMEONE CAN HELP ME??

Posted 12 years ago on Sunday November 18, 2012 | Permalink
lukewatson81
Member

oh and with the example, I would have the fees already entered, so they just need to bascially choose their options to get the final costing?

Posted 12 years ago on Sunday November 18, 2012 | Permalink
lukewatson81
Member

Ok I think I got it working except for one part
http://webpub.com.au/CCS/?gf_page=preview&id=1

I ended up using conditional logic.

Can you please help me to understand why it will work for all my conditional logic EXCEPT the annual choice?

Posted 12 years ago on Monday November 19, 2012 | Permalink
lukewatson81
Member

Ok I got it working....my only issue now is how do you get a form to be used WITHOUT a submit button?
I just want it to calculate totals...It doesn't have to be emailed anywhere or submitted?

Posted 12 years ago on Monday November 19, 2012 | Permalink
David Peralty

You would have to hide the submit button using CSS and remove the ability for people to submit using the enter button. This is kind of a hack to override the core functionality of Gravity Forms though.

Posted 12 years ago on Monday November 19, 2012 | Permalink
Cara Jeanne
Member

Can you give more detail on hiding the submit button? I want to display calculations as well. Thanks.

Posted 12 years ago on Thursday November 29, 2012 | Permalink
Chris Hajer
Key Master
You can hide a submit button on your form by adding this CSS to your theme's stylesheet:
```
[css]
body .gform_footer input[type='submit'] {
    display: none;
}
```
That will apply to all forms. You can get more specific with the selection if you want to hide the submit only for one form (in this example, form 5.)
```
[css]
body .gform_footer #gform_submit_button_2 {
    display: none;
}
```
You could also enable conditional logic for the submit button (in the form settings > advanced tab) and set the rules to something that will never be true, so the submit button will never be shown.
Posted 12 years ago on Saturday December 1, 2012 | Permalink