Login will Query Database to Verify Membership

  • gilparrish
    Asked on July 13, 2019 at 10:25 AM

    I need to create a form that requires logging in to respond, HOWEVER, the login would require a user to enter his/her membership number (or other unique information) that would then query a database for verification before revealing the form.  Can you help?

    Thanks!

    Gil

  • Victoria_K
    Replied on July 13, 2019 at 10:42 AM

    Good day Gil,

    You can build the form that would require customer verification to display form fields. To do so, you would need to apply conditional logic to form. Please review related help guides below:

    Smart-Forms-Using-Conditional-Logic

    Conditional-Logic-for-Online-Forms

    How-to-Show-or-Hide-Fields-Base-on-User-s-Answer

    If you encounter difficulties while setting up such form, please let us know and we will gladly take a look.

  • gilparrish
    Replied on July 13, 2019 at 11:43 AM
    Thanks, but not exactly what I need…Let me give you an example:
    You complete a registration form that requires your name and a “membership number” (unique).
    When the form is submitted, it automatically queries a database to see if the name and membership number provided on the form match a registered member of the organization. If it does, then the form is revealed to them.
    Thanks!
    Gil

    ...
  • Victoria_K
    Replied on July 13, 2019 at 12:24 PM

    So, the goal is to check 'membership number' in an external database, right? 

    I think it is not quite possible at this time, but I need to clarify with you. How long is the list of numbers you have in a database? 

    If you have a comma separated list, you can still create a condition, which would check the list and show form fields in case of match, like this:

    Login will Query Database to Verify Membership Image 1 Screenshot 20