PLEASE NOTE: These forums are no longer utilized and are provided as an archive for informational purposes only. All support issues will be handled via email using our support ticket system. For more detailed information on this change, please see this blog post.

Help adding excel addition formulas to my gravity form please?

  1. 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 7 years ago on Monday November 12, 2012 | Permalink
  2. 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 7 years ago on Monday November 12, 2012 | Permalink
  3. 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 6 years ago on Thursday November 15, 2012 | Permalink
  4. 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 6 years ago on Thursday November 15, 2012 | Permalink
  5. 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 6 years ago on Saturday November 17, 2012 | Permalink
  6. 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 6 years ago on Sunday November 18, 2012 | Permalink
  7. 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 6 years ago on Sunday November 18, 2012 | Permalink
  8. 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 6 years ago on Monday November 19, 2012 | Permalink
  9. 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 6 years ago on Monday November 19, 2012 | Permalink
  10. David Peralty
    Administrator

    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 6 years ago on Monday November 19, 2012 | Permalink
  11. Cara Jeanne
    Member

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

    Posted 6 years ago on Thursday November 29, 2012 | Permalink
  12. 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 6 years ago on Saturday December 1, 2012 | Permalink