Solved

Filemaker List Function Numbering returned items

Posted on 2014-07-31
2
556 Views
Last Modified: 2014-08-01
I wanted to know if it is possible to use the list() function in Filemaker to display the returned items in the list with a leading sequential numbering. For example:
List (customer::orders)
Result desired:
1. Apples
2. Oranges
3. Lemons
4. Lettuce
0
Comment
Question by:PachecoPrimo
2 Comments
 
LVL 25

Accepted Solution

by:
Will Loving earned 500 total points
ID: 40233348
There are several ways to go about this but in the example file attached, I've used a very powerful Custom Function called CustomList( ) available at: http://www.briandunning.com/cf/868 As with all Custom Functions it requires FileMaker Advanced to install.

Using the CustomList( Start ; End ; Function ) function I created the following calculation:

CustomList ( 1 ; ValueCount( List( NumberedList::Fruit ) ) ; "[n] & \". \" & GetValue( List( NumberedList::Fruit ) ; [n] )" )

It's also quite possible to create a simple recursive calculation using the Let() function to do the same thing.
NumberedList.fmp12
0
 

Author Closing Comment

by:PachecoPrimo
ID: 40233596
Will Loving is a very good with Filemaker. Excellent work. Thanks!
0

Featured Post

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Conversion Steps for merging and consolidating separate Filemaker files The following is a step-by-step guide for the process of consolidating two or more FileMaker files (version 7 and later) into a single file with multiple tables. Sometimes th…
Problem: You have a hosted FileMaker database and users are tired of having to use Open Remote or Open Recent to access the database. They say, "can't you just give us something to double-click on rather than have to go through those dialogs?" An…
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

785 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question