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

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

Welcome to the Ninox community