In case of multiple form entries for a case, pick out the latest one automatically

Users
#1

Hi,

Could anyone please suggest how to overcome an issue I am facing after
using case logic? Basically, in a health related app, I have designed the
forms in such a way that for the same case, a particular form can be filled
multiple times by a user. So, when I download the data in excel, I get
multiple rows with the same case ID. Is there a way to keep only the row
with the latest form completion time and discard the other prior entries? I
want this to happen automatically in Commcare data exports or if in Excel,
using pre-defined formulae. Kindly let me know. Thanks in advance.

Regards,
Nikhil

#2

Hi Nikhil,

thanks for your answer. If you don’t need the history and want to see only
the latest status of your properties you can use a case exports. You can
read more about it here
https://confluence.dimagi.com/display/commcarepublic/Case+Data+Export

Please note that to be able to make a case export you will need to save the
questions in your form as case properties.

best,

Fio

··· On Wed, Oct 28, 2015 at 8:57 AM, wrote:

Hi,

Could anyone please suggest how to overcome an issue I am facing after
using case logic? Basically, in a health related app, I have designed the
forms in such a way that for the same case, a particular form can be filled
multiple times by a user. So, when I download the data in excel, I get
multiple rows with the same case ID. Is there a way to keep only the row
with the latest form completion time and discard the other prior entries? I
want this to happen automatically in Commcare data exports or if in Excel,
using pre-defined formulae. Kindly let me know. Thanks in advance.

Regards,
Nikhil

–
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.

–
Fiorenzo Conte
Senior Project Manager
West Africa | Afrique de l’Ouest
Dimagi, Inc
m Senegal : +221 77 293 91 89 | m Kenya: +254 706 970567
s : fioreco86
http://www.dimagi.com/