A workaround for the annoying "keep sorted" behavior of version 10.

SortOnce10.fp7.zip

Wow, what a great use of the Replace command. I was so happy to NOT see a recursive custom function to gather the IDs.

Love it!

Hi comment

may be I didn't understand but why not use a "dummy" empty field ?

If the last sort is by that, records will not move to another position.

SortOnce10MOD.zip

Because sorting by empty field is sorting by creation order (same as Unsort Records).

Ok, I can see it.

But, what if the dummy number field contains serial numbers starting from 1, setted by a replace field contents ?

3 script steps and only 1 more field.

And only one user.

?

Your Replace[ ] doesn't get the record looking ?

Edit: OK, I understand now why you used a global field.

Edited August 28, 200916 yr by Guest

It's not (only) about record locking; each user can have their own sort order.

An alternative method has been suggested in several places, e.g.

http://forum-en.filemaker.com/fm/board/message?board.id=aut&message.id=957#M957

http://www.ulearnit.com.au/blog/?p=62

It is based on auto-sort being suspended while a script is in progress - so if you make sure you have a paused script during data entry, records will not auto-sort.