Required field validation is not working in Site

is it showing * sign on field (it should be according to code snippet) ?
however your second logic for validation allows two or more spaces which looks like value is null but still our save into works and it does not shows validation on field
could you please provide more info like  what data is coming into that field etc

is it showing * sign on field (it should be according to code snippet) ?
however your second logic for validation allows two or more spaces which looks like value is null but still our save into works and it does not shows validation on field
could you please provide more info like  what data is coming into that field etc

Yes, that is also a problem, without values filled, SAVE INTO is working and empty fields are getting stored in DB.. It should not..
For your question,.. we are saving the first name in that field

In your first validation "if" you wrote it as a accept null . Just correct it .

you can replace your like() condition with this

if(
          rept(" ",len(local!name) ) = local!name,
          "Please enter a valid name",
          null
        )

Thank you Amaan Shekh  and