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.
How can I cumulatively add or subtract from submission to submission?Asked by iStore on December 06, 2016 at 11:10 PM
The first submission lists 100 items (Total Packages) need to be delivered and 2 items of the 100 get delivered on that same submission. On the 2nd submission I want it to show that there are now 98 packages remaining to be delivered and lets say 1 package gets delivered on the 2nd submission. Now on the 3rd submission I want it to show 97 packages remaining to be delivered. That's it. Easy peasy - right?
I also want a field to show x% complete (Total Packages Delivered / Total Packages)
Thank you for contacting us. You can achieve your requirement by using Quantity Gift Registry widget.
I created an example form for demonstration. Please have a look at the screenshots below for further information.
1. Add Quantity Gift Registry to your form.
2. Define the name and number of your product. Please note that you can define more that 1 item in your widget.
3. By using the widget, you are able to define the number of the product you want to select.
4. This is the preview of the form. I have 100 products of item 1. After I select 2 of them and make submission, the remaining product number is 98.
Unfortunately, we do not offer any feature that calculates the chosen number of products in Quantity Gift Registry. However, I am escalating this feature request to our developers.
Thank you for your understanding.
While I appreciate you thinking outside the box, this will not work.
With this project, we will have about 100 couriers (delivery people) that will be using the form. Each morning they will enter the number of packages they received (Total Number of Packages in CONS) and then begin their deliveries. Each delivery is a new form submission and each delivery will be for a varying number of packages. So each time that courier submits a delivery record we need the Total Delivered Packages to cumulatively add up. Example:
Courier starts with 95 packages (Courier enters this number on 1st record)
First Delivery is 2 packages (Courier enters this on this first delivery record (form submission)
Second Delivery is 1 package (Courier enters this on this second delivery record (form submission). We want somewhere on the top of this record prior to submission to show Total Delivered Packages and Total Remaining Packages - which at this point would be 2 and 93, respectively.
Third Delivery is 3 packages (Courier enters this on this third delivery record (form submission). We want somewhere on the top of this record prior to submission to show Total Delivered Packages and Total Remaining Packages - which at this point would be 3 and 92, respectively.
and so on.
View my form above and it should make more sense.
I feel like there should be a solution using prepopulation using URL parameters since these quantities are specific to each particular courier. (we are using URL parameters for other purposes on this form).
I just can't wrap my head around how to use URL parameters along with field calculations in order to pass calculated data on to the next record.
Maybe you have someone in support with some mathematical and URL parameter skills?
Hopefully, I have exactly understood your needs.
You can pass a value to the another form using URL encoding. Please check the following guide: https://www.jotform.com/help/164-Pass-Value-to-Another-Form-with-URL-Encoding
Also, you can use the form calculations to calculate the fields as the following guide: https://www.jotform.com/help/259-How-to-Perform-Calculation-in-the-Form
Moreover, I have created an example form for you using the information in that guides above. Please check the example form link and feel free to clone it to your side: https://form.jotform.com/63413161495959
Please pay attention to the thank you page after submitting the form and check the calculations.
If you need further assistance, let us know.
Thanks in advance.
Your solution does not work. It doesn't pass a running calculation indefinitely from form submission to form submission. I would have to have 150 fields (the maximum amount of potential packages in a day) on the form.
However, I managed to figure out how to accomplish exactly what I was asking for on my own.
I'm sorry that solution provided by my colleague didn't work for you.
On the other hand, I'm glad you were able to figure it out on your own, feel free to share your solution here if you want.