Sorting Data Super Fast

[FileMaker Magazine]

No Access? Watch the preview video here. SortingDataFast_Pre.mp4

Attachment	Size
SortingDataSuperFast.zip	319.53 KB

By Matt Petrowsky

Inside of FileMaker is one of the most powerful engines you could ever hope for. It's not even the native FileMaker calculation engine. It has almost two decades of optimization applied to it, and much of the world's most popular software takes full advantage of it. It's JavaScript - and you have access to it.

If you don't (yet) know JavaScript then you can't say "Oh, I just do FileMaker". Because doing so is the same as saying "Oh, I don't really care about solution speed."

In this video article and technique file, you'll find some of the most powerful code for accessing things FileMaker can't currently do and this extends well beyond the topic of sorting.

When it comes to sorting data, not records, there's no native 'filemaker' way of doing this. The solution is typically either FileMaker's custom functions, some creative trick with sorting records or using a plugin.

However, with the use of the readily available JavaScript, you can sort all kinds of things in all kinds of ways. This video will gently introduce you to using one of the tools you should certainly have in your mental toolbox!

View the full article