I’m trying to create a new formula field (Text Type) on a Custom Object.
Formula field goes 3 layers deep via lookup fields to display a record id.
Object1__r.Object2__r.Object3__r.Id
Also, I’ve selected to treat blank fields as zeroes
When trying to save the new field, I get the following error.
…………………………….
| Unable to Access Page
| The value of a parameter contains a character that is not allowed or the value exceeds the maximum allowed length. Remove the character from the parameter value or reduce the value length and resubmit. If the error still persists, report it to our Customer Support team. Provide the URL of the page you were requesting as well as any other related information.
………………………
Things I've tried/confirmed
- As Sys Admin, I have access to all listed objects, records, fields.
- Validated Syntax of Formula field - compile size was 108 characters.
- I tried saving new field with minimal or no text in Help or Description Texts boxes.
- I made sure my field name and API name were not super long and used normal characters
- I typed in values on all my fields (making sure I didn't copy/paste something in from somewhere else that got translated as weird value).
- Tried saving field with blank values defaulting as zeros and again as blanks. Same error on both.
I'm not sure what else to try. The field I'm displaying is a record Id - 18 characters, values set by Salesforce. How could it be too long or have an invalid character?
The part that is more frustrating is building this formula field worked for me in my Sandbox environment but am getting this error in Production.
Has any one else experienced anything like this? Does anyone have any suggestions of what else I could try? Any help is greatly appreciated!
