Go to related record from Portal

[Jarvis]

I am building a task management solution.

The main screen contains a series of (one row) portals which display the most recent activity a worker has been engaged in.

If the worker is currently engaged in that activity the portal is highlighted from behind with a yellow container field.

This is pretty handy. At a glance you can see what everybody is up to and who's on board right now.

I would like to be able to click onto a portal row and go to the related record for that row. I would like to be able to view that record from a different layout where I could include more information.

My portals are presented as separate rows because of the yellow container field. When I have a five row portal all rows are yellow if the first row is yellow. When I display one row at a time the container fields change color one row at a time.

Any ideas on how to get to the related record with a single click on the portal row?

Thanks,

Jarvis

[Vaughan]

Make a script "Go to related record" with the Go to Related Record script step and specify the related layout to go to.

Put a button in the portal row that runs this script.

[comment]

When I have a five row portal all rows are yellow if the first row is yellow

Why don't you solve this problem first?

[Genx]

I'm pretty sure your using the container field from the wrong table occurance, it should be the same one as the table occurance your portal is using.

~Genx

[Jarvis]

Vaughan,

I built a sample database to try your idea and it worked like you said it would. Thanks a lot.

I'm not able to use this GTRR in my current portal because everything else is so convoluted.

Jarvis

[Jarvis]

Comment,

I was able to get each portal row to display yellow independently

based upon current status of employee. I did this by making 5 independent one row portals with 5 independent container fields

behind each portal.

This seems to work nicely within the database but crashes somewhere in the server link. I can get the yellow to refresh one client station at a time but if you turn yellow on one client station, it does not show up yellow on the other client station.

I am running FM8 on one client. The other client is FM8 Advanced. The server is FM7 Server. Perhaps this refresh problem might be fixed if I upgrade server 7?

Jarvis

[comment]

I'd think one field, in the child table, should be enough - but I can't be sure without knowing how your file is structured, how do you determine "if the worker is currently engaged in that activity", and why it needs "a series of (one row) portals", instead of one portal for all.