Hello,
In our Summaries, there is an internal number in this format:
AAA-B-CC-DD-EEEE-FFF-XXXX-G
I need to create a custom scripted field that returns the four X's toward the end. I know I need to use a substring to return characters 21-25 of that string. Like this:
substring(21,25)
...Which should show just the XXXX in the custom field.
However, I don't know how to call up the Summary and code that whole thing. Can anyone help me? Thank you!