HarrisonSmith
3 years agoQrew Trainee
You cannot create a field that references the Record ID field and that requires unique values.
I have a formula field that concatenates a few different fields into 1 value, one of which is the record ID. That's working fine. But when I try to set the "must be unique" checkbox on the formula text field I get the following error:
You cannot create a field that references the Record ID field and that requires unique values. Please change your formula to not reference the Record ID field or uncheck the unique checkbox.
My question is... why? A record ID by definition is unique, so why can't I require a formula field that includes the Record ID to be unique? The logic seems faulty to me, but I assume there's a good reason for it. And is there a way around this, perhaps with custom data rules?
------------------------------
Harrison Smith
------------------------------
You cannot create a field that references the Record ID field and that requires unique values. Please change your formula to not reference the Record ID field or uncheck the unique checkbox.
My question is... why? A record ID by definition is unique, so why can't I require a formula field that includes the Record ID to be unique? The logic seems faulty to me, but I assume there's a good reason for it. And is there a way around this, perhaps with custom data rules?
------------------------------
Harrison Smith
------------------------------