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
    • 1 yr 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
    • 1 yr 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
      • 1 yr ago
      • Reported - view

      RoSoft_Steven 

      Hi Steven give me this error

      • Rafael Sanchis
      • Rafael_Sanchis
      • 1 yr 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
    • 1 yr ago
    • Reported - view

    Rafael

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

Content aside

  • Status Answered
  • 1 yr agoLast active
  • 5Replies
  • 78Views
  • 2 Following