Announcements
hello,
I have a problem separating my functions inside my items property of my datatable.
I have tried with ";" too ";;" and ","
Thanks for your help
Hi @kishama
The solution here is to nest the call to Search inside AddColumns. The formula you add to the Items property of your datatable would look like this:
AddColumns( Search(tbticket;txtbuscar.Text;"idticket"); "cliente";LookUp(tbcliente;idcliente=tbticket[@idclient]).cliente; "Usuario";LookUp(tbusuario;idusuario=tbticket[@idusuario]).abreviatura; ....... )
Hi @timl ,
Now I get the error:
Incompatible types for comparison. These types cannot be compared: Text, Table
AddColumns(Search(tbticket;txtbuscar.Text;"idticket"); "Cliente";LookUp(tbcliente;idcliente=tbticket[@idcliente]).cliente; "Usuario";LookUp(tbusuario;idusuario=tbticket[@idusuario]).abreviatura; "Producto";LookUp(tbproducto;idproducto=tbticket[@idproducto]).producto; "Servicio";LookUp(tbservicio;idservicio=tbticket[@idservicio]).servicio; "Dep Origen";LookUp(tbdepartamento;iddepartamento=tbticket[@deporigen]).departamento; "Prov Origen";LookUp(tbprovincia;idprovincia=tbticket[@provorigen]).provincia; "Dist Origen";LookUp(tbdistrito;iddistrito=tbticket[@distorigen]).distrito; "Dep Destino";LookUp(tbdepartamento;iddepartamento=tbticket[@depdestino]).departamento; "Prov Destino";LookUp(tbprovincia;idprovincia=tbticket[@provdestino]).provincia; "Dist Destino";LookUp(tbdistrito;iddistrito=tbticket[@distdestino]).distrito; "Moneda";LookUp(tbmoneda;idmoneda=tbticket[@idmoneda]).moneda )
Thank you very much for answering.
I think I see where the error is. Can you try the following to see if that works better?
AddColumns(Search(tbticket;txtbuscar.Text;"idticket") As tbBuscar; "Cliente";LookUp(tbcliente;idcliente=tbBuscar[@idcliente]).cliente; "Usuario";LookUp(tbusuario;idusuario=tbBuscar[@idusuario]).abreviatura; "Producto";LookUp(tbproducto;idproducto=tbBuscar[@idproducto]).producto; "Servicio";LookUp(tbservicio;idservicio=tbBuscar[@idservicio]).servicio; "Dep Origen";LookUp(tbdepartamento;iddepartamento=tbBuscar[@deporigen]).departamento; "Prov Origen";LookUp(tbprovincia;idprovincia=tbBuscar[@provorigen]).provincia; "Dist Origen";LookUp(tbdistrito;iddistrito=tbBuscar[@distorigen]).distrito; "Dep Destino";LookUp(tbdepartamento;iddepartamento=tbBuscar[@depdestino]).departamento; "Prov Destino";LookUp(tbprovincia;idprovincia=tbBuscar[@provdestino]).provincia; "Dist Destino";LookUp(tbdistrito;iddistrito=tbBuscar[@distdestino]).distrito; "Moneda";LookUp(tbmoneda;idmoneda=tbBuscar[@idmoneda]).moneda )
Thank you very much @timl , it works fine now. One last query. How can I make my search case insensitive?
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 382 Super User 2026 Season 2
Mohsin Ali 329
WarrenBelz 187 Most Valuable Professional
