How can I cumulatively add or subtract from submission to submission?

  • Profile Image
    iStore
    Asked on December 06, 2016 at 11:10 PM

    For example:

    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)

  • Profile Image
    emily
    Answered on December 07, 2016 at 03:29 AM

    Hi,

    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.

     

     

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

    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.

     

     

  • Profile Image
    iStore
    Answered on December 07, 2016 at 04:26 AM

    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?

    Thanks.

  • Profile Image
    candy
    Answered on December 07, 2016 at 06:55 AM

    Hello,

    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.

  • Profile Image
    iStore
    Answered on December 08, 2016 at 04:03 AM

    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. 

  • Profile Image
    Nik_C
    Answered on December 08, 2016 at 04:48 AM

    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.

    Thank you!