Solved

Filemaker List Function Numbering returned items

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

Accepted Solution

by:
Will Loving earned 500 total points
Comment Utility
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
Comment Utility
Will Loving is a very good with Filemaker. Excellent work. Thanks!
0

Featured Post

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

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 video discusses moving either the default database or any database to a new volume.
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.

763 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now