Solved

Filemaker List Function Numbering returned items

Posted on 2014-07-31
2
607 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

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…
Come and listen to Percona CEO Peter Zaitsev discuss what’s new in Percona open source software, including Percona Server for MySQL (https://www.percona.com/software/mysql-database/percona-server) and MongoDB (https://www.percona.com/software/mongo-…
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…

695 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