Solved

Single Line Text format - ReqEx maybe?

  • 13 February 2020
  • 3 replies
  • 2 views

Badge +4

This is a total long shot, but here goes.

My (old) responsive form has a single line text box where the name of 'the person making the complaint' needs to be entered.  These are not people internal to our company, so I can't use a 'people field' here.  The group wants to enforce a "Last name, First name" format, but does not want to have a seperate field for inputting a Last Name and a First Name (go figure!).  I've pretty much told them I cannot enforce that type of formatting (to get myself off the hook), but figured I would throw it out here and see if anyone has suggestions.

Note: I can not use any custom coding, so I'm hoping for solutions either using RegEx or rules, etc.  

 

(Don't you hate it when someone wants something but they are not willing to work with you to get it??)

icon

Best answer by v-tmasenko 13 February 2020, 17:58

View original

3 replies

Userlevel 3
Badge +9
How about a Submit rule?
Here's a rule definition to to start with:
if FullName does not contain ,
then FullName Show validation error LastName, FirstName
Badge +4
Hmmm, that may work... I'll play around with it. Thanks!
Badge +4

The business unit signed off on it... which amazes me in and of itself! Thanks v-tmasenko!


I built an 'invalidate' rule ...


!contains({Self}, ",")

Reply