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.


  • Profile Image

    Formula based on previous entries

    Asked by TortolaExpress 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.

    Submissions amount calculate previous previous submission
  • Profile Image
    JotForm Support

    Answered by jonathan 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

    Answered by TortolaExpress on January 12, 2015 at 03:51 PM

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

  • Profile Image

    Answered by TortolaExpress 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

    Answered by TortolaExpress 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

    Answered by TortolaExpress 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

    Answered by raul 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

    Answered by TortolaExpress 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
    JotForm Support

    Answered by jonathan 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.