- thrivesocialAsked on December 23, 2017 at 08:18 AM
Hi JotForm Support,
I have searched all online and I want to purchase JotForm. However there's one question that I can't find the answer for.
Is it possible in jotform to check matching database value. For example: Check the username in the database before proceeding, so when people haven't submit that username they can't proceed and shows "Sorry, username is not found. Are you sure you are our client?" -- Something like that.
Thank you and looking forward to your reply.
- JotForm SupportRichie_PAnswered on December 23, 2017 at 08:41 AM
You can create a condition in where its gets the value of the user. Either by using the Show/Hide Field or Skip to / Hide a page.
Here is a sample skip to/ hide a page condition.
If the name is not equal to 1234 it will skip to the error page.
Here is a sample screen cast.
You can check this guide in creating smart forms using conditional logic. Smart-Forms-Using-Conditional-Logic
Here is my sample form, you can clone it to reference my sample.
A guide on cloning forms. How-to-Clone-an-Existing-Form-from-a-URL
Please let us know if we can be of further assistance.
- Ardian_LAnswered on December 23, 2017 at 10:13 AM
We do not have a built-in feature with that functionality but you can definitely use the form source code as the fundamental structure. Then modify the form source code and add your custom scripts that would perform the database checking.
Here's how to get your form source code: http://www.jotform.com/help/104-How-to-Download-a-Source-Code-of-your-Form
This PHP code will help: https://stackoverflow.com/questions/7286966/php-how-to-check-if-id-in-database-exists
Alternatively, if you want to use a spreadsheet file as the database containing the IDs, you can use this widget https://widgets.jotform.com/widget/spreadsheet_to_form.
If you have any other question please let us know.