I have LimeSurvey version 2.06+ Build 151 215 which runs on XAMPP
Step 1. Participants will begin the survey by entering a predetermined unique code that is written on a form.
Thereafter, the same code is to be entered again and compared with the first, to make sure no misspelling has occurred from paper. If the codes are different, the error message is displayed and the first question is to be asked again.
Step 2. If the two entered codes match, it shall be a lookup in a database to verify that the code is there, which ensures that there is a code that is printed on a form (an actual existing code).
If the code is found, the survey should start, otherwise, the error message is displayed and the first question to be asked again (asking for entering the code).
I would like help with:
How to create questions that controls the two inputs for the code? (step 1.)
How do solve lookups in the database (to verify that the code exists)? (step 2.)
Should I use tokens to solve step 2. above?
The code should be visible to the user when entered in the field.
I am a novice at Limesurvey so I need help, how to code and where everything need to be inserted.
The database is created in MySQL and filled with data from an Excel file with over 10,000 lines.
CREATE DATABASE `id_no`
CREATE TABLE `id` (
`recno` int(11) NOT NULL,
`id_no` varchar(15) NOT NULL,
PRIMARY KEY (`id_no`),
UNIQUE KEY `idx_id_id_no` (`id_no`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
The topic has been locked.