Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi;
I would like to see just 11 digit numbers in my field and i try in field expressionif(<field_name> > 10, <field_name>) and my app slow down after that. Also it does not work correctly.
Perhaps it is simple but i did not success...
Please Help me !!!
Thanks in advence
Hi Selcuk,
try the following: If(Len(YourField)>10, YourField)
Good luk!
Rainer
Do You want change number format ? or Do you want select only values more than 10?
I want to select only values more than 10
I want to select only values more than 10
Hi Selcuk,
try the following: If(Len(YourField)>10, YourField)
Good luk!
Rainer
Thank you Rainer ;
It works but that field is slower than other fields?
Do you know what is the reason of that?
Well, if you're just doing that in the application instead of in the script, it has to execute a bunch of logic every time you use that expression. If that's the problem, I'd create it as a real field in the script:
if(len(YourField)>10,YourField) as YourFieldWithMoreThanTenDigits
And then use the new field instead any time you only want to see it when it has more than ten digits.
Yes that is it...
This solving is what i need. Thank you so much...