Failure of _ValidIf constraint

Hi guys!  I am very stuck with this one...

This is a public app and I have created all of the constraints for this column that I can think of,  yet it is still allowing users to enter an alpha value.  The app doesn't throw the error message, allows the form to be submitted, and the field writes nothing to the database (Google Sheet)

After collecting literally tens of thousands of submissions with this form, the issue is admittedly rare, yet a significant problem.  From my testing and user feedback, the following potential trends are

  • always the letter 'e' is allowable
  • when 'e' is entered, the decimal character is NOT able to be entered
  • often the affected submissions are from non-US geographies

ANY ideas, insight, tips would be extremely helpful!

Column DetailsColumn Details

 

failurefailure

 

ValidIf ExpressionValidIf Expression

 

 

1 3 198
3 REPLIES 3
Top Labels in this Space