Search inside a reference nested table

AppSheet AppSheet Q&A
1

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

3X_7_7_775372d3e9a84e8e9d6647ba6a83729564e222cc.png
3X_7_7_775372d3e9a84e8e9d6647ba6a83729564e222cc.png1643×721 63.4 KB

2

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.
2 Likes
3

Aurelien:

CONCATENATE([Related Contacts][Name]

Wow! Thank you so much! It worked!

2 Likes