Skip to main content
Question

Text Field White Space

  • August 22, 2021
  • 0 replies
  • 81 views
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 formula text field Trim([First Name]) and a dynamic form rule of when First Name is not blank and is not equal to Trim Frist Name change First Name to the value in Trim First Name (fire change action unchecked).

However it is not working.

Is there another solution to this problem?

Thanks,

------------------------------
Tim Egerton
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24
Is 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
------------------------------
Mark Shnier. Your Quickbase Coach
    Terms & ConditionsAccessibility statement