Hello everybody.
It’s really exciting to work on Kobocollect.
I still come back to you for several concerns, namely the difficulties I encounter in developing my form in Xls Form. I remember that I am a beginner.
Indeed, I would like to make a simple calculation of the total number of children by school level, which is reflected in yellow in the file, and then sum up all the levels.
I followed your advice and recommendations offered on the forum, but when I launch the overview test, it shows the following error that I cannot correct namely: {There has been a problem trying to replace $ {Quelle_de_Gar_ons_f_nt_la_classe_de_CP2_} with the XPath to the survey element named ‘Quelle_de_Gar_ons_f_nt_la_classe_de_CP2_’. There is no survey element with this name.} And this is the same for all school levels (CE1, CE2, CM1, and CM2) as well as all the other parts in yellow where I want to perform the calculations.
The second problem is at the level of the unique number I want to create for each household surveyed.
Please note that filling in a new form means that we are in the process of registering a new household. I would like an identifier for each household each time a new form is filled in to be generated automatically, so that it can be used as a database for extracting information.
To do this, I therefore followed the solution that you proposed on the forum with the concatenation formula of the sub-prefecture, the village and a 3-digit number that the investigator must inform. However, this does not work as expected. Could you help me with the file so that I can see and understand my error? This part is in green at the beginning of the Xls form.
Also, is it possible when opening a form to display the logo of our structure? If so, how should this be done?
I hope I have been explicit, I remain available for further explanations of my difficulties.
I attach the form and the screenshots of the difficulties encountered.
Thank you so muchProjet esycari2020_essai 1.xlsx (23.9 KB)