Forum Discussion
MarkShnier__You
Qrew Legend
3 years agotry this as a formula Checkbox field type. Replace the 232 with the field which is the potential duplicate and of course use your own fields in the square brackets.
var text QUERY =
"{232.EX." & [Possible duplicate field] & "}"
var bool LookForDuplicates =
Size(
GetRecords($QUERY)) >1;
IF([my checkbox field]=false, $LookForDuplicates)
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
var text QUERY =
"{232.EX." & [Possible duplicate field] & "}"
var bool LookForDuplicates =
Size(
GetRecords($QUERY)) >1;
IF([my checkbox field]=false, $LookForDuplicates)
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
BrianDunk
3 years agoQrew Cadet
Hey Mark quick question on this. If I wanted to add another checkbox to my form to control whether to check for duplicates or not could I add the following code to my "Dupicate" formula field?
The code currently is the following:
var text QUERY = "{6.EX." & [Container Number] & "}";
var bool LookForDuplicates = Size(GetRecords($QUERY))>1;
If([Domestic]=false, $LookForDuplicates)
Could I add the following to add another checkbox called "Consolidated Shipment" to control whether to look for duplicates?
If([Consolidated Shipment]=false, $LookForDuplicates)
Thanks
Brian
------------------------------
Brian Dunk
------------------------------
The code currently is the following:
var text QUERY = "{6.EX." & [Container Number] & "}";
var bool LookForDuplicates = Size(GetRecords($QUERY))>1;
If([Domestic]=false, $LookForDuplicates)
Could I add the following to add another checkbox called "Consolidated Shipment" to control whether to look for duplicates?
If([Consolidated Shipment]=false, $LookForDuplicates)
Thanks
Brian
------------------------------
Brian Dunk
------------------------------
- MarkShnier__You3 years ago
Qrew Legend
looks right to me, give it a try.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------- BrianDunk3 years agoQrew CadetHi Mark, so I tried adding that IF statement and it gave me an error so I went with the following but I am not so sure it is working as I hoped. Can you tell me if this would be correct?
var text QUERY = "{6.EX." & [Container Number] & "}";
var bool LookForDuplicates = Size(GetRecords($QUERY))>1;
If([Domestic]or[Consolidated Shipment]=false, $LookForDuplicates)
------------------------------
Brian Dunk
------------------------------- MarkShnier__You3 years ago
Qrew Legend
If there is an error you need to copy and paste the error.
As for the logic, can you say in words when you want to check for duplicates? Under what conditions?
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------