I'm trying to use the "hide feature" to hide info that's based on a portal. I want it to recognize the top row (as I have sorted it) and "hide" based on one of those fields. I hope this makes sense? How do I accomplish this?
A more detailed example will help.
If you sort the portal, instead of sorting the relationship, the sort order won't change what related record is "first" when you reference that data from the layout, from outside of the portal. So you might sort the relationship instead of the portal. Then this expression:
will refer to the first record in the portal if used in a conditional format or Hide Object When expression.
Without that, you'd need to use ExecuteSQL to access the data in the related table so that you could use the "order by" clause to get the same order as your portal. While that can work, it may result in a layout that is slow to update.
Retrieving data ...