- mtroAsked on February 22, 2016 at 02:41 PM
I need to create forms to manage attendance to a conference.
Group A includes People I really want to attend - I will therefore allocate a greater number of seats
Group B is the 'public', which will register to attend because they have heard of the conference through Twitter, Social Media, etc.
What I would like to find out is if there's a way to clearly flag when someone who registers is part of Group A or Group B?
- JotForm SupportBDAVIDAnswered on February 22, 2016 at 05:29 PM
Where do you want to import your contacts?
If you want to add a field in your form just to specify to which category the user belongs, you can include a Text Box field, and output a category based on another fields input or selection: http://www.jotform.com/help/268-How-to-Insert-Text-or-Mathematical-Calculation-into-a-field-using-a-Condition
- mtroAnswered on February 23, 2016 at 05:26 AM
Thanks. This is very helpful. I figured another way to do this is from within Google Docs, which essentially provides some tools to use colour coding, filters and so on.
- JotForm UI DevelopermertAnswered on February 23, 2016 at 10:08 AM
On behalf of my colleague, you are kindly welcome. I'm glad to see that you have found a way to achieve your objective. If you need any other information or assistance, please do let us know.
- mtroAnswered on February 24, 2016 at 06:01 AM
I know Jot Forms is not GDocs. However, I wondered whether Jot Forms has a rule on how data is stored and displayed on GDocs.
My issue is that when I try to treat data (e.g. apply filters or formulas to count number of attendees, etc), GDoc mysteriously deletes the additional spreadsheets I add and reverts to one Spreadsheet where all answers are accounted for. Maybe there's some function it doesn't like?
Does anybody know anything about this?
- JotForm UI DevelopermertAnswered on February 24, 2016 at 07:38 AM
The issue you concerned seems like mostly related with Google Spreadsheet side. Maybe the formulas you used are doing these changes. On my searches, I found a guide that shows the functions of Google Spreadsheet with their results.
Please, check it from the link below:
However, if these changes are happening when you integrate your submissions with Google Spreadsheet, please do let us know.