This site uses tracking cookies. By using this site, you agree to our Privacy Policy. If you don't opt in, some parts of the site might not function.
Blog
Home / Blog / FileMaker / Portal Column Techniques: Sort, Filter, and Batch Update
10Oct 2018

Portal Column Techniques: Sort, Filter, and Batch Update

About the Author

Makah Encarnacao Makah Encarnacao

Makah is a Technical Project Lead that hails from Albuquerque, NM. She joined Soliant a few months after graduating from UCLA in 2007, and must like it a lot because she’s still here! She is certified in FileMaker 9, 10, 11, 12, 13, 14, 15, 16 and 17, and placed 4th in the 2015 FileMaker DevCon Developer Cup. She was a speaker at the 2016 and 2018 FileMaker Conference. When she is not coding, she is enjoying life with her family that recently increased by 1.

Comments (6)

John Ahn - February 8, 2019

I randomly came across your post while trying to help someone with a development question. Glad to see that people are still looking at my old samples, even though I never went back and polished them. 🙂

– John ( mr_vodka )

Reply
John Ahn - February 8, 2019

Sorry cant edit my comment haha. I meant, glad to see that people can still make use of my old sample file even though I never went back and polished them. Your post is great and will help a bunch of people hopefully. 🙂

Reply
    Makah Encarnacao
    Makah Encarnacao - February 8, 2019

    Hi John,
    Thanks so much for taking the time to leave a comment 🙂 And of course thank your for your original technique that was so helpful for me.

    Cheers (with vodka!),
    Makah

Tom Fitch - February 20, 2019

Nice writeup, Makah. For history nerds, this method of portal sorting originated here:
http://www.fitchandfitch.com/2011/05/filemaker-portal-sorting/

I’d encourage folks to check it out, there’s some interesting comments there as well as sample files and a followup article. Kind of crazy that 8 years later this is still the best method I know to sort a portal.

John’s innovation was using ExecuteSQL to gather the ID list, which wasn’t an option at the time I wrote that article. And even though we now have the Summary field ‘List Of’ option which is super fast, ExecuteSQL has the ability to bake the sort order into the query so most of the time is going to be the best option.

Lastly, here is an elegant version of the sort calc:
https://www.briandunning.com/cf/1300

Reply
    John Ahn - March 13, 2019

    Indeed Tom. Your technique still one of the best and widely used. Hopefully people will read your original post and also through the comments on the original forum thread ( which has a link to your website as well ), as both have some interesting followup posts

Leave a Reply