0

Search view Formula don't work

I Have these Formula for search Ganado Plan but don't work any idea.

let Busqueda := Busqueda;
select Documentos where 'Ganado PLAN' = " " = Busqueda

4 replies

null
    • John_Halls
    • 2 yrs ago
    • Reported - view

    Try

    let xBusqueda := Busqueda;
    select Documentos where 'Ganado PLAN' = xBusqueda
    

    Regards John

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

    John Halls Suffering with formulas馃憤 Thanks

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

    John Halls

    Hi works on Documento and Plano no for Actividad, but when select Documentos and Plano display actividad 馃様something wrong ?

    let yBusqueda := 'Busqueda Tipo Documentos';
    select Documentos where 'Tipo de Documento' = yBusqueda

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

    Try:

    let yBusqueda := text('Busqueda Tipo Documentos');
    select Documentos where text('Tipo de Documento') = yBusqueda

    I'm guessing the order of your choice field is not the same as your searchform or maybe there's a gap in the number sequence. Using the text values should solve this.

    Steven

Content aside

  • Status Answered
  • 2 yrs agoLast active
  • 4Replies
  • 87Views
  • 3 Following