Highlight Record Row in list view
"Yes, you can find out what row is the current record selected. Oh... yeah, you do have to squint a bit and notice the small little black indicator at the left of the record selection."
Ok, so let's put this question to rest. Since FileMaker 8, you've had the ability to indicate the current record row in list view. With FileMaker 9 the feature becomes even more appealing. It's possible you just didn't know how to make it happen. Turns out, it's easier than you might have thought.
You do need to use a script triggering plug-in, but these can be integrated quite easily.
Watch this video to learn how to indicate which record row is selected in list view.
BIG UPDATE! Thanks to viewer Michael, he pointed me to a file on the DatabasePros.com web site. It still uses a webviewer but accomplishes this solution without the need for the script triggering. It's a total hack, but it works - for now. The file is included in the download, but not covered in the video.
Comments
download not allowed
download not allowed.... until i subscribed!!??
Something I need to fix
It seems the site is not allowing downloads on free files. I'll need to get into the code and try to fix this.
-- Matt Petrowsky - ISO FileMaker Magazine Editor
Still can't download
Is this going to be fixed? Thanks!!
Alternative Method
These are both really cool techniques. There is only one problem, namely that they rely on having a web viewer and plugin. For those developers who either can't or don't want to use the plugin, here is an even simpler alternative.
In your portal table create a global field called Record ID Global. When a row is clicked in the portal, the related portal record ID should be set
into this field. In the data file, create a text field and call it Highlight. Then set the conditional formatting for the Highlight field with - Formula is "Highlight=Record ID Global" - and of course set the desired formatting for both the text and background colors etc.
When the Highlight field is copied to the portal and the data fields, which must be set to be transparent, are put on top, the result is that the selected row now has the desired color. Incredibly simple and powerful. The only downside is that once the conditional formatting has been set it can't be changed, or rather, even if you change it the changes will not be reflected in the portal unless you replace the Highlight field. However, that is a small price to pay for such power and convenience. Hope this technique proves to be helpful to some of you.
Best regards,
Ralf
Best regards,
Ralf
Filemaker 10
Have you considered this tip now with Filemaker 10? ZippScript as you know isn't available any longer but I was wondering if there was a way you could think of to use Script Triggers.
Newer method is here.
There's a newer article here. Highlight List View Rows.
-- Matt Petrowsky - ISO FileMaker Magazine Editor