Can anybody help me out in generating a predefined code generator based on province, district, health facility, appended by auto number.. i have inserted the code in the bottom, but it’s not working.
Secondly, how i can add a repeat group based on the child and its vaccination.
EPI_Vaccination_Form.xlsx (20.4 KB)
could anybody please update the sheet?
EPI_Vaccination_Form.xlsx (15.4 KB)
For the child ID code please check this .
Also you need to rework on you arrangement
I dont understand the second part of your question. can elaborate more
Hi pruzige;
My requirement is I have a child section in the repeat group clause. Which is getting the Age/DOB (row 25) of a child along with the vaccine dates provided. Condition is if a vaccine provided date is before the date of birth, it will not allow for capturing the date ( this has been implemented successfully).
The problem that I am facing is that when multiple child’s along with vaccine dates are entered the same criteria should be applicable, which I have mentioned above for all child’s and its vaccines. But on mobile when entered its shows me the error message that “ try to use the indexed-repeat()” function. For a ready reference I am sharing my xls form kindly do help me out in this matter.
EPI_Vaccination_Form1.xlsx (20.7 KB)
Hi, thanks for sharing the formula to generate the child code its wokring perfectly fine but one issue which i am stil facing is that i am using this in repeat group as 1 vaccinator will be providing vaccine to more than 1 child and we have target number which i have mentioned in Row 19 question of my survey sheet based on this number vaccinator will be delivering vaccines to child.
For now it generate 1 id for all children what if based on adding vaccine to each child it gives a new ID obviously the first three parrtens like " province-District-Healthfacility" will be same just Child ID will be changed each time. could you please look at the file and edit wherever required?
best
jibran
EPI_Vaccination_Form.xlsx (20.9 KB)
See updates on the Child Code. Just Utilize za position(..) function to get the index of the repeat for each child and incorporate it into the formula to calculate the ID. It will give unique ID for each child , see attached form. while am working on your repeat question (OUTSIDE REPEAT)
Also make sure the child ID is being calculated inside the repeat group (I reccomend this)
EPI_Vaccination_Form (2)-inside repeaat.xlsx (20.7 KB)
Am trying to understand but its like i’missing something; from my opinion
why not put all the questions within the repeat the group.
If you want to to refference a thing outside the repeat group you should use indexed-repeat. which to me is kind of trouble for nothing because you can just put the questions inside a repeat group and ask them whole at once per child,
Mind you question in Vaccination Details group are not in repeat group thus they will be asked once and not to a specif child.
see attached form if works for you. am available for more discussion
EPI_Vaccination_Form (2)-inside repeaat_update.xlsx (20.7 KB)
It doesn’t matter whether it is inside repeat or outside repeat, all I need is the output. if you say it should be inside then its also work for me
Test this form
Dear Pruzige;
Much appreciated now its working as per criteria. bundle of thanks stay blessed.
Best
Jibran
