What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.


  • Profile Image

    Import contacts and create categories

    Asked by mtro 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?

    Thanks

    Mat

    Page URL:
    https://form.jotformeu.com/60525273500345

    create and create forms find flag
  • Profile Image
    JotForm Support

    Answered by BDAVID 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 

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

  • Profile Image

    Answered by mtro 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
    JotForm Support

    Answered by mert 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.

  • Profile Image

    Answered by mtro on February 24, 2016 at 06: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,

  • Profile Image
    JotForm Support

    Answered by mert 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:

    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.