Providing a form number to a submitted form

[mohammedrezeq]

Hello dear friends,
I am trying to find out a way to give certain serial code for each questionnaire that is filled by the staff in field.
i am thinking in two ways of solving that, and don’t know which one is working in kobo.
The first:
to generate automatic serial code which can be done by Kobo using any type of equations or restrictions;
The second: if i can previously uploading data to kobo, and then when the staff in field insert the name of the respondent, the kobo generate an equation to retrieve the code associated with the name from the previous uploaded data.

Please your help and thanks in advance.

[Kal_Lam]

Hi @mohammedrezeq,

Would you mind going through the support article How to: Create Sequential, Unique Serial Numbers. It should help you sort out your issue.

Alternatively you could also have a look at the discussion discussed earlier, which should provide you some insights:

Automatically displaying unique ID number

Dear Experts, I am not a programmer though I am preparing a XLSForm for data collection. I caught in a trouble when developing the form. The problem I am facing is, Automatic display of Household Identification Number in a box. For example, Region Name: Barisal District Name: Chandgaon Cluster Name: Rahalia Village Name: Pandgaon Household Serial Number: 0012 Household Identification Number will be: 3 letter for Region Name-3 letter of District Name-3 letter of Cluster Name-3 letter of …

GOOD DAY!

[stephanealoo]

Hi @mohammedrezeq
I would like to build on the response provided by @Kal_Lam with specific structure as below

@mohammedrezeq

I am trying to find out a way to give certain serial code for each questionnaire that is filled by the staff in field.
i am thinking in two ways of solving that, and don’t know which one is working in kobo.
The first:
to generate automatic serial code which can be done by Kobo using any type of equations or restrictions;

You should use the method specifically mentioned by @Kal_Lam to do this. How to: Create Sequential, Unique Serial Numbers .

On the second part of your “alternative solution”

@mohammedrezeq

The second: if i can previously uploading data to kobo, and then when the staff in field insert the name of the respondent, the kobo generate an equation to retrieve the code associated with the name from the previous uploaded dat

You will need to use a functionality known as pull data functionality which is explained within the article which can be found here

Regards
Stephane

[mohammedrezeq]

@stephanealoo

pull data functionality

Thank you dear, it works effectively…

[mohammedrezeq]

Thank you dear, …

i just wanted to ask if there is any example existed to know how can i do it better.

[stephanealoo]

Hi @mohammedrezeq
You should be able to find the explanation self explanatory that it makes it very easy for you to customize it. Unfortunately we may not have a bandwidth to create an example that fits every users iteration, we however provide all the information needed for a user to iterate as much as possible. Reach out if you are stuck on a specific step and we will help you out.

Stephane

[mohammedrezeq]

Thank you dear,
I tried many times, but it i did not go well, even though i almost took the same structure of the questions in the link.

i don’t know if i can upload photos to show you if you have any recommendation, i will appreciate that.

[stephanealoo]

Hi @mohammedrezeq
Sure you can post the photos you have that will help us identify your issue more clearly.

Stephane

[mohammedrezeq]

Thank you dear, here are two two photos for the two files

please, let me know where i did wrong

[mohammedrezeq]

and here i did uploaded the CSV file

[stephanealoo]

Hi @mohammedrezeq
Out of curiosity, what are you using for data collection is it web forms or the collect application on the phone? If web forms, then you should note that pull data does not work on web forms and this could be the issue that is causing this.

As I look at your scripting, this looks fine.

Stephane

[mohammedrezeq]

Hi @stephanealoo
But in the pulldata webpage in the link you shared it is written that it works in the enketoo.
I will try in the kobo app.
Thank you again

[mohammedrezeq]

And unfortunately, it is not also working by the App