Sort Labels by Zip Code

Support, Tips and Tricks for Proof Group's fmSpark "merge anything" utility for FileMaker Pro.
Posts: 9
Joined: Fri Dec 19, 2008 9:21 am
PostPosted: Wed Apr 08, 2009 1:24 pm
Is there a way to sort the labels on the merge to sort by zip code.
I tried to sort the records before running the Create Labels Script. I am using the Sample contacts file that came with "FMSPark"
Posts: 9
Joined: Fri Dec 19, 2008 9:21 am
PostPosted: Wed Apr 08, 2009 1:30 pm
Posted to soon was just using the preview to see if it works. I did the merge and it is in reverse order. But that works.
Proof Group
Proof Group
Posts: 3
Joined: Mon Jun 23, 2008 11:03 am
PostPosted: Wed Apr 08, 2009 5:54 pm
It's actually the building of the list of IDs that operates in reverse order. In the example script in the Sample Contacts file the line that builds the list of IDs currently reads:

Code: Select all
Set Variable [$recordIDList; Value:Contacts::Contact ID & ¶ & $recordIDList]


To change this to build the ID list in the correct order you just need to swap things around:

Code: Select all
Set Variable[$recordIDList; Value:$recordIDList & Contacts::Contact ID & ¶]


Cheers!

Corn Walker
The Proof Group, LLC

Return to fmSpark

Who is online

Users browsing this forum: No registered users and 2 guests

cron
(855) SEEDCODE
support@seedcode.com
Follow us: