How to fill data from another field

type name label
integer hh_id_num Please enter the household ID
integer group_id

how can I fill group_id with hh_id_num data ?

thanks in a heap and have a great day

Hi @dheniardhian,

Correct me if i got you correctly. Do you mean you wish to design your survey form like the one as shown in the image below. If yes, you could do the same as follows:

In the survey tab of your xlsform:
Image 101

Data entry screen as seen in Enketo:

Reference xlsform:
Sample.xlsx (9.6 KB)

Have a great day!

1 Like

Yes, it works.
I incorporate group question.
I use the household ID as a unique id, to join the data on the 1st excel sheet and 2nd sheet (group output).

Thanks a lot @Kal_Lam

2 Likes

Hi @dheniardhian,

Glad to know that it worked for you!

Have a great day!

1 Like


@Kal_Lam, I just learnt that integer is not sufficient for 16 char household ID, therefore I change the type into text, numbers as appearance.

type name label
text QT1 Please enter the household ID
text QT2 Please enter the group ID (household ID)

since calculation is solely for integer, how can I push QT1 value into QT2 ?

Hi @dheniardhian
You can add the calculation onto the Q3 even when it is a text try adding concat(“0”,${Q2}) and it should work for you.

Stephane

1 Like

It works, thank you very much indeed @stephanealoo , it’s a relief… I spent the whole day trying resolve it.

have a great evening, it’s already midnight in Indonesia

2 Likes

@Kal_Lam, problem’s resolved… :relaxed:

1 Like

Glad to know it worked for you. Enjoy your evening sir.

1 Like

Is it possible from design interface?

Welcome to the community, @AbdullahSallam! The best workaround would be to upload your xlsform and then try to edit the survey project through the form builder UI. If you see all the required fields and variables needed the answer to your query is yes else the answer to your query would be no.