Skip to main content
Question

Composite Index for Quick Base Table

  • Oct 18, 2019 7:21 PM UTC
  • 0 replies
  • 165 views
Hello,

I have a table named Certifications which has 2 parent tables: Publishers and Formats. I need to ensure there are no duplicate combinations between publishers and formats. So what I tried was to create a formula-text field and concatenate the Related Publisher and Related Format, then set it to unique. Quick Base won't let me set that formula field to unique.

Users will be creating certifications on the fly, and I need to make sure that if a certain format is already certified for a certain publisher, they cannot create a new/duplicate certification.

How can I create a composite key field (2 fields that, when combined, are unique) for my table?

------------------------------
Rachel Jones
------------------------------
    This topic has been closed for replies.

    • RobinGold
    • Qrew Member
    • Oct 18, 2019 7:29 PM UTC
    Oops - disregard my answer.
    EverettPatterso
    Forum|alt.badge.img+10
    Are you using a formula rich text or formula text? Is it giving you an error? Do you see the checkbox Must be unique and does it check your existing entries, maybe you have some duplicates in the mix already?

    It should work just fine on a formula text field. 



    ------------------------------
    Everett Patterson
    ------------------------------
    Terms & ConditionsAccessibility statement