I’m trying to retrieve information from the different submissions in the database to be used for the current submission for calculation purposes but I don’t know how to go about it.
I give an example, during the previous submission, we entered the data for the month of January, February, March and April.
suppose that we are in the month of May, when filling out the month of May, I would like to calculate the sum of the previous values and display it before submitting.
Thank you for your future help
Welcome to the community, @samson_mww! You should be able to link two projects dynamically as outlined in this support article:
Yes thank you for your answer, I was able to read and adapt this to a new project,
but after linking the child project to the parent project, when I put the identifier, the elements of the parent project do not appear on the child form on enkoto online,
Parent.xlsx (17.0 KB)
Child.xlsx (14.6 KB)
here are my 2 parent and child projects
Yes, thank you for your reply. I was able to read and adapt this to a new project. However, after linking the child project to the parent project, when I enter the identifier, the elements of the parent project do not appear on the child form on enkoto online. Here are my two parent and child projects.
If you can help me, thank you very much.
I have two projects that I’d like to link using dynamic attachments. However, after linking the child project to the parent project, when I enter the identifier in the child project, the elements from the parent project don’t appear on the child form on Enketo Online.
The formula used in the calculation column: instance('submission')/root/data[group4/IdOrder=current()/../A_Code]/group1/group_information/fy
At the beginning of the child form, I entered xml-external in the type and submission in the name.
Submission is also the name given to the data import in the child project.
Here are my two parent and child projects.
Parent.xlsx (17.0 KB)
Child.xlsx (14.6 KB)
If you can help me, thank you very much.
