-
mtroAsked on February 22, 2016 at 2:41 PM
Hi there,
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?
Thanks
Mat
-
David JotForm Support ManagerReplied on February 22, 2016 at 5: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
-
mtroReplied on February 23, 2016 at 5: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.
-
mert JotForm UI DeveloperReplied on February 23, 2016 at 10:08 AM
Mat,
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.
Regards.
-
mtroReplied on February 24, 2016 at 6:01 AM
Hi,
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?
Thanks,
-
mert JotForm UI DeveloperReplied on February 24, 2016 at 7:38 AM
Hi again,
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:
https://support.google.com/docs/table/25273?hl=en
However, if these changes are happening when you integrate your submissions with Google Spreadsheet, please do let us know.
Thanks.