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

    How do I make my form do calculations on multiple fields and have the total displayed in a monetary format?

    Asked by premierdepogrl on December 21, 2013 at 03:54 AM

    http://form.jotform.co/form/33531238062851

    Trying to get this to work - can't figure out the syntax/codes.  How do I take the # of pages and multiply it by the base rate PLUS the copy rate, get a subtotal and then add any add'l fees to come up with a grand total?

    I'm stumped.  I thought it was * for multiplication but it's not working for me!

    PLEASE HELP ASAP, and thanks!

    Page URL:
    http://form.jotform.co/form/33531238062851

    JotForm monetary format calculation addition multiplication add multiply total optional value additional fee dollar sign currency accounting format
  • Profile Image
    JotForm Support

    Answered by ashwin_d on December 21, 2013 at 05:48 AM

    Hello premierdepogrl,

    Upon checking your from "http://www.jotform.co/form/33531238062851", I did not find the fields for "# of pages", "Base rate" and copy rate. Have you already deleted these fields? 

    Yes, * works for multiplication and there must be some issue why it was not working for you.  I just created a small demo form by adding all these fields which should give you an idea how the * works for multiplication.  Please take a look at this form:  http://form.jotform.me/form/33542342356451?

    Calculation formula should be something like this: 

    [({NumberOfPage}*{baseRate}) +{copyRate}]

    Basically if you want to do multiple operation then you should seperate it with brackets "()" just like you can see in my above sample. In the calculation wizard window you can check the examples on the calculation operator usages:

     

    Do get back to us if you have any questions.

    Thank you!

  • Profile Image

    Answered by premierdepogrl on December 21, 2013 at 06:23 AM
    Hi,
    I added the fields now and still cannot get it to calculate properly no
    matter what I do. The sample you sent also did not calculate for me.
    Please HELP!!!! ASAP!!!!
    ...
  • Profile Image

    Answered by premierdepogrl on December 21, 2013 at 06:24 AM

    this is STILL not working for me no matter how I try!  Please, help!!!!  Nothing is calculating properly.

    It has to be as follows:

    # of pages x base rate PLUS copy rate PLUS add'l charges = TOTAL

    Have tried everything!!!

    HELP!

  • Profile Image
    JotForm Support

    Answered by ashwin_d on December 21, 2013 at 06:42 AM

    Hello premierdepogrl,

    I have cloned your form and updated it to display the total as per your formula. Please take a look at the following from: http://form.jotformpro.com/form/33543305869965? Do check and get back to us if this works as expected.

    We will not be able to make changes in your form unless you authorize us to do so. Do let us know if you want us to implement this in your form. 

    If the above form looks good, feel free to clone it. Here is a guide which should help you in form cloning:  http://www.jotform.com/help/42-How-to-clone-an-existing-form-from-a-URL

    Thank you!

  • Profile Image

    Answered by premierdepogrl on December 21, 2013 at 08:22 AM
    SERIOUSLY??? IT'S NOT EVEN CLOSE. WHY IS THIS SO DIFFICULT???
    ALL I WANT IS SIMPLE AND BASIC MATH - THIS TIMES THIS PLUS THIS PLUS THIS
    EQUALS THIS.
    COME ON. SERIOUSLY???? RIDICULOUS.
    ...
  • Profile Image
    JotForm Support

    Answered by abajan on December 21, 2013 at 10:34 AM

    @premierdepogrl

    Currently, the calculation functionality in the form builder is very basic. It is incapable of correctly performing calculations on values which contain decimals. So whereas, strictly speaking, the number in the following Bill Total is correct,

    (2 * 3 = 6; 6 + 4 = 10; 10 + 5 = 15)

    The following definitely is not


    I'm assuming that this is the issue you encountered while testing my colleague's form. Until the calculation feature is "fully baked", so to speak, the only workaround I can think of to overcome this deficiency would be to embed the form's full source into a web page and include a custom script in the same page to both perform the calculation and correctly format the bill total. If you would be okay with that, I should be able to provide the requisite script.

    We look forward to your reply.

  • Profile Image
    JotForm Support

    Answered by ashwin_d on December 21, 2013 at 12:07 PM

    Hello premierdepogrl,

    Please accept my apology for not completely understanding your requirement.

    I believe, you can achieve your requirement by changing the field types. Please replace the normal textboxes with "Number" fields.

    That should give you the accurate calculation for decimal values. Please check the screenshot below:

    Were you trying to achieve something similar? Please take a look at the demo form which I have updated and replaced the textboxes with number fields:  http://form.jotformpro.com/form/33543305869965?

    Thank you!

  • Profile Image

    Answered by premierdepogrl on December 21, 2013 at 07:46 PM
    It's soooooooooooooo close! It's not calculating properly and each time I
    try to fix it I get frozen and have to abort the whole process!!!
    so basically it's the Base Page Rate PLUS the Copies multiplied by the # of
    Pages, and then the Add'l Fees need to be added to that # for the Bill
    Total.
    Can't this be done??? It's such a simple thing!!!! I can't believe it
    can't be done on your site...just can't be.
    ...
  • Profile Image

    Answered by premierdepogrl on December 21, 2013 at 08:10 PM
    http://form.jotform.co/form/33531238062851
    Seriously, what am I doing wrong??? I have tried this sooooooo many times.
    It just does not calculate properly!!!! Can it be done?
    Please help.
    ...
  • Profile Image

    Answered by premierdepogrl on December 21, 2013 at 08:28 PM

    ANYONE???  This is grueling...

  • Profile Image
    JotForm Support

    Answered by abajan on December 21, 2013 at 09:43 PM

    @premierdepogrl

    We feel your frustration but just to be certain that we're all on the same page (no pun intended) regarding the calculation, could you please give an example with specific numbers for each field and the expected bill total?


    Thanks

  • Profile Image

    Answered by premierdepogrl on December 22, 2013 at 12:41 PM
    Of course!
    Easy peasy...
    50 pages, Base page rate $3.25, Copies, $1.25, so that's a total of $4.50
    per page multiplied by 50 pages = $225 with add'l fees of $35 for a BILL
    TOTAL of $260.
    Does that help? I know I'm being billed $9.95 monthly for your services so
    if this doesn't work...
    ...
  • Profile Image

    Answered by Cesar on December 22, 2013 at 02:04 PM
    Kindly take a look at my example cloned form: 
    http://form.jotformpro.com/form/33555749732969?
    Current Calculation field settings:
    [(({basePage}+{copies}) * {Of}) + {add039lFees}]
    This is how the calculation responds:
    https://cms.jotform.com/uploads/image_upload/image_upload/global/22537_calctest.png
    Kindly let us know if you need further support. Thank you.
  • Profile Image
    JotForm Support

    Answered by abajan on December 22, 2013 at 04:13 PM

    @premierdepogrl

    It appears that at the outset we misunderstood the calculation you wanted to achieve. In the opening post you asked:

    How do I take the # of pages and multiply it by the base rate PLUS the copy rate, get a subtotal and then add any add'l fees to come up with a grand total?

    Then, in your third submission you stated:

    It has to be as follows:

    # of pages x base rate PLUS copy rate PLUS add'l charges = TOTAL

    Which is the same thing. However, there are three ways to interpret both of the above. How can that be?? Observe:

    Let's suppose we apply that formula to the figures given in the example in your latest post:

    # of Pages: 50

    Base Page Rate: $3.25

    Copies: $1.25

    Additional Fees: $35.00


    Method 1

    50 * $3.25 = $162.50

    $162.50 + $1.25 + $35.00 = $198.75


    Method 2 (The desired calculation)

    $3.25 + $1.25 = $4.50

    $4.50 * 50 = $225.00

    $225.00 + $35.00 = $260.00


    Method 3
    Very unlikely but the formula given in those two posts can be interpreted as follows:

    $3.25 + $1.25 + $35.00 = $39.50

    $39.50 * 50 = $1975.00


    In a nutshell, we misinterpreted the your formula due to its lack of parentheses and applied the wrong (but normal) operator precedence (Method 1). Please see this web page.

    Also, the label "Copies" is somewhat vague because it can be interpreted by the user of the form to mean "number of copies" instead of "price per copy".

  • Profile Image
    JotForm Support

    Answered by abajan on December 22, 2013 at 04:19 PM

    Actually, due to "... get a subtotal and then add any additional fees", your opening post cannot possibly be interpreted to mean Method 3 but the third post can.

  • Profile Image

    Answered by premierdepogrl on December 22, 2013 at 05:16 PM
    THANK YOU! THANK YOU! THANK YOU!
    Ahhhhhhhhhhhhhhhh, garbage in, garbage out! I was having problems
    specifying and you were doing the best you could with what I was providing.
    In the end, the result works and I thank you so very much!!!!!
    I am so thankful to being using your product as I was using another
    company's and wanted to have all my forms with you as you have the most
    features and the best service EVER.
    :)
    ...
  • Profile Image

    Answered by premierdepogrl on December 22, 2013 at 05:29 PM
    WAIT!!!! There are not ALWAYS Add'l fees and I got a miscalculation w/o
    them - a price HIGHER than if there ARE Add'l fees!
    omg. still not 100%!!!
    I got a subtotal of $275 w/o the addition of $35, which then reduced it to
    $260 - HUH???
    -
    ...
  • Profile Image

    Answered by premierdepogrl on December 22, 2013 at 05:44 PM
    O.M.G. I am sooooooooooooo close. I have inserted a "subtotal" box but
    seems if there is NO Add'l Fees the TOTAL amount does something really
    crazy!!! There's got to be a better way...
    HALP!
    ...
  • Profile Image
    JotForm Support

    Answered by abajan on December 22, 2013 at 07:06 PM

    Oh dear me! lol

    I've tested the solution and I see what you mean. As I've suspected all along, it doesn't seem like the calculation feature in our form builder is sophisticated enough (at least not yet) to achieve the desired functionality. Even if it were to perform the correct calculation, what about the formatting of the Billing Total? The value displayed certainly doesn't resemble money. Just whole numbers are being displayed. Where's the dollar sign and decimal point followed by two digits?

    We're going to have to see if we can fashion a custom script for you. At this point it's hard to estimate how long that would take because speaking from experience with scripts, sometimes what looks like it could be easily accomplished turns out to be anything but easy.

    Anyway, on behalf of the team, thanks so much for your compliments about our product and service.

  • Profile Image

    Answered by premierdepogrl on December 22, 2013 at 10:40 PM
    no WAY!!! I am using a form on another competitor and it works wonderfully
    - the only issue I have with theirs is that I am unable to determine where
    it's coming from unless I pay for their service...which means I may bring
    my other form that I'm currently paying you for to them and just have both
    with them!!!! OH, DEAR ME...what's a girl to do?
    Okay. Thanks. I will see what works best for my needs and go with it.
    Much appreciated.
    ...
  • Profile Image
    JotForm Support

    Answered by abajan on December 23, 2013 at 06:26 AM

    @premierdepogrl

    Barring any unforeseen circumstances, I should have a script for the form by sometime later today (Barbados time).

    I shall return!

  • Profile Image

    Answered by premierdepogrl on December 23, 2013 at 01:23 PM
    Barbados time??? WHAT??? I'm so jealous!!!!! Ugh. I'm stuck here in the
    snow in NY.
    Oh, well, MERRY CHRISTMAS!!!!
    ...
  • Profile Image
    JotForm Support

    Answered by ardy0689 on December 23, 2013 at 02:28 PM

    Hello @premiuerdepogrl, Merry Christmas to you as well. Our colleague Abajan is not here at the moment. I have trouble catching up with Abajan's explanation on the formula to test this on a custom script. He should be able to get back to you with his custom script. Thanks. Merry Christmas

  • Profile Image

    Answered by on December 23, 2013 at 04:23 PM

    Roberta,

    Please test this demo and let us know if it meets your requirements.


    Thanks

    P.S. Yes, I'm in Barbados but it would be nice to experience snow sometime. Perhaps we should exchange locations for the Season. lol

  • Profile Image

    Answered by premierdepogrl on December 29, 2013 at 01:52 PM
    AND??? Where is this script I have been promised???
    ??
    ...
  • Profile Image
    JotForm Support

    Answered by jonathan on December 29, 2013 at 02:15 PM

    premierdepogrl

    Hi,

    Have you tested the demo form provided by our colleague Abajan?

    He probably needs your feedback about it first, before proceeding.

    --

    In any case, the script can also be seen within the source code of the demo form.

     

    Please provide us your feedback on the demo form if it already meets your requirement.

    Thanks.

  • Profile Image

    Answered by premierdepogrl on December 29, 2013 at 04:18 PM
    works great!!! how can I incorporate this into my other form???
    I want them to be together in one form
    TIA~
    ...
  • Profile Image

    Answered by premierdepogrl on December 29, 2013 at 04:22 PM

    Hello, hello!  This works perfectly!!!  I'd love to have both forms in one - any way to do this???

    Please send me the link ASAP so I can put it up for use ASAP!

    Thanks so much!

  • Profile Image
    JotForm Support

    Answered by jonathan on December 29, 2013 at 04:31 PM

    Hi,

    The demo form by our colleague Abajan was base on your form http://www.jotform.com/33531238062851 

    Are there any other form/s you wanted to do similar custom calculations?

    --

    Just to give you an inital idea, you can NOT combine any 2 or more forms. Because each form have their own unique ID# and separate submissions database.

    So, if your intention is to combine 2 forms with the custom calculation -- it will not work.

    --

    We suggest you just embed your forms as stand alone forms on the same website page and it will still work (custom calculations will still work).

    The primary requirements you will need is a website -- that will allow uploading/hosting the form's source code embed (guide: -How-to-get-your-Form-Source-Code)

    Update us.

    Thanks.


  • Profile Image

    Answered by premierdepogrl on December 29, 2013 at 04:41 PM
    Seriously? I can't input the same info into my other form? I bet I
    can...just use the info and make it another page. I'm going to try.
    Thanks!
    ...
  • Profile Image

    Answered by premierdepogrl on December 29, 2013 at 04:49 PM
    Wait a minute - I can't seem to access this form and the form on my site
    does not work. Also, why wouldn't I be able to include the info in this
    bill into my other form, the one here:
    http://www.jotform.com/premierdepogrl/REPORTER_JOB_SUBMISSION_FORM
    Doesn't make sense that I can't add a bill portion to the form, as I
    started to at the bottom here.
    Please advise ASAP! Thanks a bunch.
    R
    ...
  • Profile Image
    JotForm Support

    Answered by jonathan on December 29, 2013 at 04:57 PM

    Seriously? I can't input the same info into my other form?

    Yes you can. You can duplicate the whole form or just some parts of it and create a New Page. That is doable.

    --

    I can access this form https://www.jotform.com/premierdepogrl/REPORTER_JOB_SUBMISSION_FORM

     

    and also this form https://www.jotform.com/33531238062851

     

    Kindly tell us the URL of the form you could NOT access.

    Thanks.

  • Profile Image

    Answered by premierdepogrl on December 29, 2013 at 05:16 PM
    I can't access the working billing form - where is that and what are the
    codes/info so I can put it in the other form?
    Please help!!!!
    ...
  • Profile Image

    Answered by premierdepogrl on December 29, 2013 at 05:17 PM
    [image: Inline image 1]
    ...
  • Profile Image
    JotForm Support

    Answered by jonathan on December 29, 2013 at 05:54 PM

    We are not able to see the attach image in your latest message. You can include screenshot images on your next message using this guide 

    How-to-upload-and-add-screenshots-to-support-forum

     

    Is this the Billing Form http://www.jotform.co/form/33531238062851 ?(click on the URL link)

    And the demo form of Abajan was this URL link https://shots.jotform.com/wayne/form_33561500027948.html

    Can you please click on those URL links I provided. Are you NOT able to view them?

    We need to establish first that you can access the necessary URLs before we can provide you guidance on how to apply the codes of Abajan to your form

    Thanks.

  • Profile Image

    Answered by premierdepogrl on December 29, 2013 at 06:06 PM
    Yes, I can access both of those, yes! I"m getting very excited as I really
    would love to finalize this tonight!!! With your continued support and
    help I will be able to.
    Thank you so much. Please guide me in how to create/add this info to my
    other form - if you look at it you will see I already included the header -
    which I sent to you already but will apply here again:
    http://www.jotform.com/premierdepogrl/REPORTER_JOB_SUBMISSION_FORM
    ...
  • Profile Image

    Answered by premierdepogrl on December 29, 2013 at 06:07 PM
    so since it will be attached to the other info, all I will need is the
    calculating info of the form - I won't need the Your name, ACR Job#, or
    Case name fields - just the calculating fields.
    I am so excited to get this accomplished tonight!
    Thank you.
    ...
  • Profile Image
    JotForm Support

    Answered by EltonCris on December 29, 2013 at 06:32 PM

    @premierdepogrl

    Thanks for the additional details. My colleague who provided you this brilliant workaround will surely get back to you as soon as he can. He seems to be off as of the moment.

    Regards!

  • Profile Image

    Answered by premierdepogrl on December 29, 2013 at 06:46 PM
    ugh...seriously??? DARN.
    ...
  • Profile Image
    JotForm Support

    Answered by EltonCris on December 29, 2013 at 07:17 PM

    @premierdepogrl

    We understand that you are eager to have this completed today but unfortunately, Abajan isn't yet around. We can help you with this, but the fact that he works on the script, he knows better about this. Honestly, I am having a little difficulties catching up the requested workaround as well.

    Keep in mind that this is a custom workaround, we do this on our free time so this always takes some time, and we hope you understand that. 

    Thank you!

  • Profile Image

    Answered by premierdepogrl on December 29, 2013 at 09:09 PM
    of course! Understood. Just eager...thanks so much for everything you've
    done thus far! I'm so thankful.
    ...
  • Profile Image
    JotForm Support

    Answered by abajan on December 29, 2013 at 10:56 PM

    Hi Roberta,

    Assuming you wish the second form to work like that on this page, please do the following:

    1. Clone this form (here's how)

    2. Copy the form's source code and paste it into the body of a web page

    3. Insert this code just before the closing body tag of the same page.

    The code inserted in step 3 is almost identical to the code for the first form. The only difference is the values to which the first five variables point, to match the IDs of the calculation text boxes in the new form. (Here's how the ID of a field can be found.) So, whereas the script used in the first demo starts like this, the script for this second form starts like this. (If the source of each demo is viewed you'll see the difference.) The variables are named in such a manner to make it easy to know which ID goes where.

    In case you're curious about how variables in JavaScript work, have a look at the following video:


    Armed with the above information, you should be able to apply the script to any other forms in which you need to add the same calculation fields but if you get stuck, we're always here to help.


    Cheers

  • Profile Image
    JotForm Support

    Answered by abajan on December 29, 2013 at 11:00 PM

    I forgot to include the link on how to clone a form.

  • Profile Image
    JotForm Support

    Answered by abajan on December 29, 2013 at 11:06 PM

    LOL, hold on. I just spotted a typo. The line stating:

    "So, whereas the script used in the first demo starts like this, the script for this second form starts like this. ..."

    should read:

    "So, whereas the script used in the first demo starts like this, the script for the second form starts like this. ..."

  • Profile Image

    Answered by premierdepogrl on December 30, 2013 at 02:07 AM
    OMG. Can you do this for me? I can't seem to figure this out at all!
    Every time I try to test the form on my page it is frozen!!!!
    Ugh. Just want to add the calculating capabilities into my other form. Is
    there ANY way you would be so kind as to do it for me??
    That would just be awesome.
    R
    ...
  • Profile Image

    Answered by premierdepogrl on December 30, 2013 at 02:24 AM
    OMG. I JUST GIVE UP ON THIS!!! I cannot get this form to work no matter
    how hard I try...
    I am about to cry...won't you please help me?
    Thank you in advance.
    ...
  • Profile Image
    JotForm Support

    Answered by EltonCris on December 30, 2013 at 05:39 AM

    @premierdepogrl

    First off, the freezing issue is due to the "Save Form" Autofill feature. Take note that the saving feature takes some time to update your browser local storage specially if you have few fields on your form. This results to lag/freeze on your browser.

    Since that's a long form, autosave to "30 seconds" would be enough. Uncheck the "Save on data changes" to stop the browser from freezing everytime you input data to your form.

    My colleague will also get back to you regarding on the calculation function. Thanks!

  • Profile Image
    JotForm Support

    Answered by abajan on December 30, 2013 at 05:46 AM

    Roberta,

    What are the URLs (internet addresses) of the webpages within which your forms are embedded? We'll await your response.


    Thanks

  • Profile Image

    Answered by premierdepogrl on December 30, 2013 at 11:27 AM
    http://robertaanneschmitt.homestead.com/~local/~Preview/Blank.html?_=1388420780982
    ...
  • Profile Image

    Answered by premierdepogrl on December 30, 2013 at 11:32 AM
    http://robertaanneschmitt.homestead.com/~local/~Preview/Blank.html?_=1388421082685
    Please use this one. Hope it works!
    ...
  • Profile Image
    JotForm Support

    Answered by abajan on December 30, 2013 at 12:38 PM

    Hi Roberta,

    The first issue I spotted at the URL is that the wrong form code is being used. The full source of the form needs to be copied from the Embed Form Wizard, as described in the How to get your Form Source Code guide to which both Jonathan and I earlier referred.

    Secondly, in the form itself, in the section headed "Billing" all five calculation fields ("Base Page Rate", "Price per Copy", "Number of Pages", "Additional Fees" and "BILL TOTAL") are missing!

    Thirdly, the form is still working sluggishly. It may be best to just disable the autofill feature altogether, unless it's really needed.

    Fourthly, I could be wrong but it appears that my script is nowhere in that page.

    Is some sort of CMS (Content Management System) being used to construct the page? I see Homestead SiteBuilder in the page's source. Do they allow custom scripts? If not, you're up the creek without a paddle! (Just kidding of course. If such an obstacle exists, we'll simply have to find a way around it. For instance, this other site builder does allow scripts.)

    The first order of business is to insert the five extra fields in the Billing section. There are just normal textboxes but the last one should be set to read-only like those in my demos, to prevent users from directly changing the bill total. To set it to read-only, right-click it and then click Properties. You'll see a section labeled Read-only near the bottom. Change the No to Yes:

    (Incidentally, field ID [input_8 which is needed for the script's fifth variable] can also be seen in the screenshot.)

    Once the extra fields have been inserted, copy the forms full source from the Embed Form Wizard and insert it in the body of your web page. Then add my script anywhere under it. (Remember to change the IDs in the first five variables to match those of the the five fields, as I earlier explained.)

    Save the changes made to your web page and let us know if the calculation works.


    Thanks

  • Profile Image

    Answered by premierdepogrl on December 30, 2013 at 03:42 PM
    omg. i am soooooooooooooooooooooooooooooooooooooooooooooo close.
    Can someone please help? http://form.jotform.com/form/20430204581?
    ...
  • Profile Image

    Answered by premierdepogrl on December 30, 2013 at 03:42 PM
    Issues are: Total box is NOT printing when I hit send and get the
    submission, and now it's not calculating...
    This form is going to kill me!
    ...
  • Profile Image

    Answered by premierdepogrl on December 30, 2013 at 03:49 PM
    [image: Inline image 1]
    ...
  • Profile Image

    Answered by on December 30, 2013 at 04:56 PM

    Hi again Roberta,

    As far as the second issue is concerned (not calculating), the form at your web page is working fine on my end:

    I'm using Chrome. To my knowledge, it should be working in every modern browser that's JavaScript enabled. Which browser are you using? Also, what message do you see displayed about JavaScript when you visit this page

    As to the total not printing, if you mean that the notification you get of the form's submissions does not not contain the bill total, it's being caused by the absence of it's tag ({billTotal}) in the notification's body. You could either insert it by clicking the field name in the menu on the right of the notification or manually enter {billTotal} in the body or just delete the notification and create a new one.

    Once an email alert (notification or autoresponder) has been edited, addition and deletion of fields on the form will not be reflected in the email alert. That's why the other additional fields also don't appear in the notification.

    Do continue to keep us updated.


    Thanks

  • Profile Image

    Answered by premierdepogrl on December 31, 2013 at 09:12 AM
    Hello! Can someone help me with this? It's sooooooooooooooooooooclose...
    ...
  • Profile Image
    JotForm Support

    Answered by abajan on December 31, 2013 at 09:29 AM

    Roberta,

    Could you please try to send the image which you attempted to send in your penultimate response? See the instructions below:

    1. Click the following link: JotForm Image Repository

    2. Click on Browse and choose your image

    3. Click on Send

    4. Select and copy the URL the tool renders for you

     

    Then click on the image icon and paste the URL there, and we will be able to see it

     

    http://content.screencast.com/users/Deygus/folders/Snagit/media/29c22ec7-9ea3-4a56-95c8-2e318ffcf401/12.19.2012-12.29.53.png


    Perhaps the screenshot will help us to better understand the issue(s) but as I stated earlier, the form on your page (http://robertaanneschmitt.homestead.com/~local/~Preview/Blank.html?_=1388421082685) is working fine on my end. I just checked it again to be sure and everything, including the calculations, is working correctly.

    We look forward to your reply (with screenshot).


    Thanks

  • Profile Image

    Answered by premierdepogrl on December 31, 2013 at 10:05 PM
    Hi!
    Okay. So I got it to work properly BUT, alas, another issue has come up.
    There is NOT ALWAYS a copy fee and there is NOT ALWAYS add'l
    fees..therefore, if these fields are empty the form STILL must calculate.
    I am unable to see that happening...can you correct the source code to
    effectuate that occurring from time to time?
    Thanks so much!!!!
    HAPPY NEW YEAR!!!
    ...
  • Profile Image
    JotForm Support

    Answered by abajan on December 31, 2013 at 10:19 PM

    No problem, Roberta. Please do the following:

    1. Remove the "Required" validation from the Copies Field

    2. Use this script instead

    That should do the trick but I haven't tested it. I'm off to view what promises to be a spectacular display and I'll check the solution when I get back.

    Happy New Year to you too :)

  • Profile Image

    Answered by premierdepogrl on January 01, 2014 at 12:11 AM
    Hope you enjoyed the display! Isn't working properly...I've changed a few
    things around and changed the theme as well.
    Here's the new form...see if you can get it to calculate properly, would
    you? FYI, I have also removed the "required" aspect to the Additional Fees
    as there not always applicable.
    Thanks again so very much Abajan!
    http://www.jotform.com//?formID=20430204581
    ...
  • Profile Image
    JotForm Support

    Answered by abajan on January 01, 2014 at 01:36 AM

    The fireworks were somewhat disappointing. I think I got spoilt by the truly remarkable fireworks in another location on the west coast of the island a year ago.

    Anyway, I forgot to change the values of the script's first five variables to match the IDs of your form's calculating fields. Try this script instead.

  • Profile Image

    Answered by premierdepogrl on January 01, 2014 at 02:01 PM
    Alas, that scripts works perfectly but I cannot seem to get the form to
    advance when I place it on my site and password protect it...egad...this is
    really taking so much of my time...that I should be spent working for my
    pay...
    ugh.
    any ideas? I wonder if it's a Homestead thing or something to do with the
    form...fyi, the pw is WORK4US - see what you can get from it,
    please...would you be so kind?
    Thanks, Abajan!
    http://robertaanneschmitt.homestead.com/Reporter-s-Page.html?_=1388602845432
    ...
  • Profile Image

    Answered by premierdepogrl on January 01, 2014 at 02:15 PM
    Oh, Abajan, when I send this link to my reporters for the time being, until
    I get the form up and running on my website, it does NOT calculate!!! OMG.
    Here's the link - and how do I make it calculate?
    http://www.jotform.com/premierdepogrl/REPORTER_JOB_SUBMISSION_FORM
    ...
  • Profile Image
    JotForm Support

    Answered by abajan on January 01, 2014 at 03:45 PM

    Hi Roberta,

    The form at the second link (http://www.jotform.com/premierdepogrl/REPORTER_JOB_SUBMISSION_FORM) does not calculate because it's missing the script to make it do so. Moreover, since that URL is on our domain (JotForm.com) it cannot have the said script because as a protective measure we don't allow custom scripts on our system. Thus the need to embed a copy of the form's full source into a website other than JotForm.

    As to the issue with the other copy of the form at http://robertaanneschmitt.homestead.com/Reporter-s-Page.html?_=1388602845432, to be honest, I'm not sure what's going on there. You may need to search for the solution on the Homestead Connection Forum or open a new thread there and ask if there's a way to have the form work when the password feature is activated. (Both the "Back" button appearing on the first page of the form and the "Next" button not advancing when clicked is normally an indication of a conflict or conflicts between a web page's pre-existing scripts and those of the form. It's possible my colleagues have a solution for you though.)

    Incidentally, this thread is not private. So, you'll definitely need to change that password!

  • Profile Image

    Answered by premierdepogrl on January 01, 2014 at 05:53 PM
    hahahahahaha! My bad...okay. So I'm at a standstill is what it sounds
    like. Is there any way to host that form somewhere other than my
    website??? How would you accomplish this if you were in my shoes?
    Okay. And thanks!
    ...
  • Profile Image
    JotForm Support

    Answered by EltonCris on January 01, 2014 at 06:57 PM

    @premierdepogrl 

    Sorry but we do not do web hosting here. There are many services that offers free web hosting when you take a quick search at Google, 000webhost is a good one.

    The best way to accomplish that is to save the final form script (with the calculation script) as html file, e.g. form_final.html. Upload this file to the mentioned free web hosting if you like, then take the web URL of the uploaded html file and embed it as iframe to your website.

    Example iframe code:

    <iframe allowtransparency="true" src="http://www.yourwebsite.com/form_final.html" frameborder="0" style="width:100%; height:465px; border:none;" scrolling="no"></iframe>

    Replace the highlighted URL with the uploaded html form URL.

    My colleague will provide their thoughts about this as well. Thanks!

  • Profile Image

    Answered by premierdepogrl on January 01, 2014 at 07:20 PM
    I am in the process of making another website just to host this form! I
    cannot believe this!
    Thanks so much for all your help!!!
    :)
    ...
  • Profile Image

    Answered by premierdepogrl on January 01, 2014 at 07:44 PM
    http://acrreporter.yolasite.com
    :)
    ...
  • Profile Image
    JotForm Support

    Answered by EltonCris on January 01, 2014 at 07:48 PM

    @premierdepogrl

    That's a one good looking site. Nicely done!

    Cheers!

  • Profile Image
    JotForm Support

    Answered by abajan on January 01, 2014 at 09:38 PM

    Nicely done, Roberta! Looks like mission accomplished.

    Now if we could just bottle some of these balmy tropical breezes and send your way, that would be the icing on the cake, eh? :)


    Cheers

  • Profile Image

    Answered by premierdepogrl on January 02, 2014 at 01:13 AM
    Oh, Abajan...did you KNOW we're getting another storm???
    Ahhhhhhhhhhhhhhhhhhhhh, if only you could send some tropical weather this
    way! Where are you located, exactly?
    Again, I want to thank all of you at Jotformforum for your FANTASTIC
    support!!!!! I am thrilled at the results of my new form. Just one other
    question for you and I wonder if you can help me to fix this. When I get
    the forms, I choose to get the pdf version, which is divine. However,
    there is a lot of "stuff" that comes in the body of the email that perhaps
    can be eliminated? Please let me know how to get rid of this stuff, if at
    all possible. I'd love just a very clean email with the pdf at the bottom,
    perhaps just the Job# and Case Caption in the body of the email itself.
    Here's what shows up:
    noreply@jotform.com
    via
    amazonses.com
    7:54 PM (5 hours ago)
    to production
    Question Answer
    Job#: 123
    # of Attys: 2
    # of Witnesses: 3
    Case Caption: SMITH
    V
    SMITH
    Exhibits?
    If yes, sent via?
    Tracking#:
    Video?
    If yes, name of videographer?
    1. Firm Name & Address:
    Atty:
    Ordering?
    ...
  • Profile Image

    Answered by premierdepogrl on January 02, 2014 at 01:14 AM
    Thanks, EltonCris! Much appreciated!!! I like it, too! :)
    ...
  • Profile Image
    JotForm Support

    Answered by abajan on January 02, 2014 at 04:44 AM

    Hi Roberta,

    As that's a different issue than the topic of this thread, please see this other thread for the solution.

    I'm located in the south of Barbados in the parish of Christ Church.


    Wayne

  • Profile Image

    Answered by premierdepogrl on January 02, 2014 at 02:00 PM
    Okay. I have some more questions about this form. If the parties filling
    it out make a mistake, is there a way to go back w/o the whole entire form
    resetting?
    Also, is there a way for them to start filling it out and then go back to
    it later, if need be?
    And last but not least, I need to include another section in the billing
    area!!! It needs to be a field that says "Expedite Rate, if applicable,"
    and needs to multiply as the Copy Rate field does...is this possible???
    Now using it real-world wise I'm finding other things that need to be
    tweaked!
    Thanks.
    ...
  • Profile Image
    JotForm Support

    Answered by KadeJM on January 02, 2014 at 03:04 PM

    It's not a problem at all Roberta, Any Questions you might have are certainly most welcomed.

     

    If the parties filling it out make a mistake, is there a way to go back w/o the whole entire form resetting? Also, is there a way for them to start filling it out and then go back to it later, if need be?

    There are 2 things that may help with this. One being the Save & Continue Feature. The other is you could opt-in to allow an " Edit Link " to be see inside of your Email Notifications which makes editing the submitted data simplified. Both of which you may find useful and to your benefit.

     

     And last but not least, I need to include another section in the billing area!!! It needs to be a field that says " Expedite Rate, if applicable," and needs to multiply as the Copy Rate field does...is this possible???

    From the what you stated I believe this would require an additional Form Field and Calculation added into the Form's exhisting equasion if that is what you meant? It's no trouble with the tweaks so let us see what more we can do to help accomplish it on that extra aspect.

  • Profile Image

    Answered by premierdepogrl on January 02, 2014 at 04:33 PM
    edit link would be for ME to edit THEIR form? I think it was
    misunderstood. I want them to be able to edit their form before sending it
    to me - in other words, for them that if they see a mistake they can edit
    the form prior to sending it w/o losing all their info. Also, the sample
    of the "save & continue," after watching the video, there is no option for
    "immediate" as displayed in the video - the actual video must be from an
    older version of Jotform. Can you help?
    I wonder if I am being clear.
    So my employee needs to fill out this form so I can pay him/her. When they
    are filling it out, if they need to do something and get back to it, is
    there a way to save it? Also, if they make a mistake, is there a way for
    them to go back w/o losing all their info?
    I will create the additional field for the billing area and perhaps the
    code can be made to include it.
    Thanks again!
    ...
  • Profile Image
    JotForm Support

    Answered by Mike_T on January 02, 2014 at 05:31 PM

    I have replied via this thread. Please use separate threads for other questions if possible.

  • Profile Image
    JotForm Support

    Answered by abajan on January 02, 2014 at 05:41 PM

    Hi again Roberta,

    Currently, the Copy Rate field does not multiply, it adds (well, it's added to the Base Page Rate and then the result of that is multiplied by the Number of Pages before any Additional Fees are added). As such, please explain how exactly the Expedite Rate is supposed to be factored in to the calculation. Just like before, give an example. That would definitely help.


    Thanks

  • Profile Image
    JotForm Support

    Answered by abajan on January 02, 2014 at 06:42 PM

    Roberta,

    It may not be necessary for you to provide any examples. Is the calculation in this demo what you wanted to achieve?

  • Profile Image

    Answered by premierdepogrl on January 02, 2014 at 08:12 PM
    Actually, Abajan, close...it does not need to be multiplied, I was
    mistaken. Basically what has to happen is the Base Page Rate PLUS the Copy
    Rate PLUS the Expedite Rate must add up and then calculate by the # of
    pages, add the Add'l Fees and come up with a total. Once again, there may
    not be a copy/expedite rate nor add'l fees...
    So many variables in my business!!!!
    :)
    Thanks, as always, for your tremendous help!
    ...
  • Profile Image

    Answered by premierdepogrl on January 02, 2014 at 08:24 PM
    Okay. I do have another question. When you have a check box or a radio
    button, is there a way to hit the Y or the N for Yes or No? I have the
    form setup so that you can easily tab through all the fields but when you
    come to a check box or RB, you have to use the mouse...is there a simpler
    way???
    Okay. Thanks!
    (My goal is the make the most amazingly simple form EVER!) lol
    ...
  • Profile Image

    Answered by Cesar on January 02, 2014 at 11:48 PM

    I believe this is not possible, at least not with the standard Form Builder. Unless one of my colleagues knows an alternative way. So I believe the mouse would be the default option.

    If you do need further assistance on any other matter, do let us know by creating a new thread. Thank you.

  • Profile Image

    Answered by premierdepogrl on January 03, 2014 at 01:42 AM
    I'm still waiting for the responses to my other queries...anyone?
    ...
  • Profile Image
    JotForm Support

    Answered by abajan on January 03, 2014 at 04:18 AM

    Roberta,

    If the calculation in this demo is correct, please do the following:

    1. Remove both the form code and my script from your web page

    2. In the form builder, copy the full source of your form to your computer's clipboard

    3. Paste the code into your web page's body, in the same position where the old form code would have been

    4. Copy this code and paste it into the same position where the old script would have been

    5. Save the changes

    Your question about selecting checkboxes and radio buttons via the keyboard is addressed in another thread, as this thread is about calculation.



    Thanks

  • Profile Image

    Answered by premierdepogrl on January 03, 2014 at 09:58 PM
    Hi!
    Works great. Only thing is now the form is very
    slooooooooooooooooooooooooowwwwww...
    How can I avoid that again?
    TIA
    ...
  • Profile Image
    JotForm Support

    Answered by EltonCris on January 04, 2014 at 08:03 AM

    @TIA

    Thanks but since that's a different concern, we'd request you to post it on a separate thread and provide the website URL where the form is embedded so we can attend to it and investigate the problem. 

    Thank you.