Search by Suppier from a Choice field
Here again 
Hi I import a large excel file with 23.652 Items.
I try to search by Suppier from a Choice field but I haven't had any luck.
Some help
On the Search Tab do that with
let search := lower(Search);
select DB where lower(text(Proveedor)) = search
And work but a like take fron Choice field.
Thanks
5 replies
-
This Formula works fine,
but not understanding something, The field Clave is empty field what is it necessary for ? There are other best way ?
Thanks
if Supplier then let my1Filter := text(Supplier); if Clave then let my1text := lower(Clave); select DB where contains(text(Proveedor), my1Filter) or (contains(lower('Descripción'), my1text) or contains(lower(Referencia), my1text)) else select DB where contains(text(Proveedor), my1Filter) end end -
Not sure what the field Clave does but looking at your screenshot you might want to try:
let search := lower(Supplier);
select DB where lower(text(Proveedor)) = searchSteven
-
RoSoft_Steven
Hi Steven give me this error
-
RoSoft_Steven
Now work
let search := lower(text(Supplier));
select DB where lower(text('Proveedor')) = searchThanks Steven, in two lines excelent
-
-
Rafael
Oops, my mistake, glad you get it to work. Thanks.
Content aside
- Status Answered
- 2 yrs agoLast active
- 5Replies
- 80Views
-
2
Following