What @Darren_Murphy suggested, was just to set the template to point to your first column. Then add a replacement for each letter of the alphabet. The problem here is that Glide requires an existing column as a replacement value. I think the only way to make this work purely in Glide, at the moment, would be to create a template column for each letter of the alphabet. Then create a final template column that points to the Name column, then have a replacement set up for each letter of the alphabet.
So it would be 26 template columns for each capital letter, and 1 template column to build the the final NAME column.
Not a good solution. Two things we need from Glide:
- The ability to use Custom Values as replacements in a Template column (This would have allowed for a one column solution to your problem, but still ugly with 26 replacement values)
- Good string manipulation functions, such as Substring, Trim, Pad, Upper, Lower, Proper, etc.
Add you vote to this request.