Hi All,

I have a DB that shows what a bidder has won at an auction. I show it in a portal on the Bidder Page (below). If it is a certificate, I have it checked as "Yes" on the catalog item on the catalog page. I am trying to figure out how I have a "Custom Dialog" box pop up if the field is Yes in the portal. I know how to do it on a page, but not when it shows in the portal.

 

Any help would be greatly appreciated.

 

MG

 

 

Hi,

 

if I get you right, you should be able to do it like this. 

I assume that you use some trigger to show the customer dialog (button or script trigger on load).

 

All you need to do is in your script

If [ PatternCount ( List ( RelationToPortalRecords::CERT ) ;  "YES" ) > 0 ]

Show your dialog..

End if

 

List creates a ¶-separated list of all entries in a related table's field.  So all you need to check if there's at least one "YES" in the list.

 

Best,

Alexander

PatternCount ( List ( RelationToPortalRecords::CERT ) ;  "YES" ) > 0 

 

=

 

not isempty( filtervalues( List ( RelationToPortalRecords::CERT ) ;  "YES" ) )

 

This might be a bit quicker because FMP does not have to count all the values returned.