I am trying to create a sponsor registration form via cognito forms that takes the total number of tickets (virtual and in-person) and creates a form that they can use to submit their names. It works great if someone does it all in one session, but if not, then when they reopen the form, it is blank and there is no record of who they entered.
My plan is to create 3 fields to solve this issue:
1. In-person tickets used - Count of the number of campaign membership who are a "guest attendees (account field)" of the account on the opportunity
2. Virtual Tickets used - Count of the number of campaign membership who are a "guest attendees (account field)" of the account on the opportunity and have a check box "virtual attendee" checked as true.
3. List of attendees - Text box that shows the name/title/account name in a list of the campaign members who are "guests of the account" on the affiliated campaign.
Then I could setup the automation on the form to subtract the virtual and in-person tickets from the total for each (which is already an opportunity field) and then list the names on the form. I am not sure where to even begin with this. I appreciate anyone's help!
Changed it up a bit, but stil looking for a similar answer.
