Is anyone able to walk me through how to create a dictionary for the following scenario:
Virtual Field of Subtype is a copy field from Appeal, adding a dictionary that will map the first four digits of the appeal to a replacement value of the subtype.
For example: INET-WALK-YY appeal should translate to INET-00-CASH subtype; INET-GALA-YY appeal to the same INET-00-CASH subtype. We have so many appeals that have different strings in the second four digits, I just want the software to pull the first four to map to the corresponding subtype. All INET appeals would have the same subtype; all DRPS appeals would have a DRPS subtype and so on.
Is this possible?