Need Support for Concatenation Logic in VB Rules to Default Grade on Promote Page

Summary:

25C

We are implementing the Promote Redwood page and need to default the Grade based on the Initial Job Value. The Grade value includes a Wage Group, which varies by location. For example, in Level 1 W4, “W4” represents the Wage Group derived from a Location flexfield.

To meet business requirements, we need to dynamically construct the Grade value using concatenation logic such as:
"Job Name" + "W" + LocationDFFWageGroupField

However, current Redwood VB rule functionality does not support concatenation when defaulting a field. Because each location has a different Wage Group and each location has 8 or more Grades, and we have 400+ locations, manually maintaining static values is not feasible.