Solved

rearranging filemaker records manually

Posted on 2003-11-17
6
469 Views
Last Modified: 2006-11-17
hello i have afilemaker database and would like to rearrange the order of records manually  is this possible without using a specific field and  applying sorting ???

thanks
benjamin martin
benjiart@wanadoo.fr
0
Comment
Question by:benjiart
  • 3
  • 2
6 Comments
 
LVL 3

Accepted Solution

by:
Mariano_Peterson earned 250 total points
ID: 9765233
No.  By default FileMaker sorts the records by their interal recordID.  If you want to change the order in which they appear then you must apply a sort of some kind... whether its in a list view or a portal.  People frequently add a "sort" number field to the table and then sort the records based on that sort field.  This allows them to customize the order in which the records appear by assigning different numbers to the different records.
0
 

Author Comment

by:benjiart
ID: 9765277
thanks for the quick response unfortunately thats what i thought
the sort number field is definitly a good solution the longterm problem is that the database will be frequently modified records will be added
and not necesarily in order so if a record needs to be added in as number 2 we would have to rename number 2 as number 3  etc,,,
is there a scripting solution to this ???  
thanks again for your answer
benjamin martin
0
 
LVL 3

Expert Comment

by:Mariano_Peterson
ID: 9766862
Yes, you could script it but that could rather tedious.  You'd have to create a script and layout that would show the users the current list of records, allow the user to select an existing record, and also allow the user to specify whether their record should be sorted immediately before or immediately after the record selected from the list.

The other problem is that the list would not be sorted when the users first navigate to it - you'd have to have a script that would sort the list for them based on the sort field.

I would not re-number the other fields when you set the sort field.  Rather, I'd use decimals and move 1 and 0's around:

You have Brian
select John (to move Brian AFTER John)
      .1  John
      .2  Mary
      .3  Jane
      .4  Brian
--> set Brian to John & "1" (.11)


you have Jane
select Brian (to move Jane AFTER Brian)
      .1  John
      .11 Brian
      .2  Mary
      .3  Jane
--> set Jane to Brian & "1" (.111)


special case:
you have Mary
make Mary the first
      .1       John
      .11      Brian
      .111      Jane
      2.0      Mary
--> set Mary to ".0" & decimal portion of first (1)

you end up with:
      .01      Mary
      .1      John
      .11      Brian
      .111      Jane
0
How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

 
LVL 3

Expert Comment

by:Mariano_Peterson
ID: 9766872
Oh by the way, the sort field should be a number field, with auto-enter options "serial number", next value 0.1, and increment by 1.
0
 

Author Comment

by:benjiart
ID: 9766902
thank yoiu and thank you also for your help on my other question

;-)) benjamin
0
 

Expert Comment

by:Store
ID: 9839546
Another solution would be to:

1) add records your database
2) export all records (with all fields selected) to an intermediate database
3) delete all records in the initial database
4) sort the intermediate database in the desired order
5) import all records from the intemediate database to the initial database

The entire process can be scripted.

However, I would recommend that you revise your strategi entirely. Why would you want to have your records in a specific, Rolodex-style order?

One of the reasons for building a database is the ability to find records that meet specific requirements and then sort the records in the desired order and the format the output (labels, lists, etc) for your needs.

 As the number of records grow to hundreds or thousands or millions, you will lose control of the order of your records and it will become totally impossible manage it using the proposed approach.
0

Featured Post

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

Pop up windows can be a useful feature of any Filemaker database.  Though best used sparingly, they can be employed in a multitude of different ways, for example;  as a splash screen at login, during scripted processes to control user input, as pick…
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…
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
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.

747 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

15 Experts available now in Live!

Get 1:1 Help Now