JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
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.
Form calculation not copying into inventory widgetAsked by templesinai on June 03, 2016 at 03:56 PM
I'm trying to design a ticket sales form that will allow me to sell tickets from a total number of seats available. The tickets are different prices, not because of WHERE they are seated, but because of WHO is buying them. So, I have a total of 300 seats and will sell tickets to adults at one price, children 5-12 at one price and children under 5 for free. I would want to have ALL these tickets deduct from the Inventory Widget total of 300 because ALL of them should be counted out of the 300 seats available.
I don't want people to have to fill out how many adults, etc. they want in one field and then total it themselves again and enter it into the Inventory Widget. Actually, I don't want them to be able to change the value of the Inventory Widget themselves. I'd rather have that "total tickets" field calculate for them automatically.
So... I tried to have a form calculation perform a total of each ticket type and then copy that total into the Inventory Widget. However, the Inventory Widget will not allow me to send this data into the it. I even tried to perform the calculation as a conditional calculation on the Inventory Widget directly and it would not work. That's why I ended up doing a form calculation into a normal field first then tried to send a copy of the total into the widget. I even tried to do a simple copy/paste from my keyboard into the widget and it doesn't allow anything to be pasted into it.
Is there a way to update the Inventory Widget with a calculated quantity so that the calculated quantity will deduct from the total inventory number? Please help. The link to the form is https://form.jotform.com/61545262245958 and this is just a test. I will use this to create a larger, more complete form later.
Unfortunately it is not possible to populate or pass values into a widget. I have just tested a couple of different widget and could not. Since widgets are placed in an iFrame it is very hard to pass values/populate them. You can capture the value and place it in another field but not the other way around.
I will try to see if I can create another work around to calculate the total amount of ticket available, but I think users will have to enter the total manually in both fields.
Thank you for your answer. I appreciate it.