Solved

rearranging filemaker records manually

Posted on 2003-11-17
6
470 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
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Filemaker List Function Numbering returned items 2 550
Installing Local Filmaker Database On Ipad - FMGO 1 206
FM External Data Sources Tables 3 570
New to FMP 6 126
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…
Having just upgraded from Filemaker 11 to Filemaker 12 over the weekend, we thought we would add some tips for others making the same move.  In general, our installation went without incident. Please note that this is not a replacement for Chapter 5…
This tutorial demonstrates a quick way of adding group price to multiple Magento products.
Delivering innovative fully-managed cloud services for mission-critical applications requires expertise in multiple areas plus vision and commitment. Meet a few of the people behind the quality services of Concerto.

914 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

14 Experts available now in Live!

Get 1:1 Help Now