Text Field White Space
Hi, We have a EOTI app with a Text Field [First Name], not the only one, which EOTI users are entering data and a white space (usually by using space or tab). We have tried to fix this with a fo...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendIs the Trim Formula field on the firm, even if in a hidden section? I find fi4m rules don't always work correctly if formula fields they use are not on the form.
Allso is the form rule checkbox unchecked so that it will fire "all the time"?
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
Allso is the form rule checkbox unchecked so that it will fire "all the time"?
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
- 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
------------------------------- 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
------------------------------- 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
------------------------------
