What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.


  • Profile Image

    The spreadsheet I embedded will not work

    Asked by gardentimesheds on June 01, 2017 at 04:10 PM

     

    https://form.jotform.us/61586218860159

     

    <iframe src="https://docs.google.com/spreadsheets/d/1IiE6nEurC0a0K9Hx8fRNgjzjpY9HDmD496RCOYJFrmk/pubhtml?widget=true&amp;headers=false"></iframe>

     

    And yes, i removed the quotes

  • Profile Image
    JotForm Support

    Answered by Jan on June 01, 2017 at 06:49 PM

    I tested the iFrame code that you provided on a blank HTML form and I can see that it is working properly. I just added the width and the height. Here's a screenshot:

    You might want to check this link on how to embed the Spreadsheet to a webpage.

    We do have an HTML Table Listing Report and Grid Report that you can embed in your webpage. Please check these guides:

    How-to-Create-an-HTML-Table-Listing-Report
    How-to-Create-a-Grid-Listing-Report

    Hope that helps. Thank you.

  • Profile Image

    Answered by gardentimesheds on June 02, 2017 at 12:44 PM
    The spread sheet shows up, but it is only an image, none of the cells can
    be filled, and the formulas can not be used
    ...
  • Profile Image

    Answered by gardentimesheds on June 02, 2017 at 12:44 PM
    This is taking too long.
    Is there something that you can suggest that will incorporate the following
    into a jot form?
    - Unit price or Base Price (there is a discount applied to this line price
    in an another field)
    - Numerous line items (options) that have a price associated that can be
    also be multiplied in that line (4 flower boxes 20$ a piece, total 80$)
    - Base price discount percentage that can be manipulated (5 - 10 - 15 - 20%)
    - Total Price
    - Applicable tax rate wich can be maniultated (different tax rates
    depending on county)
    - Down Payment
    - Remaining balance due
    See attached
    ...
  • Profile Image
    JotForm Support

    Answered by david on June 02, 2017 at 01:32 PM

    You can assign your form options calculation values:

    https://www.jotform.com/help/301-How-to-Assign-Calculation-Value

    With those values you can perform calculations:

    https://www.jotform.com/help/259-How-to-perform-calculation-in-the-form

    This will allow you to add your tax rate and such.

    If you need to track total owed based on previous inputs though, that would not be possible.

  • Profile Image

    Answered by gardentimesheds on June 05, 2017 at 10:44 AM
    Can i create a field where a line item can be manually typed, as well as
    prce, that can be calculated
    EX
    - 2 Pair pf MiaTEC shutters (45$ a piece) = $90.00
    - Addition 3' door (wood) = $200.00
    - Increase windows to 24"x36" = $100.00
    - Total =
    $390.00
    - 7% Sales tax = $27.30
    - Balance due = $417.30
    we use an excel spread sheet for this calculation. But I can't get it to
    work with your form
    ...
  • Profile Image
    JotForm Support

    Answered by david on June 05, 2017 at 12:16 PM

    Yes, you would set that up exactly how I mentioned above.  Here is an example form to show how it would work:

    https://form.jotformpro.com/71554622452959

    You can clone it to your own account to see the full setup:

    https://www.jotform.com/help/42-How-to-Clone-an-Existing-Form-from-a-URL

  • Profile Image

    Answered by gardentimesheds on June 05, 2017 at 01:44 PM
    Unfortunately those are predetermined options you are listing. what i am
    trying to over come is the fact that I have 100 options, from 4 different
    builders, with 4 different sets of pricing.
    So I need the sales people to be able to *manually *add each option. *then *the
    *price*, when it is applicable, per order. Some orders will have no
    options, some will have 30.
    it would take a month to add all the options and the prices for each
    builder.
    - 2 Pair pf MiaTEC shutters (45$ a piece) = $90.00
    - Addition 3' door (wood) = $200.00
    - Increase windows to 24"x36" = $100.00
    ...
  • Profile Image
    JotForm Support

    Answered by Jan on June 05, 2017 at 02:49 PM

    We do have an app called Field Manager. You can clone fields from one form to another using this app. Here's the link: http://fieldmanager.jotform.io/.

    In this way, you don't need to redo the fields. You can just adjust the formula of the Calculation widget for the pricing. Here's a screen capture:

    Here's a screen capture of how the app works:

    Hope that helps. Thank you.