How can I take a value from a previous value?

  • Ferchoesc
    Asked on November 10, 2015 at 5:19 PM

    In a calculation formula, I need to take the value of the same cell but with a previous value.

  • Chriistian Jotform Support
    Replied on November 10, 2015 at 10:31 PM

    Hi,

     

    Do you mean copy the same value from a field to another? You can populate a field from another field by using Conditional logic. You can check the guide here:  How to Populate Field with a Value from another Field.

     

    Do let us know if you need further assistance.

    Regards. 

  • Ferchoesc
    Replied on November 10, 2015 at 11:00 PM

    No, I mean like if I have completed a form and then I need to take that value in my new form to get a calculation form. How can I get it?

  • Chriistian Jotform Support
    Replied on November 11, 2015 at 12:21 AM

    Hi,

     

    You can do that by setting your Thank you page to redirect to your second prepopulated form. Similar threads were answered before by my colleagues, you can check them as reference here: How can I prepopulate fields in one form with values from another and How to prepopulate a form with info from a different form not using thank you message

    Can you tell us which form you are working so we can check?

     

    We will wait for your response.

    Regards.

  • Ferchoesc
    Replied on November 11, 2015 at 12:22 AM

    Sure, im working on this form https://form.jotform.co/53134499177868? but its on spanish thats why im not posting it here. I need that the label named as "Acumulado Galon", "Acumulado Galon" and "Acumulado Litros" remain there, because with a new form I will calculate the 3 new labels minus de 3 old labels.

     

  • Chriistian Jotform Support
    Replied on November 11, 2015 at 1:49 AM

    Hi, I'm currently creating a sample form. I'll get back here as soon as I finish it. 

  • Chriistian Jotform Support
    Replied on November 11, 2015 at 1:59 AM

    Hi,

     

    I have cloned your form and created a second form as a Thank you page custom URL.

    How can I take a value from a previous value? Image 1 Screenshot 20

    You can check the the forms here. https://form.jotform.com/53141418118953 and https://form.jotform.com/53140983101951.

     

    Do let us know if you need further assistance.

    Regards.

  • Ferchoesc
    Replied on November 11, 2015 at 11:10 AM

    I need the same idea but this works with the value of a day before. Lets say today I fill that form but tomorrow I need the new values and the old values that I filled the day before. And where can I see the code?

  • Mike_G JotForm Support
    Replied on November 11, 2015 at 1:48 PM

    To my understanding, you are referring to only one form, is that correct? So let's say, you have filled in your form today, tomorrow or the next day, you will be needing the same data that you have entered today, is that correct? If I'm understanding you correctly, then I believe creating sessions on your submission would help you with what you want.

    You actually have two options. 

    First option: If you enter your data, should it require you to submit the form first to save the data? If yes, then I would recommend you to check the guide on how you can create a session after submitting the old form and creating a link that you can use that will pre-fill the new form.

    Here's the guide: How-to-Save-Forms-and-Continue-Later

    Second option: If you enter your data and you don't have to submit it for data to be saved. This option is used most of the time for lengthy forms. This is useful when the user accidentally closes the browser in the middle of entering a lengthy text. 

    Here's the guide to that: How-to-Enable-Auto-Fill-Feature

    That Auto Fill feature is based on browser local storage. It is saving the form data on user's browser, so the user can open the form later to view the previous data that was entered.

    Note (for the second option): The user will need to use the same browser to access the data. Clearing the browser's cache would result to loss of data.

    Let us know if you need further assistance with any of the options above.

    If neither of this options is not what you would like to happen, please give us more details of your request so we can further assist you. 

    Thank you.

  • Ferchoesc
    Replied on November 11, 2015 at 1:58 PM

    Yes, I need to see the data entered one day before, but the option 2 doesnt work for me because there will be access to the form by several devices. Is there any other option that can help me with this?

     

    Thank you for your answer!

  • Ben
    Replied on November 11, 2015 at 3:06 PM

    In that case, the only option is to use the email session and URL prepopulating.

    To do that, you set up your first form to create a session link for the second form, which you can see how here: How to Save Forms to Continue Later

    Now as you do that, you should pass the old data to that new form through prepopulation, so you just add that after the session parameter.

    For example:

    yourjotformformlink?session=your@email.com&oldValue1=1&oldValue2=2&oldValue3=3

    Once you have such link, it will be easy for you to continue at any point in the future (1 day or 2 days in the future - or more) and continue on the second form.

    You can see more on the URL pre-population here: Prepopulating fields to your JotForm via URL parameters

    If you have any additional questions do let us know and we would be happy to assist.