Optional Script

[FMNewbie31]

Hello FMForum!

 

I am new to the forums, but I have a question regarding the creation of a header sort within a list layout. Let's say I've created a sort script that sorts the columns from descending/ascending. However, within this layout; I've also created a sub summary that sorts the record according to a certain category. 

 

What I want to do is include this category within the listings and create it so that the script for the button will give me the option to LEAVE the sub summary thus totally eliminating it and sorting the list according to the category within the layout. 

 

Suggestions?

 

TY!

[Lee Smith]

What view are you trying to do this in? i.e. Table, Form or List.

[FMNewbie31]

Sorry! I should've added more information... So I'm doing this on List View and my current script looks something like the one attached to this message. 

[Lee Smith]

The first time I read your question, it sounded like you were in Table View, now it sounds more like you are creating a report?

 

Where did you find this script?

[FMNewbie31]

I "copied" the script from a sample database. but a lot of it is actually my own input into it. 

 

My problem i found out was that the sub summary uses the same parameter as the field that i'm sorting. so when i sort the column, the sub-summary remains there. is there anyway to remove the sub-summary without duplicating the layout and creating a script where the button will navigate to that second layout without the sub-summary? 

 

IE: when i sort from something else under a certain column like price the sub-summary goes away. but when i sort by that category (which has its own field) the  sub summary remains and kind of throws my whole layout into a funk where it's trying to sort the category ascending without the sub summary...

 

Does that makes sense???