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