highlighting related records in portal

[ncheneweth]

I have seen some solutions wherein you can highlight a record in a portal view and in another portal view right next to it all the related records highlight. So, rather a portal selection filtering to show only related records, it continues to show all records but highlights the related ones.

How is this done?

[Genx]

This link http://fmforums.com/forum/showtopic.php?tid/180278/post/221354/hl// demonstrates portal row selection in general.

[gbrown]

I saw a really cool free demo of how to do this at Nightwing Enterprises http://www.nightwing.com.au/FileMaker/demos7/demo707.html It is not password protected so you can tear it apart and see how it's done.

You might check out the other demo's here too as some of them are pretty slick!

Greg

[ncheneweth]

Thanks for the info. Although I didn't find anything on these links that was like what I was trying to describe.

The particular solution I want to implement would let me have two portals, displayed side-by-side. THe first would list usernames, the second would list all the possible permissions. I want to let the user click on a user name, and the the permissions which that use has will highlight. All possible permissions will still be shown, just the related ones highlighted or otherwise indicated.

I am not describing this too well, but saw this in a tutorial on FileMaker Magazine. The tutorial was not about this topic, but the example on the video had this interfact. Very cool, but i can't see how it was done?

[Genx]

Put together a sample file of what you want... e.g. a screen shot of what you want portal 2 to look like when you select record x in portal 1, and what you want portal 2 to look like when you select record y in portal 1.

Just use squares for now if you have to.

[dazlunn]

Do you actually mean 'displaying related records' in the adjacent portal? or highlighting? Two quite different meanings inferred...

Let's say the left portal is 'library books' and the right portal is 'readers', when you click on a portal book (on the left) then the right portal would show who's read it?

Am I close?

[ncheneweth]

Its more like, on the left it shows all the library books, and on the right all library cardholders. Then when you click on a book, those cardholders who have read it will highlight. So the total items displayed in each portal remains the same when you click on a book, just the cardholders whose names are highlighted change.

[Genx]

But wouldn't that be kind of redundant?

It's fairly easy to set up, but wouldn't there be issues with ease of reading the possible even 30 records in the right portal ... what kind of numbers are we talking here.

[ncheneweth]

Only a few records. The actual solution I would like to apply it to is a security interface. The portal on the left list the users, the portal on the right lists permissions. The permissions portal shows all possible permissions. Then when you select a particular user, the permissions which have been assigned to them highligh in the permissions portal. Or actually not "highlight", better would be a field could change and show a graphic, like a check box or something to indicate that the user has that permission.

[ncheneweth]

heh, i realize this is not necessarily the best way to implement this, but I am curious how it could be done.

[mscholtz]

I know this is an old topic, but I'd think you might want to do this with a script.

Clicking on the portal would set a global field to the id or name of the permission.

Then in your table that holds assigned permissions, have a calculated container field that will show the graphic if the permission is equal to the global.