Hi Paul,
Use trim function to remove leading and trailing blank spaces,For your reference
Thanks,
Vijay
Hi Paul,
please let me know if this worked or you want me to explain in more detail.
Thanks,
Vijay
Thanks for your response, Vijay. I wasn't successful with the suggestion. Here's what I did:
1) On the field, I created an expression called Trim that used the trim function you described.
2) I tried running the form but it still was letting me enter a blank space
I see on your screenshots it looks like you're setting this up through the rules. I'm not seeing expressions as an option for me on the rules screen, perhaps I'm looking in the wrong place? Please provide more details. Thank you!
Hi Paul,
step 1: create an expression that trims white spaces in a textbox (Imp: don't bound this expression to any control)
step 2: in button submit, use transfer data action to transfer the expression into a textbox
step 3: use view/form passes validation to check required fields
step 4: save your textbox values to workflow/database
in the above process, it will still allow you to enter empty spaces into a textbox, but step 2 will trims out trailing and leading empty spaces of the text you entered and transfer to a textbox.
Example 1: the user enters ' ' into textbox1 and clicks submit. now step 2 changes that into ''.that means textbox1 is empty and it fails in step 3 (require field validation)
Example 2: the user enters ' testing data ' into textbox1 and clicks submit. now step 2 changes that into 'testing data'.Now, step3 passes validation and move to step 4.
Thanks,
Vijay