Domino Code Fragment

Code Name*
Avoiding Duplicate Entries		Date*
04/28/2024		Source (or email address if you prefer)*
Rlatulippe@romac.com
IP address:.18.189.180.244
Description*
This formula simply avoids duplicate entries in any database.		Type*
Formula		Categories*
(Misc)
Implementation:
Required Client:
Server:
Limitations:
Comments:
852562A1:0063500A = Database (CompanyDup) = View Used
Files/Graphics attachments (if applicable): Code:
REM;"Looks up to a hidden view that already has existing clients and if found, cancels";
REM;"the operation";
If(@Matches(@DbColumn("" : "NoCache"; "852562A1:0063500A"; "(CompanyDup)"; 1);
@Trim(@ProperCase(Comp))); @Return(@Prompt([OK]; "Operation Cancelled"; "You already have a
Company Profile with this name in the Sales Tracker.")); "");