How to have more than 20 options using SQL lookup

BF Survey and BF Survey Pro each have 20 option fields for the choices. If you need more than that, you can achieve this using BF Survey Pro with the SQL Command field to lookup from a database table, where you can have as many options as you like as you like.
For example:

You just need a basic mySQL table to store the options


CREATE TABLE `jos_bfsurvey_pro_example` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `choices` varchar(255) NOT NULL,
  PRIMARY KEY  (`id`)
);


INSERT INTO `jos_bfsurvey_pro_example` (`id`, `choices`) VALUES
(1, 'High'),
(2, 'Acceptable'),
(3, 'Low');


Please note that field validation (for radio & checkbox question types) will timeout and not work correctly if there are too many options, but it should still work ok as long as you don't go overboard with too many options.

 

 

Try our software on your own website to see if it will suit your needs....yours FREE