I think there are two steps. The first step is to clean up your existing data. Depending on the amount of data you could use grid edit and filter of report where the trim(Text field]) is not equal to the [text field] and hen copy paste the whole column to fix.
, Assuming that your data entry is being done from forms only and not grid edit, you could have this form rule. I tested it and it seems to behave OK but you might want to test this yourself.
When Multiple conditions are true
all of
[Trim Text field formula] is not equal to the value in the field [Text field]
[Text Field is not (blank)
Action
Change [Text Field] to the value in the field [Trim Text field formula]
and remember to uncheck the checkbox so the rule fires all the time.
The Form rule will certainly work perfectly as long as the user tabs out of the field before saving. So in your testing the torture test to try to break the rule is to save the record before the user has tabbed out of the [Text Field].
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.commark.shnier@gmail.com------------------------------
Original Message:
Sent: 01-13-2021 23:12
From: Tim Egerton
Subject: Issue with unintended spaces in text fields
Hi,
We are having an issue when users are entering data in text field and then hit the space key leaving a space at the end of the text.
When we do an exact search for example a report when the filter is [Text Field] is equal to ask the user it is not returning result as the user is not entering the space as they don't know it is in the text field.
We have tried Trim([Text Field]) but you can't search on a formula field
Any ideas how we can fix this?
Thanks
Tim
------------------------------
Tim Egerton
------------------------------