Import contacts and create categories

  • Profile Image
    Asked on February 22, 2016 at 02: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?



  • Profile Image
    Answered 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: 


  • Profile Image
    Answered 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. 

  • Profile Image
    Answered 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.



  • Profile Image
    Answered 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?


  • Profile Image
    Answered on February 24, 2016 at 07: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:


    However, if these changes are happening when you integrate your submissions with Google Spreadsheet, please do let us know.