I want to validate the one field of my Formidable forms with my mysql database. I am having one filed with company_name and I want to check that the entered company name is already exists in database or not. The following guide tell you how to do it without any codes.
Step 1, export your database data to CSV.
Open your database table in your database manager such as phpmyadmin.
Export the database table to CSV format.
Open the CSV file and remove all columns except the name column.
Also delete the first row as it is database field name.
Step 2, Create a white list and import the CSV file.
Install the plugin of BSK Forms Blacklist to your WordPress.
Create a white list and chose to import items / keywords from
After importing you'll see all database records listed there.
Step 3, Open your formidable forms and apply the list to form field.
Open your formidable form to edit, focus on the field that you'd like to validate.
You'll see BSK Blacklist option on left.
Choose the white list you created.
Step 4, it shows error message if the entered data not in the list
The above way has some inconvenience is needing to synchronize the database table records with BSK Forms white list items. But it is OK if your company name list won't be changed frequently.