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)