Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good day, everyone!
I added two new fields for front end filters using a cross table as per the need, and I can see values for those two new fields, which are flag and compliance.
Now, in my dashboard, I'm utilizing the 'select in field' functionality on a text box, and when I click on it, it takes me to the detail page, but it's not working properly; filters aren't being applied as I move from the text box to the detail page.
When it navigates to the detail page, I use the following expression (select in field) on the text box:
=pick((match(flag, flag_1, flag_2, flag_3)),'xyz','abc','def').
Flag and compliance are the names of the filters.
It's not clear what's going on in flag, flag_1, flag_2, and flag_3. If these are field names, note that this will only work if there is a single possible value in both flag and at least one of the other fields, as referring to a field with multiple possible values in this manner will return null.