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.
How To Monitor Total Number of Attendees and add it to a Report or Create a Notification on it?Asked by leadbelly on January 23, 2015 at 07:29 PM
Is there any way to include in notifier email a tally the column in excel and provide report that takes the sum of the number attending field that i have set up on my jotform?
I have a field on my jotform for number attending. People can rsvp for more than 1 person. I have to keep track and make sure if the sum of that field does not exceed 200.
Once it exceeds 200, i need to set it up so that a wait list email goes out in autoresponder.
I believe you can use the following widgets to automatically monitor or set a maximum number of attendees to your event. Here are the widgets:
I would personally recommend the Inventory widget. Here's a demo form that I made: http://form.jotformpro.com/form/50228956992973
After that, you ca integrate Google Spreadsheet to your form so that your submissions will also be directly added to a spreadsheet real-time. Here's the Google Spreadsheet app page: http://apps.jotform.com/app/google_spreadsheets_integration.
For the notifier, it seems that it is not possible right now. We can't seem to get the available number of seats to pass it on a condition for the notifier. But I'll try to look at it.
I hope this helps. Let us know if this works or if you need more assistance on this.