Forum Discussion

AnithaJeevarath's avatar
AnithaJeevarath
Qrew Cadet
2 years ago

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 Order Id. How Can i Achieve this?



------------------------------
Anitha Jeevarathinam
------------------------------
  • What are the field ID#s for those two fields, respectively?



    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------
    • AnithaJeevarath's avatar
      AnithaJeevarath
      Qrew Cadet

      Customer Id (FId - 6), Order Id (FId- 7), Book Id (FId - 9)



      ------------------------------
      Anitha Jeevarathinam
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend

        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
        ------------------------------