I suggests to read the help and understand what Length() does before you say it doesn't work.
Try Length ( Filter ( Drivers::Number Mobile ; "0123456789" ) ) if you want to count only the number of digits without counting the spaces and other characters.
Sir I have value on that field.
[@Phones = Drivers::Number Mobile;
@Numbers = Filter(@Phones; "1234567890")];
"(" & Left(@Numbers;4) & ")" & " " &
Middle(@Numbers;5;2) & " " &
Middle(@Numbers;7;2) & " " &
Now I want when user type
I suggest you rephrase what you exactly are trying to achieve. My answers are doing exactly what they are supposed to do, but somehow you are expected something different and I can't figure out from your replies what that is.
You mention you have a value in the field, but what you mention is a calculation. Is this is calculated value? Where is it applied?
By the way, the calc you are using always returns 11 digits as long as the user typed 8 or more. You go from using Left(), through Middle() to Right(). Think about what will happen in this calc.
this is my value on that field and as I said I want to have script triggers
on that field too.
That can't be the value, it's a calc. An no, you didn't say you want to use script triggers.
Unless you clearly explain what you are trying to achieve instead of how, I can't help you further.
1 of 1 people found this helpful
Length() evaluates spaces too. Actually every char is counted. So what you are looking for is Length(Filter(number mobile; "0123456789")) = 11 as validation formula for your number. Instead of triggering a script just do it via validation of the field and a dialog will pop up when the validation doesn't validate.