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].
Solved! Go to 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
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
Thank you. That worked a treat.
User | Count |
---|---|
43 | |
26 | |
24 | |
14 | |
12 |