SQL Field to check if a member is minor child

Hi, our Membership pro community

I have a file osm_birthday that is compulsory and I would like to display a file field to request minor child to load a parental autorisation for subscription to the activity.

I am afraid I cannot write this sql formulae by myself.

Any held would be most appreciated.

Kind Regards
Lionel

I don't really understand this question. Could you please explain more details?

Tuan

Of course.
This is a scuba diving Club. Membership Pro is used for annual membership. I ask for first name, Last Name and birthday.
When birthday shows that the member is less than 18 years's old, i.e. a minor child, his parent shall explicitly autorise the child to practice scubadiving.

I wonder is using SQL Field I could not do it that is :
When birthday shows the member is 18 year's old or more :

Do nothing and let the member continue registering.
When Birthday shows the tmember is less than 18's years old :

• Display a warning "As a minor member, your parents shall explicitly authorize you to practice scuba diving with our Club. To continue registration you shall upload the authorization form, duly signed by one of your parent or by your legal representative"
• Display a file field to upload the signed authorization"

For the time being, I just ask a question "Are you less than 18 years old ?"
If answer is No : Do nothing
If answer is yes : Display the warning and the file field.

This is working fine, but discovering the SQL field, I was wandering if I could avoid to ask the question "Are you less than 18 years old ?"

Thank you for your concern.

Lionel

Hello Lionel

Unfortunately, it is not possible (at least for the moment). So for now, the question Yes/No which you made is the best setup

Regards,

Tuan

We added a Waiver Acceptance link to our registration page. This insures that the person is either the parent or legal guardian for the child that they are signing up (for this case lessons). See an example at our current trips listing - www.skibacs.org/ski-and-snowboard-trips-...ividual-registration .
You'll notice that it has a Legal Guardian checkbox (I believe we set up a Custom Field, with a hard requirement). We also added the Release of Liability and Indemnification Agreement for good measure.

Good luck