A READER ASKS: FileMaker 10 Automatic Sorts And Schema Changes

From Dwayne Wright PMP, PMI-ACP, CSM
Certified FileMaker Developer

WEB: www.dwaynewright.com
EMAIL: info@dwaynewright.com
TWITTER: dwaynewright
YOUTUBE: FileMakerThoughts


A READER ASKS:

I’m considering upgrading to FileMaker 10 but I have a couple questions about the automatic sorting feature.

If the sort order is based upon a field that is changed from text to number, will this trigger a re-sort automatically?

If the sort order is based upon a value list of options, if you change the value list in schema, will this trigger a re-sort of the found set?

-------
DWAYNE RESPONDS
What great questions and this is an aspect of the FileMaker 10 sorting I had not considered before! I had to open up a copy of FileMaker 10 and experiment with this myself.


There is a related movie on this topic! CLICK HERE!

 

From what I can tell in my testing and shown in the movie link above ...

If the sort order is based upon a field that is changed from text to number, will this trigger a re-sort automatically? YES!

If the sort order is based upon a value list of options, if you change the value list in schema, will this trigger a re-sort of the found set? NO!

 

=
More info about the author and FileMaker in general, contact me at info@dwaynewright.com.

© 2009 - Dwayne Wright - dwaynewright.com

The material on this document is offered AS IS. There is NO REPRESENTATION OR WARRANTY, expressed or implied, nor does any other contributor to this document. WARRANTIES OF MERCHANT ABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE EXPRESSLY DISCLAIMED. Consequential and incidental damages are expressly excluded. FileMaker Pro is the registered trademark of FileMaker Inc.