Discussions

Expand all | Collapse all

Error says Field cannot be Unique

  • 1.  Error says Field cannot be Unique

    Posted 20 days ago
    I have a formula that I am getting an error on. The error says: This formula is incompatible with this field being marked unique. Please change the formula or uncheck the unique checkbox.

    This is my formula

    [Invoice #]&" - "&[Subcontractor/Supplier]

    I am combining two fields so that I can require the field to be unique. 

    What am I missing? 

    Thank you,

    Brandy

    ------------------------------
    Brandy Nunes
    ------------------------------


  • 2.  RE: Error says Field cannot be Unique

    Posted 20 days ago
    if [Subcontractor/Supplier] is a lookup field, you can try using 

    [Related Subcontractor] instead, so 

    List ("-", [Invoice#], ToText([Related Subcontractor]))


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