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 can I calculate cost of my fields in conjunction with gift registry?

    Asked by Keithy on March 22, 2016 at 12:29 AM

    Hi, 

     Ive been loving this program thus far! One major question that i'm trying to resolve...(I included a screenshot that I can email to you, if you reply to kbliska@hotmail.com)

     

    I'm trying to use this form for my online tennis clinics that i offer at my summer club. I only have limited spots per clinic. how do i have the calculation add up with the weeks my customers want while depleting the spots left once they submit form?

    i offer about 6 different clinics each with different price points, but i'm just hoping to figure it out and apply it down the line through each box of fields. is gift registry and calculation the best widgets to use?

     

    i appreciate any help immensely!! :)

    -Keith

    Page URL:
    https://form.jotform.com/60797631341155

    gift registry gift registry in
  • Profile Image
    JotForm Support

    Answered by ashwin_d on March 22, 2016 at 12:54 AM

    Hello Keith,

    I am not sure if I have understood your question correctly and we are not able to see the screenshot you have shared. I would suggest you to please share the screenshot again and we will take a look. The following guide should help you how to upload image in forum post:  http://www.jotform.com/answers/277033 

    If you have 6 clinic and each clinic have limited spots, the best way to organize it by taking advantage of our "Gift Registry" widget. 

    We will wait for your response.

    Thank you!

  • Profile Image

    Answered by Keithy on March 22, 2016 at 01:45 AM
    Hi. :) Im trying to calculate the tabs when my customers select the boxes (weeks) they want. I also want the gift registry to deplete the number of spots remaining. I hope Im making sense! I have been using the Gift Registry widget in conjunction with the calculation tool.
    Thanks!
    -Keith
    Sent from the lifestream
    ...
  • Profile Image

    Answered by Keithy on March 22, 2016 at 01:45 AM
    Ps. I also included my jotform link in original post if that helps! Thanks!
    Sent from the lifestream
    ...
  • Profile Image
    JotForm Support

    Answered by Chriistian on March 22, 2016 at 03:12 AM

    The Gift Registry widget automatically depletes the number of spots remaining once a user submits the form. Unfortunately it is not possible to calculate the total amount of weeks selected from the Gift Registry Widget. If you want to calculate the total, you will have to use a regular check-box field.

    Here's a demo that you can see in action: https://form.jotform.com/60811830044951

    Do let us know if you need further assistance.
    Regards.

  • Profile Image

    Answered by Keithy on March 22, 2016 at 08:45 AM
    Hi! Ok, thank you!
    I just meant calculation of total money..? (in the case below it would be $96) Is that possible?
    -Keith
    Sent from the lifestream
    ...
  • Profile Image

    Answered by Carina on March 22, 2016 at 10:04 AM

    Actually it is possible to calculate the total, but you cannot include any numbers besides the price on the item name, and you have to create a separate Gift Registry field for each item:

    It's not the easiest way, but it is possible.

    You can test and clone the demo form:  

    https://form.jotform.com/60813991350961 

    Let us know if we can assist you further.   

  • Profile Image

    Answered by Keithy on March 22, 2016 at 10:04 AM

    I've seen from other posts that when using the Gift Registry widget and calculating a total value, you use conditional logic by creating numerous hidden fields (eg from this post http://www.jotform.com/answers/556071-Using-the-Gift-Registry-widgets-with-total-price).

    For the example above, when Week 1 and Week 2 are checked, I've gotten it to add to $96 using this method (see form -- https://www.jotform.com//?formID=60808886196168). However:

    - the amount left is not depleting. can you explain why?

    - i have at least 10 sections that are similar to the one above with 8 options and to create 80 hidden fields seems more complicated and more time prohibitive than it needs to be. is there an easier way to do this? for example, when using the regular check box widget, you can assign a "calculation value" to each field from the properties menu and it's a breeze. I want to do that, but still show the amount remaining. what's the best way to do this?

    Thank you,

    Keith

  • Profile Image

    Answered by Carina on March 22, 2016 at 10:15 AM

    Please try the above mentioned method with the separate gift registry fields. I tested and the amount gets reduced.

    Even though they still represent additional work, it's simpler than the solution you have tried so far.

    Let us know if we can assist you further.   

  • Profile Image

    Answered by Keithy on March 22, 2016 at 12:45 PM
    Great!! Thank you so much! Will do!!
    Sent from the lifestream
    ...
  • Profile Image
    JotForm Support

    Answered by BJoanna on March 22, 2016 at 01:01 PM

    On behalf of my colleagues, you are welcome.

    Feel free to contact us if you have any other questions.

  • Profile Image

    Answered by Keithy on March 23, 2016 at 01:31 PM

    Hi! Another follow-up question. Thanks for the good option above. I tried and it works, but would still prefer a cleaner look and and am searching for a simpler solution.

    Is there a way to create a condition that counts the number of boxes checked and using the calculation widget multiplies it by the price? In this scenario from below, the calculation wizard would calculate 3x$48 for a total of $144. This way I don't have to create so many hidden fields or numerous individual gift registry fields. I think this might work because the prices are not variable.

     

     

    Thank you!

  • Profile Image
    JotForm Support

    Answered by Charlie on March 23, 2016 at 02:03 PM

    I believe the solution above would be the best way to do it. We can't use conditions to count the number of check boxes in the Gift Registry widget, that should be possible if we'll create hidden text boxes stating their status.

    Example:

    If Gift Registry widget contains "Week 1: 20-Jun $48 wk" then set "Text box 1" to "1", meaning count it as 1. Apply it to the other options and create multiple text boxes, the sum up all the text box counts to have a total count.

    It's the same approach given by my colleagues, unfortunately, there's no other possible workaround that I can think of, unless we'll use a different widget or a plan check box. The problem is that the Gift Registry widget output either a random number value or the text label, so we cannot count those.

  • Profile Image

    Answered by Keithy on March 23, 2016 at 02:59 PM

    Ok, thank you for quick reply. I'll keep working on this to see if there's a creative way to figure this out. Does seem like this would be such a simple thing to do and would be a common function people would need. :-/ Regardless, I'm still impressed with jotform overall capability so will keep at it!

    The other widget that i saw that counts remaining is the inventory widget. Is that the only other one? Would you foresee the same issues here?

    Thank you again!

  • Profile Image
    JotForm Support

    Answered by Charlie on March 23, 2016 at 03:19 PM

    The Inventory widget is quite different from the Gift Registry widget, but has a much more simpler way of calculating things.

    In the Inventory widget, you can only have one item, this means you'll need to have multiple Inventory widgets if you have more than one item. It also uses a quantity field, unlike the Gift Registry widget that uses check boxes. 

    The good thing about the Inventory widget is that it directly outputs the quantity value, so you can easily calculate it using the form calculation widget. Here's an example form: https://form.jotform.com/60826130243951. Below are the steps on how I did it:

    1. Here I'll have two inventory widgets, one is week 1 with a price of $48 per person. And week 2 with a price of $50 per person. I also have a form calculation widget for the total price calculation, noticed that I do not have any hidden fields.

     

    2. In the form calculation widget, I just need to get the inventory widgets and multiply them with their price. This is because the actual output of the widget is the quantity. In my case, the formula would be:

    ( "Inventory widget 1" * $48 ) + ( "Inventory widget 2" * $50 ) = total price

     

     

    We do have other widgets that have the same function, you can try them below:

    https://widgets.jotform.com/widget/quantity_gift_registry 

    https://widgets.jotform.com/widget/ticket_purchases 

    https://widgets.jotform.com/widget/appointment_slots 

     

    However, personally, I can say that the Gift Registry widget and the Inventory widget are the simplest ones that you can use if you want to tie it on a conditional logic. But you can always try and test the other widgets, they are constantly being updated and improved by our widget team.

    I hope that helps.

  • Profile Image

    Answered by Keithy on March 23, 2016 at 10:40 PM

    Thank you for all of the help! I've decided to move forward with the inventory widget as it will allow me to add more than one number in the text field. My issue now is how to remove the vertical space between each field. I removed disabled the label since it was redundant. I've read other threads about going into preferences and injecting css code, but can't seem to make it work. see screen shot. thank you as always for your help!

     

     

    OR even make it 2 columns just to make it look a little neater!

  • Profile Image
    JotForm Support

    Answered by Chriistian on March 24, 2016 at 12:15 AM

    Can you try to inject this custom CSS code in your form to remove the vertical space  in between the fields?

    #id_70, #id_71, #id_72, #id_73 , #id_74, #id_75, #id_76, #id_77{

        margin: 0;

    }

    #id_71 {

        position: relative;

        top: -19px;

    }

    #id_72 {

        position: relative;

        top: -29px;

    }

    #id_73 {

        position: relative;

        top: -48px;

    }

    #id_74 {

        position: relative;

        top: -66px;

    }

    #id_75 {

        position: relative;

        top: -84px;

    }

    #id_76 {

        position: relative;

        top: -102px;

    }

    #id_77 {

        position: relative;

        top: -120px;

    }

    To inject custom CSS code in your form, just follow the instructions provided in this article: How to Inject Custom CSS Codes.

  • Profile Image

    Answered by Keithy on March 27, 2016 at 11:05 PM

    Hi again, thank you so much for providing the custom css code for insertion. I tested and those specific fields look great!

    However, I've added more sections to my form and am trying to match the code to tighten the vertical spacing between the other fields but am having serious trouble and can't figure it out! :-/ Can you help me? This is the last piece of the puzzle. So excited to almost be done!!

    Thank you for your help!

  • Profile Image
    JotForm Support

    Answered by ashwin_d on March 28, 2016 at 01:34 AM

    Hello Keithy,

    On behalf of all my colleagues, you are welcome. 

    As we cannot answer multiple questions in one thread, I have moved your latest question to a new thread and you will be answered here:  https://www.jotform.com/answers/803862 

    Thank you!