Getting Started

Expand all | Collapse all

Unique Identifier on Multiple Fields

  • 1.  Unique Identifier on Multiple Fields

    Posted 10-22-2019 16:15
    Hi,
    Is there a way to set up your Unique Identifier (key) based on multiple field combination? i.e., If I have fields User and Date, I want to restrict to have a specific user on a specific date only once. Same user should only have one record with same date in that table.
    In most databases, that's pretty much standard feature to define your own Key based on combination of fields, but could not figure out how to handle this in QB. Any thoughts?
    Thanks in advance.

    ------------------------------
    Muhammad Ghazali
    ------------------------------


  • 2.  RE: Unique Identifier on Multiple Fields

    Posted 10-24-2019 09:02
    Conversation on this question happened in question linked below:

    https://community.quickbase.com/communities/community-home/digestviewer/viewthread?GroupId=103&MessageKey=f32d0a83-bb7c-4715-87c4-c069a31dbac8&CommunityKey=d860b0f8-6a48-487b-b346-44c47a19a804&tab=digestviewer&ReturnUrl=%2fbrowse%2fallrecentposts

    ------------------------------
    Evan Martinez
    Community Marketing Manager
    Quick Base
    ------------------------------