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.
Formula based on previous entriesAsked by TortolaExpress on January 12, 2015 at 03:22 PM
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.
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.
Sure. I need an email address to share it with.
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.
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.
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.
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.
Yeah, that is the form. OK, guess it can't be done without exporting the data somewhere. Thanks!
Thank you for taking the time to update us.
Contact us again anytime should you need further assistance.