Rtrim - Front end - Is it possible, or group similar with no access to the data model.
We essentially have a data model that pulls through a lot of text fields, one of those text fields is "Who completed something", this is typed in by the end user, meaning we have lots of Graphs that are Count of Records by Who completed it, that show the same person multiple times.
I know that an easy fix for this would be to use the group similar and/or the rtrim function on those text fields, it would mean "John Smith" and "John Smith " would show as 1 person.
Unfortunatley due to various reasons, those that actually understand how to do some of this, are not allowed anywhere near the data model, and for good reason I assume, because im not saying im great at this, just frustrated some things could be easier haha!
Is there a way I can do Group Similar, or trim the end of text fields of extra whitespace, from the front end editor, or am I stuck begging our product team to do the most basic of things and switch on Group similar?
