I have a portal on a popover that is related to 1 record that I need to be able to asses all the portal entries (not just the first one) to see if the expiration date is approaching so I can alert if on the main screen. I know how to evaluate the first record but not all of them. Any ideas on a simple what to do this?
Thanks for your help!
Use the MIN function, that will get the minimum date in the portal.
Otherwise put an "overdue" calculation in the remote table and use the count or sum function: if Count(table::overdue) > 0