Forum Discussion

BrandyNunes1's avatar
BrandyNunes1
Qrew Member
3 years ago

Error says Field cannot be Unique

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

1 Reply

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