Related Tables & Format Rules

[Domearian]

Is there a way to check a related table to see if a particular value exists? I thought :

IN("Issue", [Related Mobile Inspections Datas])

But this doesn't seem to work. I want to set the icon and colour (which I can do without issue) but only if it detects the word "Issue" in the column [Issue] within the [related mobile inspections Datas] from the data [DOB Data].

[Suvrutt_Gurjar · Accepted solution]

Assuming the column[Issue] is in the child table , please try

IN("Issue", [Related Mobile Inspections Datas][Issue])

However please note that complex format rules can impact the browsing experience of the app user.

Format Rules: The Essentials - AppSheet Help

[Domearian]

Thank you. That worked a treat.