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

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

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/