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:
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
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… 
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.
