Forum Discussion

BrandyNunes1's avatar
BrandyNunes1
Qrew Member
4 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
------------------------------
Formulas and functions
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    4 years 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
    ------------------------------