Formula based on previous entries

  • Profile Image
    TortolaExpress
    Asked on January 12, 2015 at 03:22 PM

    Hi there,

    Because of your fanatical support, I am now a Jot Form fanatic.  I have a few forms still to convert over from google.  There is one which i am not sure if i can convert.  The form takes the average of the last month's entries of a field and places them in a calculated field.

     

    For EG if my form has two fields they would be like this:

     

    1. How many Wigets?

    2 [calculated field].  What is the average amount of Wigets for the last 5 submissions?

     

    Any way you think this could be possible?  the way I made it happen in Google forms was with Form Emailer addon which allows a calculation to be made automatically inside the result spreadsheet.

  • Profile Image
    jonathan
    Answered on January 12, 2015 at 03:46 PM

    Hi,

    Thank you for contacting us.

    Can you also share to us the URL of your jotform you were working on for this?

    We will be more than glad to come up with a viable solution for you.

    We will wait for your response.

    Thanks.

  • Profile Image
    TortolaExpress
    Answered on January 12, 2015 at 03:51 PM

    Sure.  I need an email address to share it with.

  • Profile Image
    TortolaExpress
    Answered on January 12, 2015 at 04:08 PM

    BTW, it is not so much how the form behaves, but rather a post-submit action that is performed based on previous submissions.  All the behavior is in the spreadsheet results and then after that is done, the email is sent with the results.

  • Profile Image
    TortolaExpress
    Answered on January 12, 2015 at 04:11 PM

    Maybe the closest similarity might be a voting tool that shows the results of previous votes after voting.  That is not the final result, but might help along the way.

  • Profile Image
    TortolaExpress
    Answered on January 12, 2015 at 04:14 PM

    The exact result I am looking for is this.  I have a driver that delivers packages.  The form would have his start time and his end time and the number of packages he delivered.  There would be a calculation to determine the average time it took him to deliver each package on the email notification.

    In addition, I want him to see how he did for the day compared to his average for the month.

  • Profile Image
    raul
    Answered on January 12, 2015 at 05:14 PM

    Is this the form you're referring to: http://www.jotformpro.com/form/50116004201936 ?

    Please note that all calculations need to be done in the form since once the form is submitted we don't have a built-in way in the form editor to manipulate the email template to make the calculations there. If you want to do this after the form is submitted, then you'll need to send POST data to another web page (that runs PHP or ASP.NET) that would perform all calculations with the captured data.

    I think that this could be accomplished using the Dates difference widget in the form to get the difference between the entered times and in order to compare the average you would need to download the submissions in an Excel file to calculate the difference between the average and the daily time.

    Hope this helps.

    Let us know if you need further assistance.
    Thank you.

  • Profile Image
    TortolaExpress
    Answered on January 12, 2015 at 08:18 PM

    Yeah, that is the form.  OK, guess it can't be done without exporting the data somewhere.  Thanks!

  • Profile Image
    jonathan
    Answered on January 12, 2015 at 08:28 PM

    Hi,

    Thank you for taking the time to update us.

    Contact us again anytime should you need further assistance.

    Thanks.