The QR code is a combination of a large information like age, name, Id, location,. I need only id ,
will there work text function of excel?
Kal_Lam
September 30, 2021, 5:02pm
2
Welcome to the community, @Hasibul_E ! Have you gone through our previously discussed post? It should help you solve your issue:
Hi @henryakuete ,
Please see the images below to build a survey form that uses barcode as question type to pull data from the csv file. You could practice this by replacing the barcode (Code) of the csv file with the ones that you have from any of your books (this is the one that i had them with me). Just wanted to show you a demo that if you have a barcode number, you could manage them in your csv file and use the pull data function to get the desired information during your survey.
Image 1 (i…
Thank you very much for your response. I have got the solution by studying ODK string function. it looks like javascript function. I used strslice(${bar_c},12,25) … it provide the output to characters between 12 and 25. that was my need.
Thanks a lot
1 Like
@Hasibul_E , was curious to know more about strslice
function. Or is it the substr
function you used as outlined in the post discussed previously:
@finercia_americo , this could be a bit complex but you could do it as outlined in the image shared below:
In the survey tab of your xlsform:
[Image 1]
Data entry screen as seen in Enketo: when a wrong entry is made
[Image 2]
Data entry screen as seen in Enketo: when a correct entry is made
[Image 3]
Data entry screen as seen in Enketo: when a wrong entry is made
[Image 4]
Data entry screen as seen in Enketo: when a correct entry is made
[Image 5]
Reference xlsform:
Regex.xls…