We are using CommCare to monitor postpartum family planning counselling and
post-partum IUD (PPIUD) insertion, in our app we have 4 forms in one module:
Registration
Part A (identification details)
Part B (questions on quality of counselling and family planning choices)
Part C (information regarding insertion of a PPIUD)
Registration, Part A and Part B is filled out for all women. Part C is only
filled out for women who have chosen to have a PPIUD (their choice is
recorded in Part B and the case is closed if she does not chose to have
one).
We would like to be able to create an excel spreadsheet that has all the
data from the forms on one sheet. For the first 3 forms this is not a
problem but is there a way to get the Part C form to link to the relevant
case without having to manually go through each case ID?
As a most basic example we would like a spreadsheet that incorporates all
forms like this:
Case ID Name (Part A) Received counselling (Part B) Chose to
have PPIUD (Part B) PPIUD inserted (Part C)
1234 ABC Yes
No
2345 BCD Yes
Yes Yes
3456 CDE No
No
4567 DEF Yes
Yes No
I know it is not possible to download the data from CommCare onto one sheet
but does anyone know of any excel functions we can use to enable us to do
this?
This would use the case id to match rows and then you can automatically
pull over data from Part C into your main spreadsheet.
Jeremy
ยทยทยท
On Thu, Jan 21, 2016 at 11:21 AM, Maya Sethi wrote:
Hi there,
We are using CommCare to monitor postpartum family planning counselling
and post-partum IUD (PPIUD) insertion, in our app we have 4 forms in one
module:
Registration
Part A (identification details)
Part B (questions on quality of counselling and family planning choices)
Part C (information regarding insertion of a PPIUD)
Registration, Part A and Part B is filled out for all women. Part C is
only filled out for women who have chosen to have a PPIUD (their choice is
recorded in Part B and the case is closed if she does not chose to have
one).
We would like to be able to create an excel spreadsheet that has all the
data from the forms on one sheet. For the first 3 forms this is not a
problem but is there a way to get the Part C form to link to the relevant
case without having to manually go through each case ID?
As a most basic example we would like a spreadsheet that incorporates all
forms like this:
Case ID Name (Part A) Received counselling (Part B) Chose to
have PPIUD (Part B) PPIUD inserted (Part C)
1234 ABC Yes
No
2345 BCD Yes
Yes Yes
3456 CDE No
No
4567 DEF Yes
Yes No
I know it is not possible to download the data from CommCare onto one
sheet but does anyone know of any excel functions we can use to enable us
to do this?