Form Calculation Widget: Field calculation/formula

  • VALDOSTAHOMECENTER
    Asked on June 27, 2022 at 2:38 PM

    See below link - in the cost, cash, and retail columns I want to duplicate those formulas just like what is in the excel sheet (the formula changes depending on the size column)


    The table I am trying to duplicate:

    https://www.jotform.com/tables/220265511148044


    Verses the original excel google sheet:

    https://docs.google.com/spreadsheets/d/1rNEjG32rW_Vf2U28YhmUc5ezq3M0Gqxh/edit?usp=sharing&ouid=109401986136775606383&rtpof=true&sd=true

    Page URL: https://docs.google.com/spreadsheets/d/1rNEjG32rW_Vf2U28YhmUc5ezq3M0Gqxh/edit?usp=sharing&ouid=109401986136775606383&rtpof=true&sd=true
  • Kris JotForm Support
    Replied on June 27, 2022 at 7:09 PM

    Hello Ali,

    Thanks for using Jotform. Can you share with me what should be formula/calculation on your form? But let me provide you with some ideas on how you can set the value to each option/answer and knowledge on how Form Calculation works. I cloned your form to provide a screencast. Check out the screencast below:

    1656371295 62ba385fca4d6 2022 06 28 07 0 Screenshot 10

    Please give us more information on what you want to accomplish with your form and we will guide you in executing it on your form.

    We can move forward with a solution as soon as we hear back from you.

  • VALDOSTAHOMECENTER
    Replied on June 28, 2022 at 11:55 AM
    =SUM((I7-J7-K7-1000-160)*1.4)+(K7+6000+3500+2000+2000+2000+2500+160)
    Here is an example of the form I need to place in my “finance” column - the tricky part for me is the paranthesis
    Thank you,
    Ali Strickland
    Valdosta Home Center
    Office (229) 244-7245 ext 104
    Text (229) 506-7521
    Fax (229) 247-1370
    Schedule An Appointment
    Address 3500 Bemiss Rd, Valdosta GA 31605
    Visit our Website
    Like us on Facebook!
    *Please note that all price quotes are subject to a (7) day expiration and pricing is based on the existing and currently available lot model. Prices include standard delivery within 100 round-trip miles of our Valdosta office, standard set-up in GA, standard skirting, standard AC installation, standard steps, and appliances within the home. Price quotes do not include property improvements, county permits or any additional required fees, taxes, lending fees, etc, unless otherwise noted*
    ...
  • Kris JotForm Support
    Replied on June 28, 2022 at 12:41 PM

    Hi Ali,

    Thanks for getting back to us and for the added information. Can you share with us the fields where should be the calculation be applied? I believe the parenthesis location will be the same on setting it up on the Form Calculation Widget or the Calculation Conditions. Check out this link to understand and learn more about the Form Calculations Widget.

    Once we receive your response, we'll be able to help you with this.