How can I calculate cost of my fields in conjunction with gift registry?

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

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!

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
...

Ps. I also included my jotform link in original post if that helps! Thanks!
Sent from the lifestream
...

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.

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
...

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.   

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

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.   

Great!! Thank you so much! Will do!!
Sent from the lifestream
...

On behalf of my colleagues, you are welcome.

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

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!

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.

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!

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.

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!

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.

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

Thank you for your help!

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!