Avoiding duplicate records

Hi Marcelo,

The server does not check for those kind of duplicates, once a record is saved, a unique _uuid is created, which is used to avoid duplicates on submission.

For your case, maybe you can create a concat instance field, used to save the form, under settings sheet, you can add a new column (instance_name) then enter concat(string(today()),‘-’,‘${date},’-',${site}), so each submission will have this as its default name. When you export the data in either csv/excel, there’ll be this column “meta/instanceName” that you can use to check for duplicates, or;

If you are good in R, you can use the duplicates function…

···

On Tue, Aug 7, 2018 at 5:21 PM, Marcelo &JM marcelo...@gmail.com wrote:

Dear all,
I have a form which should be submitted on a daily basis, so i need to avoid duplicating data of the same "date "and “site” (date and site are part of the form’s questions).

let me know if this is not clear and to provide more details.

Many thanks,

Joao

You received this message because you are subscribed to the Google Groups “KoBoToolbox Users” group.

To unsubscribe from this group and stop receiving emails from it, send an email to kobo-users+unsubscribe@googlegroups.com.

To post to this group, send email to kobo-...@googlegroups.com.

Visit this group at https://groups.google.com/group/kobo-users.

For more options, visit https://groups.google.com/d/optout.

Regards,

Jonathan Munene

+254 714 345 760

https://muneneg.github.io/resume/