Error says Field cannot be Unique

Question

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

MarkShnierYou · Answer

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

Sign up

Login to the community