Barcode scanning and link with database

[tasfik_rukan]

I have a database of more than 10000 people of a camp where lives more than 500000 people. All people have one ID card with barcode which contains these information: MoHA number (unique), SCOPE number (unique), Family Counting Number (Unique for each family), Name, date of birth, nationality.
I want to scan barcode of those people. I also want to link my database with my kobo forms. Is it possible to add any database link with form? If so, while scanning barcode, I need two constraints: 1. While scanning, data collector will be able to scan only those barcode which exist in my database. 2. Data collector won’t be able to scan one barcode more than once. Based on my database, is these constraints and linking possible? Your support will be highly appreciated.

[Kal_Lam]

Welcome to the community @tasfik_rukan! Would you mind having a look at the post discussed previously, it should solve your issue:

Data is lost when correcting data in a submitted form

FYI, i just made a check and could reproduce your issue. It seems like when you have an information filled using the pulldata function in your survey form you don’t see the same while editing it in the KoBoToolbox server. FYI, Data is seen in the KoBoToolbox server: [Image 1] The same data is missing while trying to edit through Enketo: [Image 2] Will get back to you once we are confirm it it’s an issue related to KoBoToolbox or Enketo.

Now, response to your query:

@tasfik_rukan

I need two constraints: 1. While scanning, data collector will be able to scan only those barcode which exist in my database.

This is possible if you follow the instruction as outlined in the post shared above keeping some constraint in your xlsfrom.

@tasfik_rukan

2. Data collector won’t be able to scan one barcode more than once. Based on my database, is these constraints and linking possible?

This however is not possible at the moment. Maybe you can remove the duplicates if occurred within the dataset while during the data cleaning phase.

[lansah]

@tasfik_rukan

I have a database of more than 10000 people of a camp where lives more than 500000 people. All people have one ID card with barcode which contains these information: MoHA number (unique), SCOPE number (unique), Family Counting Number (Unique for each family), Name, date of birth, nationality.
I want to scan barcode of those people. I also want to link my database with my kobo forms. Is it possible to add any database link with form? If so, while scanning barcode, I need two constraints: 1. While scanning, data collector will be able to scan only those barcode which exist in my database. 2. Data collector won’t be able to scan one barcode more than once. Based on my database, is these constraints and linking possible? Your support will be highly appreciated.

Thanks for solution.