I must be blind. But I cannot determine how to sort a portal row outside of the preset sort. I want to be able to sort the data in the portal by the field names. Thoughts??

Thanks!!!

Right-click on your portal, dnowlan, and select 'Portal sort'

Thank you, however, I missed some important info. i need to automate the sort in the portal by scripts and button clicks and it need to be compatible with the web.

Anyone have any insight on this? Very appreciated. Thanks!

(First post ever - Mwahahaha)

I dont believe FMP gives u any way to directly do this in any easy way... But I have had and solved this problem myself, in the hard way..

I made my portal and sorted it asc by a field called this_is_my_sort_field.

This field contained a calculation that gave it numbers (the current record number or record_count - current record number, read ASC and DESC)

Then i used a global_var to tell my calculation which field i wanted to sort by..

Something like this:

Case(

Menu::Current_Sort = "1"; Get ( RecordNumber );

Menu::Current_Sort = "2"; Menu::Buttons_Count - Get ( RecordNumber );

Menu::Current_Sort = "3"; b_Order;

Menu::Current_Sort = "4"; Menu::Buttons_Count - b_Order;

)

b_Order is the default order setup by the admin (could be anything really)

This was the basic of how one of my mac os x finder alike menu's works.. hope this brings light to your problem? )

- Matte