Discussions

Expand all | Collapse all

Issue with unintended spaces in text fields

  • 1.  Issue with unintended spaces in text fields

    Posted 14 days ago
    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
    ------------------------------


  • 2.  RE: Issue with unintended spaces in text fields

    Posted 14 days ago
    Edited by Mark Shnier (YQC) 13 days ago
    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.com
    mark.shnier@gmail.com
    ------------------------------



  • 3.  RE: Issue with unintended spaces in text fields

    Posted 13 days ago
    Hi Mark,
    Happy New Year to you and your family.
    Thanks,
    Tim

    ------------------------------
    Tim Egerton
    ------------------------------