The spreadsheet I embedded will not work

  • Profile Image
    gardentimesheds
    Asked 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
    Jan
    Answered 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
    gardentimesheds
    Answered 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
    gardentimesheds
    Answered 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
    david
    Answered 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
    gardentimesheds
    Answered 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
    david
    Answered 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
    gardentimesheds
    Answered 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
    Jan
    Answered 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.