Solved

Filemaker List Function Numbering returned items

Posted on 2014-07-31
2
565 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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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…
Having just upgraded from Filemaker 11 to Filemaker 12 over the weekend, we thought we would add some tips for others making the same move.  In general, our installation went without incident. Please note that this is not a replacement for Chapter 5…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

828 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