Forum Discussion

TimEgerton's avatar
TimEgerton
Qrew Trainee
4 years ago

Re: Text Field White Space

Hi Mark,

The Trim Formula is on the form (Admin Tab).

Checkbox is unchecked to fire all the time.

Maybe a timing thing. The Trim Formula is not activated until the record is saved and that is being missed by the dynamic form rule?

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

5 Replies

Sort By
  • JohnCrosland's avatar
    JohnCrosland
    Qrew Trainee
    4 years ago
    Good morning,
    This sounds like it might be a circular reference.

    You can just use First Name Formula field where you would have used the First Name field, and that seems like it will solve your problem.
    Thank you,
    John

    ------------------------------
    John Crosland
    ------------------------------
    • TimEgerton's avatar
      TimEgerton
      Qrew Trainee
      4 years ago
      Hi John,

      Thanks for the reply.

      Here's the thing, it is an EOTI app where users create a profile, including First Name, Last Name and Passport No., and then can log back in to edit their profile using exact match search on First Name and Last Name and Passport No.

      This is were the white space becomes an issue if it is in anyone of those fields it doesn't get an exact match if they leave out the white space for subsequent logins.

      So the idea was to trim the fields removing any white space and then replace them.

      ------------------------------
      Tim Egerton
      ------------------------------
      • JohnCrosland's avatar
        JohnCrosland
        Qrew Trainee
        4 years ago
        Good evening,
        In that case, I would recommend creating a Text key value based on a formula of those three values, and you can populate it with a Dynamic Form Rule that says that if the Key doesn't equal the Formula, then change the Key to the formula. Then you can use HTML/JS on a Home Page, in order to send them to the appropriate record. If you use this method then you will need to include the Hex Code for the special character for instance space (' ') is %20 instead of space. Otherwise, you would need to tell people the format of the key.

        The issue that I have with your current setup being EOTI is data security. Anyone, with a basic understanding would be able to record hop, and could either obtain additional information about other people, interfere with your data integrity, or both.  I would recommend investigating usage based pricing plan that can accommodate any number of users that you require. This would allow you to sign people up, and give them a user account that will be able to secure their personal information.

        Thank you,
        John

        ------------------------------
        John Crosland
        ------------------------------