When we went live in 2011 created a custom CRM "long text" field for my Issue (field id custevent_issue_note) labeled "Notes" to hold information we needed to deliver to JIRA.
Long Text Field Type
Long Text
A text area that can hold up to 1,000,000 characters. Use Long Text custom fields where you need greater than 4,000 characters of text for a text area, and where you do not want the field to contain rich text formatting.
When you create a long text field type in the UI, the field character limit is 1,000,000.
I created Workflow to automatically create an Issue from fields in a Custom Record. I drop into this custevent_issue_note field, information from several other fields and format them using page breaks.
' NAME: '||{custrecord_360_taxrate_taxid}||CHR(13)||'TAX ID: '||{custrecord163}||CHR(13)||'EFFECTIVE DATE: '||to_char({custrecord_360_taxrate_effdt},'MM/DD/YYYY')||CHR(13)||'Res Rate: '||{custrecord_360_taxrate_rate}||CHR(13)||'Non-Res Rate: '||{custrecord_360_taxrate_nonres}||CHR(13)||'WAGE BASE: '||to_char({custrecord_360_taxrate_wagebase},'$99,999,999.99')||CHR(13)||'INTERNAL NOTES: '||{custrecord_360_taxrate_notes_int}||CHR(13)||'EXTERNAL NOTES: '||{custrecord_360_taxrate_notes_ext}||CHR(13)||CHR(13) ||'RATE DOCUMENT: '||{custrecord_360_taxrate_document}
Resulting custevent_issue_note field screen shot below does not exceed the Long Text limit.
I need to include additional fields in the custevent_issue_note field but when I try, my Formula returns the following error:
You have exceeded the length limit for this field. Please shorten your entry by 92 characters.
' NAME: '||{custrecord_360_taxrate_taxid}||CHR(13)||'TAX ID: '||{custrecord163}||CHR(13)||'EFFECTIVE DATE: '||to_char({custrecord_360_taxrate_effdt},'MM/DD/YYYY')||CHR(13)||'Res Rate: '||{custrecord_360_taxrate_rate}||CHR(13)||'Non-Res Rate: '||{custrecord_360_taxrate_nonres}||CHR(13)||'WAGE BASE: '||to_char({custrecord_360_taxrate_wagebase},'$99,999,999.99')||CHR(13)||'INTERNAL NOTES: '||{custrecord_360_taxrate_notes_int}||CHR(13)||'EXTERNAL NOTES: '||{custrecord_360_taxrate_notes_ext}||CHR(13)||CHR(13) ||'RATE DOCUMENT: '||{custrecord_360_taxrate_document}||CHR(13)||{custrecord_tax_is_rita}
I'd like to accomplish this using the UI and Workflow and have six more fields I need in the custevent_issue_note field.
Does anyone know a way to get the Formula field to accept more characters without using a "script"?