Merging forms

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?

Many thanks,
Maya

Hi Maya,

There may be more efficient ways to do it, but one approach would be to use
a VLOOKUP. The general approach is described here:
https://confluence.dimagi.com/display/commcarepublic/Using+Lookups

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?

Many thanks,
Maya


You received this message because you are subscribed to the Google Groups
"commcare-users" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to commcare-users+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


Jeremy Wacksman
Dimagi http://www.dimagi.com, Inc.