Good night,
I have a gallery that filters when I type in a text box (this works for me), but now I want that gallery to also filter when I select a user in a drop-down list.
Solved! Go to Solution.
@CarlosN ,
I cannot help you unless you give me the information I have twice requested (please do not send screen shots - just the answers)
Hi @CarlosN ,
What is your current filter code, the name and Items of your drop-down and the name of the field it has to match in your data?
@CarlosN ,
Firstly, I would do the below, but you did not answer the two other questions - the name of the field you want to match and the Items and name of the drop-down you want to match to. You also want to see all records before anything is typed in?
Can you also please post as Text (not a screenshot) - any mistakes in the below are caused by needing to OCR the picture.
Filter(
’Solicitudes ExprèsText;
(
SearchBoxl_2.Text in Cliente ||
TextSearchBoxl_2.Text in Referencia ||
TextSearchBoxl_2.Text in ID ||
TextSearchBoxl_2.Text in Producto ||
TextSearchBoxl_2.Text in EstatusMuestra
) &&
(
LbLPMNueva.Text in EstatusMuestra ||
LbLPNReaLizada.Text in EstatusMuestra ||
LbLPNTramite.Text in EstatusMuestra ||
LbLPMDevueLta.Text in EstatusMuestra
) &&
UsuarioMuestra=VarUsuario.FullName
)
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
Hi Warrent,
I used this code with the instructions given.
also put additional one search by drop down list per user.
Filter('Solicitudes Expres';
(
TextSearchBox1_3.Text in Cliente ||
TextSearchBox1_3.Text in Referencia ||
TextSearchBox1_3.Text in ID ||
TextSearchBox1_3.Text in Producto ||
TextSearchBox1_3.Text in EstatusMuestra
) &&
(
LblPMNueva_1.Text in EstatusMuestra ||
LblPMRealizada_1.Text in EstatusMuestra ||
LblPMTramite_1.Text in EstatusMuestra ||
LblPMDevuelta_1.Text in EstatusMuestra
) && DdPrueba.SelectedText.TipoUsuario in UsuarioMuestra)
@CarlosN ,
I cannot help you unless you give me the information I have twice requested (please do not send screen shots - just the answers)
Hi Warren,
very grateful for your help, capturing them is to show you that I achieved what I needed.
User | Count |
---|---|
163 | |
86 | |
71 | |
64 | |
62 |
User | Count |
---|---|
210 | |
149 | |
97 | |
84 | |
66 |