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