The answer depends on the design of your database. Does a single field in a single record list all the out of date certificates? It doesn't sound like it. You may be better off using your layout to list the out of date and soon to expire certificates in a list view.
How do you want this information presented to you?Do you want a script that runs every time you open a certain layout, or opening the database generates a report? Do you want some conditional formatting that changes the color of a field when someone goes into a layout or record?
Easiest, I think, would be a button on the layout 'Status'. Click button, custom dialog comes up, 'Which Report would you like to see?' Button choices 'Expired', 'Expire in (you pick) days', 'Cancel'. Then using Get (LastMessageChoice) with some If, Else if steps to get your found set of records.
Post your script and someone will help you make the modifications
Actually, it's setup with a portal. Every time a new record is created in the portal, a script that runs through the certificates related to this record and checks which ones are valid and which aren't.
This is why I would prefer it to be shown in a dialog box rather than on the layout.
But I gather that this is somewhat tricky/impossible?
So when the new record is created in the portal, would you like a new window (like a smaller modal picker window) to pop up, showing all the related certificates, in a list view with maybe the fields...'CertificateName' and 'ExpiresOn' Field?. Then you could dismiss the window, or click a certificate to go to that certificate? Something along these lines?
Nothing is impossible! (Until Phil says it is :P)
Check out the Invoice Starter Solution, Manage Scripts, the Show Customer Browser script. It might be what you're looking for.
This did the trick.
Thank you very much, sir!