Custom form - Validate input to include only Hebrew and a handful of special characters

Ask for Help
1

Hi all,
Using a custom form with a dedicated work table. RegEx is working great to validate anything numeric but I’m stuck when it comes to Hebrew characters and a handful of special characters (such as ’ (single quote), -(hyphen), space, etc.).
In a nutshell, I’d like to add a column that’ll validate input of a text field. Column should return “false” if contains anything other than Hebrew and these special characters.

I found this great idea on StackOverflow which is actually using JavaScript to validate the RegEx.

function is_heb(Field) {
        // First choose the required validation

        HebrewChars = new RegExp("^[\u0590-\u05FF]+$");
        AlphaNumericChars = new RegExp("^[a-zA-Z0-9\-]+$");
        EnglishChars = new RegExp("^[a-zA-Z\-]+$");
        LegalChars = new RegExp("^[a-zA-Z\-\u0590-\u05FF ]+$"); //Note that this one allows space 

        // Then use it

        if (!LegalChars.test(Field)) {
            return false;
        } else
            return true;
    }

Here it is, “adapted” for Glide and for my specific use case:

{

        HebrewChars = new RegExp("^[\u0590-\u05FF]+$");
        
           LegalChars = new RegExp("^[a-zA-Z\-\u0590-\u05FF ]+$"); //Note that this one allows space 

      if (!LegalChars.test(p1)) {
            return false;
        } else
            return true;
    }

I was sure it worked, but then…it didn’t :slight_smile:
I fear I might have “touched” something to mess it up, but cannot find it. Of course I tried to build it again from scratch but still no luck.
Any ideas?
Thanks

2

Are you using Glide sheets or google sheets?

3

For this form-specific rewritable situation I’m using a Glide Sheet. Is that not recommended?

4

No it’s not that. I was just asking to see what flexibility you had within the app.

5

So I entered your formula into a new column with javascript code and used p1 as my addressing another column and it worked fine for me.

image

image
image318×676 27.8 KB

6

After looking into this further your javascript works fine outside of glide and in my example it identified a period “.” as non hebrew which made me think it was 100% working. I attempted to use it even further and any information placed in the field in any other language with out a period “.” is recognized as true as well.

I do not think that the javascript portion of Glide has matured enough to work in this manner. I will keep working on it but your code in either format listed above works the way it should outside of Glide.

1 Like
7

Thanks for assisting.
I actually think the code part inside Java is working rather well.
Here’s another code I picked up. this time to check integrity of an Israeli ID number. I have not played with it extensively, but on the surface it does seem to function properly. Happy to hear your input.

{
	p1 = String(p1).trim();
	if (p1.length > 9 || isNaN(p1)) return false;
	p1 = p1.length < 9 ? ("00000000" + p1).slice(-9) : p1;
		return Array.from(p1, Number).reduce((counter, digit, i) => {
			const step = digit * ((i % 2) + 1);
			return counter + (step > 9 ? step - 9 : step);
		}) % 10 === 0;
}
9

Ok, this works. Using English characters and manually removing the space using javascript will give you the correct “true” value.

{

        HebrewChars = new RegExp("^[\u0590-\u05FF]+$");
        
           EnglishChars = new RegExp("^[a-zA-Z\-]+$");

var text1 = p1;
var text2 = text1.split(" ").join("");

      if (!EnglishChars.test(text2)) {
            return true;
        } else
            return false;
    }
10

This looks great but please help be “decode” this code. Does it just check if p1 doesn’t have English characters?
The idea to have a “clean” input, i.e. just Hebrew characters and select special characters.

12

image
image423×747 35.8 KB

Sorry, but this doesn’t work :frowning:
Once you enter a digit, it either return false, returns true when shouldn’t or return nothing at all.
image
image
image
image
image
image

Any other ideas?
Thanks again for assisting(

13

Hola @Test_Test

Does it work for you?

image
image661×593 33.7 KB

This is the JS code I’m using but don’t know if something is still missing :innocent:

const HebrewChars = /^[\u0590-\u05FF]+$/;

if (!HebrewChars.test(p1)) 
    return false
else
    return true

Let me know if this helps you.

Feliz día!

3 Likes
14

Hola @gvalero,
Gracias!
This is indeed working for Hebrew, but it doesn’t allow the special characters I mentioned (apart from “space” which is working):
– מקף
’ גרש

15

Hola @Test_Test

I thought in another way (inverse logic :upside_down_face:) and I think it works now: only Hebrew characters and special characters and not numbers!

image
image729×498 36.7 KB

Happy Christmas/Feliz Navidad!

3 Likes