Search inside a reference nested table

[Tias_Muesli]

Hi,

Is there a way for the search field to also find values that appear in the nested tables on the opening page? I have made all the fields searchable but still nothing. In the screen shot below, I’d like to be able to type “Shantal” and get the “Apple Tree Alberton” record to come up, however, when I do, I just get a blank. Is there anything else I should be doing? Or is there a workaround?

Regards
Hani

[Aurelien · Accepted solution]

Hi @Tias_Muesli

I don’t know if this is possible, I think it’s not.

However, here is my suggestion ( I didn’t try it):

• add a virtual column, type Text, expression:
  CONCATENATE([Related Contacts][Name])
• set show_if condition on this column:
  CONTEXT("View")="Opening Page"
• tick the Search property ON.

[Tias_Muesli]

Aurelien:

CONCATENATE([Related Contacts][Name]

Wow! Thank you so much! It worked!