Flag Multiple Entries in Quickbase Table
I have a Quickbase table with 3 fields Customer Id, order Id, Book Id. I need to add a Formula field to flag records if the Book Id exists in the table with a multiple combination of Customer ID and ...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendWhat are the field ID#s for those two fields, respectively?
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
Customer Id (FId - 6), Order Id (FId- 7), Book Id (FId - 9)
------------------------------
Anitha Jeevarathinam
------------------------------
- MarkShnier__You
Are you trying to have the records know if there exists other records with the same values for all three fields?
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------No Mark if the Book Id exists as part of another order then we have to flag the Book id record - "MultipleOrderExistsFlag" as "Y".
CustID1 Order1 BookId1
CustID1 Order2 BookId2
CustID2 Order1 BookId1
In the example above, the 1st and 3rd rows should have the field "MultipleOrderExistsFlag" as "Y".
------------------------------
Anitha Jeevarathinam
------------------------------- MarkShnier__You
This should flag is there are duplicates for the same OrderID and BookID
var text QUERY =
"{7.EX." & [OrderID] & "}"
& " AND "
& "{9.EX.'" & [BookID] & "'}";
IF(SizeGetRecords($QUERY)) >1, "Y")But the formula is not looking at the Customer ID field.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------