Lougee Posted December 1, 2007 Posted December 1, 2007 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 Posted December 1, 2007 Posted December 1, 2007 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 Posted December 1, 2007 Posted December 1, 2007 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 Posted December 2, 2007 Posted December 2, 2007 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 Posted December 3, 2007 Posted December 3, 2007 8.5+ does, List() Another good reason to upgrade..
Recommended Posts
This topic is 6256 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now