Need clean output of the content of a full form... but showing the answer codes too

Hi folks –

I am in a situation where I want to create a nice full output of our forms,
so that my team can review the forms and ensure their function…

But part of the output I need for this review will also be the codes that
relate to the answer categories.

I’ve found that none of the “export forms” or “summary forms” features
allow the questions/answers labels AND the simple codes to appear
conveniently in the same output.

1–> if I use the “Form Summary” feature, that has a switch that will
EITHER output the labels OR the codes, but not together. (and as a side
note, when I go to copy and paste that form summary, it is a bit annoying
as your output adds its own sequential numbering to each item, which then
stands next to the numbering that I have put into my text… sure wish
yours didn’t insert numbers beside items.)

2–> if I use “export forms content” from inside the forms builder for that
form, it has almost everything but it doesn’t have an entry simply showing
the answer coding. You have to discern them by looking at the end of the
string of the “question” string…
… it is strange and not really always workable to tell my team "if
you want to know the code of a given answer item, please look at the string
for that row in the column called “question” and then you can see that
portion of the string that extends after the title of the string used for
the question itself… is the code
.

The quickest fix for this would be improve item (2) above. To make just a
smallish change to the “Export form content” command, so that at the end of
each row in the output, it added a new column which would be the coding for
that line, on its own… like “10” or “positive” or what have you. Just
the code…

Any chance that adjustment could be made to the export form content command?

thanks!
Eric

Hey Eric,

That’s a good idea - i would suggest posting it on our UV forum.

In the meantime, it should be relatively simple in Excel to extract the
code in a new column. if you’re using Extract Form Contents.
=IF(B2=“Choice”, TRIM(MID(A2, FIND("-",A2)+1, 100)), “”)

Thanks,
Sheel

··· On Thu, Feb 11, 2016 at 12:58 AM, Eric Stephan wrote:

Hi folks –

I am in a situation where I want to create a nice full output of our
forms, so that my team can review the forms and ensure their function…

But part of the output I need for this review will also be the codes
that relate to the answer categories.

I’ve found that none of the “export forms” or “summary forms” features
allow the questions/answers labels AND the simple codes to appear
conveniently in the same output.

1–> if I use the “Form Summary” feature, that has a switch that will
EITHER output the labels OR the codes, but not together. (and as a side
note, when I go to copy and paste that form summary, it is a bit annoying
as your output adds its own sequential numbering to each item, which then
stands next to the numbering that I have put into my text… sure wish
yours didn’t insert numbers beside items.)

2–> if I use “export forms content” from inside the forms builder for
that form, it has almost everything but it doesn’t have an entry simply
showing the answer coding. You have to discern them by looking at the end
of the string of the “question” string…
… it is strange and not really always workable to tell my team "if
you want to know the code of a given answer item, please look at the string
for that row in the column called “question” and then you can see that
portion of the string that extends after the title of the string used for
the question itself… is the code
.

The quickest fix for this would be improve item (2) above. To make just
a smallish change to the “Export form content” command, so that at the end
of each row in the output, it added a new column which would be the coding
for that line, on its own… like “10” or “positive” or what have you.
Just the code…

Any chance that adjustment could be made to the export form content
command?

thanks!
Eric


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.


Sheel Shah
Project Manager | Dimagi
m: +1.781.428.5419 | skype: sheel_shah

Hi Eric,

It’s made for ODK, but I’ve used this little program before that scripts a
nice human readable “codebook” with the text of the questions, question
IDs, etc.
https://nafundi.com/blog/posts/nafundi-and-task-force-release-codebook-generator-for-odk/

You have to download the xform and then upload it into the program. It’s
not perfect because of CommCare’s added functionality, but it helps. (Also
haven’t used it recently, full disclosure.)

S

··· On Thursday, February 11, 2016 at 5:58:52 AM UTC, Eric Stephan wrote: > > > Hi folks -- > > I am in a situation where I want to create a nice full output of our > forms, so that my team can review the forms and ensure their function... > > But part of the output I need for this review will also be the *codes* > that relate to the answer categories. > > I've found that none of the "export forms" or "summary forms" features > allow the questions/answers labels AND the simple codes to appear > conveniently in the same output. > > 1--> if I use the "Form Summary" feature, that has a switch that will > EITHER output the labels OR the codes, but not together. (and as a side > note, when I go to copy and paste that form summary, it is a bit annoying > as your output adds its own sequential numbering to each item, which then > stands next to the numbering that I have put into my text... sure wish > yours didn't insert numbers beside items.) > > 2--> if I use "export forms content" from inside the forms builder for > that form, it has almost everything but it doesn't have an entry simply > showing the answer coding. You have to discern them by looking at the end > of the string of the "question" string... > ... it is strange and not really always workable to tell my team "*if > you want to know the code of a given answer item, please look at the string > for that row in the column called "question" and then you can see that > portion of the string that extends after the title of the string used for > the question itself... is the code*. > > The quickest fix for this would be improve item (2) above. To make just > a smallish change to the "Export form content" command, so that at the end > of each row in the output, it added a new column which would be the coding > for that line, on its own.... like "10" or "positive" or what have you. > Just the code... > > Any chance that adjustment could be made to the export form content > command? > > thanks! > Eric > > >

That looks intriguing, I will take a look!

Thanks!
Eric