tooltips and portals

[Lougee]

A search for "contents of portal" or "portal contents" in this forum didn't find anything so I'm hoping someone out there will answer this for me.

Is it possible to use a tooltip to display the contents of a portal? I have an event registration db in which the registered participants show up in a portal. Is it possible to have a tooltip on a related layout show the contents of that portal e.g. the persons who have so far registered for an event?

Please say yes...

Abbe

[David Jondreau]

A portal doesn't really have contents. A portal shows data from related tables.

A Tooltip uses the calculation engine, and so can show data, including related data.

So the answer is yes, you can show the contents of a portal, not the graphical elements, but the data.

You've got to figure out exactly what data the portal is showing and you can represent that in the Tooltip.

[Matthew F]

The fact that the related records are being displayed in a portal is not relevant to your task.

You can easily specify the tool tip to return the value of a related record. However, this will only link to the first related record in the relationship. Unfortunately, FileMaker doesn't have a built-in function that allows us capture results from all of the related records and return them in a single aggregate.

This kind of problem has a crazy workaround:

1. Define a value list to include values from the related record. Be sure to specify 'Include only related values' starting from the layout which will have the tooltip.

2. Set the tooltip to include: functionValueListItems( fileName; valuelist)

This will include all of the related values separated by carriage returns. If you want the values separated by spaces instead of carriage returns use:

substitute( functionValueListItems( fileName; valuelist), "P", " "))

(where 'P' is the little carriage return operator that looks like a backwards P)

[David Jondreau]

You can easily specify the tool tip to return the value of a related record. However, this will only link to the first related record in the relationship. Unfortunately, FileMaker doesn't have a built-in function that allows us capture results from all of the related records and return them in a single aggregate.

8.5+ does, List(). And Custom Functions allows a home built function.

[Matthew F]

8.5+ does, List()

Another good reason to upgrade..