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.

Need no total function in E-Mails

  1. survival774
    Member

    In Germany we have to show the customers the product-prices including the tax (gross). But at the end of the form near by the total price we also have to show the included tax.

    In the form I solved this by using product fields with calculation for tax and total. All product-prices are shown with tax (gross). My tax field calculates the tax from the gross-prices. Because of this I can´t use the automatic total-function: the calculated tax is only for information, but the automatic will add it again, so the total ist gross-price plus tax = "double tax". To solve this I use my own total function with an calculating product field.

    So far so good, it works fine. But in the Mails there are again automated total-fields in the order-table at the end, by using {all_fields}. It adds the product prices, my calculated total and my calculated tax - and so the new total price is more than double from the real correct total.

    Where and how can I customize this E-Mail-table, I need to delete the automated total-calculation there?! I hope this works, because the other way by constructing the Mails manually would be much more complicated, i have many fields and conditionally-logic fields. So "all-fields" is very easy and quite perfect for me, except the automated total.

    Posted 11 years ago on Tuesday July 3, 2012 | Permalink
  2. David Peralty

    You can't change what all fields outputs, so the only way to change what is output would be to include fields one at a time based on what you want to display.

    Posted 11 years ago on Tuesday July 3, 2012 | Permalink
  3. survival774
    Member

    Thank you for your answer. I solved the problem by using a number-field with calculation for calculating the tax. Now I can use the standard total field and with this the form and the mail work both perfectly.

    But with this I have a new styling problem. I designed the background-color of the input fields to grey, and a special green on focus.

    This is my css-code für the input-fields:

    [css]
    .gform_wrapper input[type="text"], .gform_wrapper input[type="url"], .gform_wrapper input[type="email"], .gform_wrapper input[type="tel"], .gform_wrapper input[type="number"], .gform_wrapper input[type="password"],body .gform_wrapper .gform_body .gform_fields .gfield select, body .gform_wrapper .gform_body .gform_fields .gfield textarea {
        font-size: 14px !important;
        font-weight: bold;
        color: #99001E;
        letter-spacing: 0.1em !important;
        background-color: #F5F5F5;
        border: 1px solid #C9C9C9;
        border-radius: 2px 2px 2px 2px;
    }
    .gform_wrapper input:focus, .gform_wrapper textarea:focus {
        background-color: #E2E3BA;
    }

    This also works for my special number-tax field (#field_1_59). But this field must always (normal and focus) be blue in the (calculated) input-area. I tried anything I found, but it will not work. Any ideas?!

    Posted 11 years ago on Tuesday July 3, 2012 | Permalink
  4. Hi David,

    I want to separate each of the {pricing_fields} table and input them in an HTML table sent in the final quote message. The reason is so that it can have a particular look at format...

    Product | Qty | Unit Price | Price ex VAT | Price inc VAT |
    _________________________________________________
    Prod1 | 10 | £10 | £100 | £120 |
    _________________________________________________
    Prod2 | 20 | £5 | £100 | £120 |
    _________________________________________________
    | TOTAL | £200 | £220 |
    ___________________________________

    Not sure if I am making sense....

    Posted 11 years ago on Tuesday July 3, 2012 | Permalink
  5. survival774
    Member

    My new problem is solved. I searched again in the forum and found the very easy code:

    [css]
    #input_1_59 {
        background-color: #E7F8FF !important;
        border: none !important;
    }
    Posted 11 years ago on Tuesday July 3, 2012 | Permalink
  6. David Peralty

    Glad you were able to figure it out.

    Joseph, can you please make your own thread on the forum to get this sorted out?

    Posted 11 years ago on Tuesday July 3, 2012 | Permalink

This topic has been resolved and has been closed to new replies.