1

How to get filtering to work in a reference field that is set to popup and has columns from linked tables.

Don't know if anyone else needs this but for some reason it has taken me way too long to finally figure out why I couldn't filter a reference field that had columns that showed linked data.

In my example I have a sports DB. I have the following tables:

Teams

Team Membership (M:M between Teams and Riders)

Riders

Results

In my results table, I used to have a reference field to Teams and a reference field to Riders. Then I figured out that I didn't need to spend time picking the two things separately since they are linked in the Team Membership table.

So now I have a reference field to Team Membership. By default, the columns that show up in the pop window do not have the reference field. So I add them (Team.'Team Name' and Riders.'Full Name') and all looks good.

But if you try typing in the search bar you get no results. I think it is because this window can not search the link.

Ok, so why not create a formula field that shows the data I need. I did that but when I added them to the popup window column it still could not find anything. Silly me thought that would be different.

I had to create two text fields and copy the data from the linked tables into these fields. I'm guessing the data has to physically be in the table for the search to work.

So now I have two new fields rider and teamname and new code in the trigger after update, so it copies the data from the links to the fields.

1 reply

null
    • Ninox developper
    • Jacques_TUR
    • 2 yrs ago
    • Reported - view

    I had exactly the same problem and searched the code a bit. For some reason, when you type a search keyword in a popup, Ninox calls the server and it only searches the fields in the main table of the popup that are not calculated fields or links. This is all the more surprising since for the same search in a view, Ninox takes into consideration the formulas and the links.

    Ninox support is aware of this and it is on the list of things to improve.

    For now, the only solution is to copy the information in text from the main table every time it changes. This is completely absurd and unreliable.

    Otherwise, there is the possibility to put a filter in the column. In this case it works.

Login to reply

Content aside

  • 1 Likes
  • 2 yrs agoLast active
  • 1Replies
  • 147Views
  • 2 Following