Highlighting a Portal row

[Hijack]

Anyone have a good solution for displaying a portal row in highlight to reflect the current record? Say for example, I have a portal displaying a set of records from the CURRENT table. Not really a self-join but a portal that shows matching records from the current able based on a global. Say, a global set to "New York" and joined to a State field in the current table of contact info. The portal would then show all records with people in New York state.

If set a button in the portal to show the related record, I can hop to that record and quickly isolate the current found set to match the portal contents. Then, if I flip through the found set, I'd like to be able to have the portal highlight the row that matches the current record I'm looking at.

It's harder (if not impossible) that it seems at first blush.

Thanks all.

[Ender]

See if this thread helps:

http://www.fmforums.com/forum/showtopic.php?tid/1997

The idea is the same for FM7 as FM5/6.

I've also seen a demo file with this, though I can't remember where...

[Lee Smith]

This questions comes up from time to time. In fact, I think it was just a couple of days ago that it was last asked.

I just did a search of "[color:"blue"]ALL FORUMS" using [color:"Red"] +highlight +portal +row as "[color:"blue"]Keywords" (be sure to use the + with the keywords) and used 1 Month in the search criteria, and came up with several hits, including the one I mentioned.

HTH

Lee

[Hijack]

Well fooey. Sorry for reposting a common thread. I should have done a search first. I did search Google.com for those keywords before posting. Most of the time Google shows great accuracy with content from FMForums but nothing came up this time so I assumed I'd have similar bad luck with a direct search.

Thanks for the tip. I'll read the previous posting and get the skinny.

[Lee Smith]

Hi hijack,

Was not intending to pound the answer home. I had answered your post, just as my ISP had decided to play "there - not there" with me, and by the time it posted, Ender had posted too.

I often use Google to help find solutions, it is a great search engine.

However, if you use the methods explained in the Keyword search terms >> [color:"blue"] (Advanced search tips) they can be very helpful. In addition to using the [color:"red"]+ with Keywords I have found that using different forms of the keywords can improve the number of correct hits. In other words, [color:"blue"] pars works better than [color:"blue"] parse, or parsing , so you need to consider how others could have posted there questions or responses. This could also mean alternative words such as [color:"blue"] extract instead of [color:"blue"] parse , etc..

HTH

Lee

[Hijack]

My particular need is a little different than the other thread Ender pointed out. That thread talked about manually selecting portal rows and having them highlight in different colors is different than what I'm trying to do.

I'd like to have the highlight appear automatically in the portal if I happen to be sitting on a record in the database that is also in the portal. I've been trying to think of a calculation that can show something like

If ( Get(ActiveRecordID) = Get(CurrentRecordID) ; "Yes" ; "No")

But, unfortunately there doesn't seem to be an "ActiveRecordID" Get that I can do. Essentially I want to see if the current record ID matches the one being viewed. If it does, I can easily make a container that changes color and use that in a portal.

That make sense?

[comment]

You can do this by limiting record navigation to buttons with scripts. At the end of the script/s, set gRecordID to RecordID.

[Hijack]

Yep. I thought about this approach. But, my database users can be wiley at times and I don't put it past them to circumvent my faux nav bar which I've replicated on the left and change records in a way that won't update that global.

Anyone heard if FileMaker is planning on adding a feature in the future that will allow you to bind a script to FileMaker events like "Change Record" or "Enter Find Mode"? That sort of higher level event binding would open up a huge range of functionality that developers could leverage.