-
fbsqnowAsked on October 14, 2019 at 9:25 PM
creating an RSVP dinner banquet form. Need to total rsvp headcount but not everyone that RSVP will be required to pay. How can I set up so I get the t
-
roneetReplied on October 14, 2019 at 10:03 PM
I believe you are referring to the Form:
https://www.jotform.us/form/92850765914164
If you want to count the total headcount then you need to extract the report in Excel sheet and then filter reports.
Let us know if you are referring to something else.
Thanks.
-
fbsqnowReplied on October 14, 2019 at 10:45 PM
I need 2 things:
1. the total headcount to remain at the number of people needing seats/food. I will extract and count that separate.
2. the question and issue at hand is how to adjust the pricing so that people know what to submit either in form of a check or quick pay. the calculation now is # of attendees * $30. What is needs to be is # of attendees * $30 LESS the people that qualify for FREE, the athletes, team manager and board members.
How do I adjust for the total amount due BUT not modify the headcount.
-
fbsqnowReplied on October 14, 2019 at 10:50 PMwithin the form only, as people fill it in, they will input the total
headcount, then there will be a calculated dollar amount due.
The dollar amount due needs to be adjusted for the headcount that qualifies
for a free meal. that is the cheerleader a team manager or mp board
member.
I will extract the data separately to tally the totals.
... -
Ashwin JotForm SupportReplied on October 14, 2019 at 11:01 PM
I did check your form and found that you have already added "Form Calculation" widget to calculate the total amount due. This is calculating with formula as (RSPV count * 30).
We can help you achieve your requirement but would like some additional information from you. When you say "qualify for FREE, the athletes, team manager and board members." how do we know the number of people and the count who qualify for free. You do have a field "Are you a Team Manager or on the MP Cheer Board?", if yes is selected you want to less $30 from the total calculation? How do we found the numbers for athletes & board members?
Do get back to us on this and we will try to help you with the conditions to achieve your requirement.
We will wait for your response.
-
fbsqnowReplied on October 14, 2019 at 11:34 PM
also replied by email (same as below)
The field to fill in the Cheerleader name is 1 person, so that is -$30
The field Are you a Team Manager or on the MP Cheer Board? Selecting either from the options is 1 person so -$30Example.RSVP is 4 people.1 is a cheerleader1 is a Team Manager2 is other people (do not qualify for free meal)Total Amount Due needs to be $60. -
fbsqnowReplied on October 14, 2019 at 11:50 PMThe field to fill in the Cheerleader name is 1 person, so that is -$30
The field Are you a Team Manager or on the MP Cheer Board? Selecting either
from the options is 1 person so -$30
Example.
*RSVP is 4 people. *
*1 is a cheerleader*
*1 is a Team Manager*
*2 is other people (do not qualify for free meal)*
*Total Amount Due needs to be $60.*
... -
Ashwin JotForm SupportReplied on October 15, 2019 at 12:13 AM
Please take a look at the following cloned form where I have added the fields and calculation to achieve your requirement: https://form.jotform.com/92869460321966
Feel free to clone this form for a closer look. The following guide should help you in form cloning: https://www.jotform.com/help/42-How-to-Clone-an-Existing-Form-from-a-URL
Hope this helps.
Do get back to us if you need any other changes.