Can't find an item in a drow-down list

[Paragon]

Describe the problem

In a form view linked to a table, some items are nowhere to be found

Describe, step by step, how to reproduce the error or problem you are encountering.

• I created a table (1).
• In this table (1) I created a “linked” column to another table (2) so I’m able to click on the little “+” toggle and I can add any item from table (2) to this one (1).
• I created a form view for table (1)
• In the form view I’m putting the “linked” column as a drop-down list

Issue : When I try to look for items in the drop-down list (which calls data from the “linked” column), some items do not seem to exist !

Provide screenshots or include share links showing:

Showing the table (1) with the “linked” column : 1-Contact-lié

Trying to look for someone in the “1-Contact-lié” column by pressing on the “+” button. Here we’ll try for “Louis Brémaud”

Finally we try to look for “Louis Brémaud” in the form view in a drop-down list that’s linked to the 1-Contact-lié column but I can’t find him !!

I have other cases of this bug but I can’t figure out the link in between them

[petrs]

Hi @Paragon,

this happens because you are trying to search on a different column than the primary field of table 2. The search won’t work because of security reasons. We don’t want to expose data from your whole linked table to the users of public forms.

Currently the only workaround would be to make the name you want to search for the primary field.

[Paragon]

Thanks for the explaination.

So if I get what you’re saying, I can’t have a form view of table 2 that will search in table 1 field right ?
The only workaround you’re mentioning is creating a form view in table 1, is that right ?

[petrs]

Yes.

For linked rows you will get search - but only on those values from the primary field. Other fields won’t be exposed by the search.

Think of the search in forms just as a search of the values of the individual field that is being filled.