Search 2 dbjoin fields with 1 autocomplete filter?

rackem

Well-Known Member
I have a form for recording match results between two players. The player names are entered via autocomplete dbjoin elements. Both dbjoins link to the same player table.

My question is about filtering on the player names in the list view. I would like to be able to autocomplete select a player name in one filter field that searches both dbjoin fields. In other words, I want to enter a player name in a filter field and find all matches that contain that player. Is there a way to do this?

I have gotten close by using a calc element to concat the player names and using that as my filter field. But the autocomplete works on the full string instead of a single player.
 
*friendly bump* Has anyone ever tried this or know if it is even possible with Fabrik?
 
We are in need of some funding.
More details.

Thank you.

Members online

Back
Top