JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
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.
Create condition so category is added according to birthdate yearAsked by sudsport on December 12, 2014 at 05:04 AM
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,
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:
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.
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.
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.
Le 12/12/2014 11:23, JotForm Support Forum[email@example.com] a écrit :
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.
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.
Thank you for letting us know.