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

    Create condition so category is added according to birthdate year

    Asked by sudsport on December 12, 2014 at 05:04 AM

    Hi,

    I use JotForm to register participant to sport events, participants are classified in categories based on birth date.

    Here under exemple of categories for Trail Race

    I managed to do it for a specific year, dealing ith birth date windows, in form http://form.jotformeu.com/form/43427070300340

    But this setting requires maintenance as will need to update the categorie dates each year hence I am looking for a mean to achive this by only setting the race year event which woudl trigger all categories birth dates windows.

    V4 = 70 years old and older at race time
    V3 = More or equal to 60 years old an less than 70
    ...

    I set-up the course date vriable (Année de la course), age windows variable: V4, V3H (V3 maxim age), V3L (V3 minimum age) variables quite fine. Now I am unbale to make use of thes variables in dates conditions to generate the categorie field output. See my test form http://form.jotformpro.com/form/43446484841966

    Thanks for your help,

    Georges

    create JotForm uploads variables test form
  • Profile Image

    Answered by Carina on December 12, 2014 at 10:30 AM

    I created a clone and replaced the date field by separate dropdown fields. This way it is possible to connect the year field to a Form Calculation so conditions can be added afterwards:

    You can test and clone the demo form: 

    http://form.jotformpro.com/form/43453607491962?

    For now it has only the first 2 conditions added. To add the remaining ones please select conditions > update a form field value:

      Let us know if you need more assistance.

     

  • Profile Image

    Answered by sudsport on December 13, 2014 at 01:07 PM

    Hi Carina,

    Thanks for your solution which is eaxctly the one I was edding to, forgetting the "Date of birth" wizard and creating 2 diffrent text field to receive the 3 parts of the date of birth.

    Altough this solution is adding columns to the final Google SpreadSheet, I can cope with that.

    An extra remaining thing is how to insure at data filling time that user do not pick day 31rst for September month or day 29th for February 1995.

    Best Regards,

    Georges

  • Profile Image
    JotForm Support

    Answered by BDAVID on December 13, 2014 at 11:09 PM

    What you could do is to add a Text field with a message something like "Not a valid date", and crate conditions like these:

    You might want to try my example here: http://form.jotformpro.com/form/43468919626974?

    Hope this helps, let us know if  you have more questions we will be glad to assist you.

  • Profile Image

    Answered by sudsport on December 15, 2014 at 08:01 PM
    Spam ?
    Le 12/12/2014 11:23, JotForm Support Forum[jotform@jotform.com] a écrit :
    ...
  • Profile Image

    Answered by raul on December 15, 2014 at 11:31 PM

    I'm sorry but I don't understand your last question.
    Could you please clarify it a bit more?

    Let us know if you have more questions or need any help to implement the solutions provided by my colleagues. We'll be happy to assist.

    Thank you.

  • Profile Image

    Answered by sudsport on December 16, 2014 at 04:35 PM

    Hi Raul,

    This is just that I recevied a mail for that thread which is a scramble, but since then <I deleted the mail, so please consider this thread as closed if it arise again I will open a new thread.

    Regards,
    Georges

  • Profile Image

    Answered by raul on December 16, 2014 at 05:10 PM

    Ok Georges.

    Thank you for letting us know.

    Best Regards.