Validation rules to eliminate blank spaces is short text field

[Bruno1]

Hello!

I have this issue with a required, short-text field. I would like my users to insert data without blank spaces, however they tend not to go with this…

I need the input to be ABC123, however there are ABC 123, or ABC1 23 and even ABC123 (multiple blank spaces in the end).

I have tried a validation rule to reject and notify users of this issue. I used FIELD CONTAINS [empty space] however this is blocking ALL input in the field, even the ones that have no blank spaces.

Any suggestions?

Thanks a lot,

Bruno

[CSWinnall]

Hi Bruno

Please see this:

Forbid whitespace character in account table

Ahoy! @Francois I also tried field validation rules with regex and didn’t have much luck! Below is the JavaScript method. When a white space is added to field_xx, it will automatically erase it on keyup. Hope that helps. $(document).on('knack-view-render.any', function(event, scene) { // Prevent whitespace input in a text field with key 'field_xx $('#field_xx').on('input', function() { this.value = this.value.replace(/\s/g, ''); }); });

Craig

[Bruno1]

This is perfect Craig, works perfectly, thanks a lot!

Bruno