Is it possible to prevent duplicate entry from KoBoToolbox? As for example, a user fills up the ODK form by the email “john@gmail.com”. But when he again fills up that email (john@gmail.com) and wants to send the Finalized form to the server, Then it will not possible to submit the form to the server and inform me of the duplicate email entry. That means no one can send the same/duplicate email to the server.
1 Like
Hi,
The only way i see i to use the pre-loaded data in the media part of the form. This allow you to upload a csv of information (and it can be re-uploaded during survey implementation). And you use the Pull-´data fonction
What i do is to dowload the observation of the survey one day, change the form of it to keep for example someone’s name in the first column and a column of “Si” which is the indicator that the person belongs to the list,
Then in the survey i have a pulldata(‘csv’,‘is_sampled’,‘ID_key’,${particip_ID})
This results th ID=“Si” if tghat person is on the list and i make a relevant if different of si to continue the survey
The onloy problem is that it’s not automated, i have to download the data, change the form and upload the csv manually. It’s not such a problem as we deploy the form once every 3months but it may be a problem for you
Cheers and have fun!
Quentin
1 Like
@tanzilhuda, maybe you could use this approach discussed in our other post (that exploits the dynamic data attachment feature):
How to check in the same form.
https://ee.kobotoolbox.org/x/AHpjetYU
aMqdQ5SKwozdQAHuaR6dRo.xlsx (6.7 KB)
@tcltrust, maybe try using the same file shared in my previous post. You should be able to practice with the file, slowly understand the syntax, and customize as needed.
