Import contacts and create categories

  • mtro
    Asked 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 Manager
    Replied 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 

    Example: https://form.jotform.co/60405724757862

    Import contacts and create categories Image 1 Screenshot 20

  • mtro
    Replied 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 Developer
    Replied 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.

  • mtro
    Replied 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 Developer
    Replied 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.