0

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

null
    • Rafael Sanchis
    • Rafael_Sanchis
    • 3 yrs ago
    • Reported - view

    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
    • Ninox partner
    • RoSoft_Steven.1
    • 3 yrs ago
    • Reported - view

    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)) = search

    Steven

      • Rafael Sanchis
      • Rafael_Sanchis
      • 3 yrs ago
      • Reported - view

      RoSoft_Steven 

      Hi Steven give me this error

      • Rafael Sanchis
      • Rafael_Sanchis
      • 3 yrs ago
      • Reported - view

       RoSoft_Steven 

      Now work 

      let search := lower(text(Supplier));
      select DB where lower(text('Proveedor')) = search

      Thanks Steven, in two lines excelent

    • Ninox partner
    • RoSoft_Steven.1
    • 3 yrs ago
    • Reported - view

    Rafael

    Oops, my mistake, glad you get it to work. Thanks.

Login to reply

Content aside

  • Status Answered
  • 3 yrs agoLast active
  • 5Replies
  • 92Views
  • 2 Following