Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i want to hide a field value which are having 'a' as a first letter in name.............
For example in list box field is salesman....then i want to show without salesman names which are consist a as a first letter at script level
salesperson | sales |
---|---|
aravind | 20% |
bhanu | 30% |
naveen | 15% |
purush | 15% |
chaithu | 20% |
sai | 0% |
if u create a list box with salesperson field in script level u shoud comment the name which is have starting letter a (aravind)
I haven't understood if you want the salesperson just to hide from the list box or you want to exclude them when reloading data:
List box: Create an expression (select <expression> from field list dop down):
=if( lower(left(salesperson,1)) <> 'a', salesperson)
In the script, you can use a where clause:
LOAD
salesperson,
sales,
...
FROM ...
WHERE lower(left(salesperson,1)) <> 'a';
I haven't understood if you want the salesperson just to hide from the list box or you want to exclude them when reloading data:
List box: Create an expression (select <expression> from field list dop down):
=if( lower(left(salesperson,1)) <> 'a', salesperson)
In the script, you can use a where clause:
LOAD
salesperson,
sales,
...
FROM ...
WHERE lower(left(salesperson,1)) <> 'a';