Join Cris Ippolite for an in-depth discussion in this video Using the List function, part of FileMaker Pro: Relational Database Design (2011).
- The List functions is one of my favorite functions…in FileMaker.…It's a simple function that does…just what it's name indicates,…it produces a list.…But when you combine that with other functions…in FileMaker calculation dialogues,…it can become very powerful.…Let me show you a List function…and take a look at the value it produces…so we can kind of start there…with your understanding of…how this can help enhance your FileMaker database.…We'll go under the Manage Database dialogue,…under Fields.…Under Customers we're going to create a new field…called OrderList.…
Let's make this one a Calculation…so that we can use Calculation function…and you Create.…The List function is an Aggregate function…found under the Aggregate function group.…Much like the other Aggregate functions,…the parameters that it has…are just a series of different fields…inside the parentheses.…Since all it's doing is creating a…return delimited list of values,…it doesn't really make much sense…to just put a bunch of local fields in here.…Since really you could just create a calculation that…
The course applies to versions of FileMaker Pro from 7 through the most current version.
- Reviewing relationships types
- Diagramming relationships
- Resolving many-to-many relationships
- Determining which tables need key fields
- Defining tables in FileMaker Pro
- Using the Relationship Graph
- Using multiple match fields in one relationship
- Using global fields to filter portals
- Creating self relationships
- Creating aggregate functions using relationships
Skill Level Intermediate
Q: The exercise files for this course do not work on a Mac. It downloads executable files. Can you provide a workaround?
A: The files provided for this course were made pre-FileMaker Pro 12. The system does not recognize the .fp7 files immediately as something that can be opened with FileMaker Pro 12 and instead shows them as Unix Executable Files.
The solution is quite simple. Just double-click the file, at which point the Mac will prompt you to choose an application to open the
file with. Select FileMaker Pro 12 and it will then convert the file from a .fp7 file into the new FileMaker Pro 12 file format, which is .fmp12.
Q: This course was updated on 5/12/2015. What changed?
A: We moved a video from the "Using Relationships" chapter of FileMaker Pro 13 Essential Training into this course, where it will remain evergreen.