@anilgnydn Can you give an example of what is your intented result and how is your formula not working?
1st beneficiary Information
Name=ANIL
Surname=GĂNAYDIN
Motherâs Name= AYĆE
Fatherâs Name= HASAN
2nd beneficiary Information
Name=ANIL
Surname=GĂNAYDIN
Motherâs Name= AYĆE
Fatherâs Name= AHMET
Normally these two beneficiaries are not duplicate because their fatherâs name are different but there is a previously registered beneficiariy whose fatherâs name is âAHMETâ so my formula think this example as duplicate. I am sharing the information of the people I am trying to register and the people registered in the database, essentially I should not receive a warning message, but I do.
@anilgnydn I see your point. Thatâs why we use Unique IDâs at the first place
As a workaround, I think using concat
to concatenate all answers first then checking for duplication might work, for concat
you can check here: Form Operators and Functions - ODK Docs
Thank you for your support @hakan_cetinkaya much appriciated. Regarding Unique ID, in our cases its a number that is automatically generated when the form is opened so we often face same beneficiary with different ID number.
And finally, here I have good news, the concat function worked properly and it was exactly what I have been looking for until now. Please kindly find attached xls document on âDuplicate beneficiary detection and displaying warning messageâ.
If Dynamic Data Attachment function works faster one day, the formula will work more efficiently.
Detecting Duplication With Concat.xlsx (9.6 KB)