Discussions

Expand all | Collapse all

How to make a record unique

  • 1.  How to make a record unique

    Posted 15 days ago
    I have a table with multiple columns in it. Each column may have repeated values but each record (a row) must not be repeated. Is there any way to make this possible ?

    ------------------------------
    Aswin Babu
    ------------------------------


  • 2.  RE: How to make a record unique

    Posted 15 days ago
    np,
    just make a formula which will concatenate the fields together and mark it as Unique in field properties.

    List("-", [field 1], [Field 2], [field 3])

    note that you make not use lookup or summary fields in that formula.

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------



  • 3.  RE: How to make a record unique

    Posted 15 days ago
    Thats the challenge. I will have to use the look up fields , is there any other way to achieve this

    ------------------------------
    Aswin Babu
    ------------------------------



  • 4.  RE: How to make a record unique

    Posted 15 days ago
    np,
    you may not use a lookup field, but you may use the reference field.

    so for example

    ToText([Related Parent])

     would be valid to use in the string.

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------



  • 5.  RE: How to make a record unique

    Posted 15 days ago
    Okay. Let me try this then. Thank you Mark

    --
    Regards
    Aswin Babu