check for duplicates

Reg: the phone validation:

krileon wrote: The query validation is per field. So if you want to validate your phone field you need to edit your phone field in CB > Field Management then add query validation specifically for it. Example as follows.

I'm not sure if I understand. The problem as I see it:
each field has two possible validations: 1) PERL regex and 2) CB QUERY FIELD
I'm using PERL regex to validate against the proper phone input, forcing only the format: (999) 999-9999 and CB QUERY to validate against possible duplicate values.

The fields will validate correctly (in respect to each validation) with ONLY ONE ACTIVE QUERY - either the PERL (custom regex) or CB QUERY

If I try to turn both queries - nothing happens and I can't save the record.

Are you saying, or should I understand that each field can only validate one query?
Please advise if there is a way to validate the field as in above scenario - thanks!

~~~
CORRECTION:
hmm... I was under impression that my regex is correct (tested here: regex101.com/#pcre ): ... and woud swore that it worked in front-end when tested (interestingly, I have observed, that if I test the form logged in the front-end as super-user, all works fine, BUT once I started testing it in the back-end, I noticed the issue...)

so maybe the issue is in the regex not being written correctly (?) so if regex would have validate, the whole problem has nothing to do with the two validation running on the same form (?) - hmmm.... any thoughts? thanks!

azjr wrote: Reg: the phone validation:
CORRECTION:
hmm... I was under impression that my regex is correct (tested here: regex101.com/#pcre )...
... so maybe the issue is in the regex not being written correctly (?)

OK - I got it: it was the custom regex.
the PERL regex that works and forces the phone entry in the format "(999) 999-9999 (for US phone##) AND WORKS with the CB QUERY field:

I have proven (maybe just to myself and the hard way) that indeed both PERL and CB QUERY can work well together without conflict (tada!)
Now, let's go skydiving... enough time in front of computer - happy Labor Day to those in the US!

after user provides the email (the required one), there are 3 more email fields (optional): email2,email3,email4 - so if user attempts to enter the same email address into any of those fields, user should get the error validation.

CB Query Field can't help with that as nothing has been stored yet. You'd need a custom jQuery validate rule to be testing for that or just some custom jQuery in general.

You could use CB Auto Actions and its Code action to add jQuery to the before registration from trigger then write some jQuery to make sure they don't fill in your email fields with a value they've already supplied to the others.