Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

rearranging filemaker records manually

Posted on 2003-11-17
6
Medium Priority
?
480 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
[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
  • 3
  • 2
6 Comments
 
LVL 3

Accepted Solution

by:
Mariano_Peterson earned 750 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
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

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…
In response to a need for security and privacy, and to continue fostering an environment members can turn to for support, solutions, and education, Experts Exchange has created anonymous question capabilities. This new feature is available to our Pr…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

609 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