Announcements
Dear Experts,
LookUp formula can compare and detect exact match duplicated value:
However, What is the best way to detect "approximate match" duplicated value? I want to treat 123456789-1 as duplicated value with 123456789-01 or 123456789-001.
Hi @JAWL You can use lookup to check duplicate here is an sample app I have added for all scenarios including popup
If( IsBlank( LookUp( DataSource, InvoiceNumber = txtInvoiceNumber.Text ) ), "", Notify( "â›” Duplicate Invoice(s) Found " & LookUp( DataSource, InvoiceNumber = txtInvoiceNumber.Text ).Name & " - #" & txtName.Text, Error ); UpdateContext({varShowEdit: true}) )
Hi @Ramole
I cannot accept this as solution yet. What I want is for duplication rule to omit zeros. E.g. treat 123456789-01 as duplicate with 123456789-1.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Jump in, show your community spirit, and win prizes!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Valantis 483
WarrenBelz 399 Most Valuable Professional
11manish 327
