Forum Discussion
It sounds like account # is a lookup field, which cannot be used in a unique formula.
But the field for Related Parent] can be used in a unique formula because it is not a lookup field.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
HI Mark....I did try several different ways of writing the formula using Related Parent but it keeps coming back as not compatible to be unique. The field 'Visit Year' is a formula numeric field using the Date Created field. The concatenate field is Numeric Formula. Here is my formula which does not indicate any error until I click Unique and try to save
ToNumber([Related Home] & [Visit Year])
Error: This formula is incompatible with this field being marked unique. Please change the formula or uncheck the unique checkbox.
I have tried this also as Text formula - same response.
------------------------------
Amy Gosz
------------------------------