Script Sort Problem
I have a table (Concessions) used for scheduling volunteers. Two reports use the table to show the schedule and another to show the total hours of each volunteer. Two separate button activated scripts drive each of these reports. The first time a button is clicked from the "Home Screen" all displays correctly for the chosen report. Returning to the "Home Screen" and clicking on the other script button results in a sorting issue, the last button sort order is used and not the expected sort order for the script chosen.
What needs to be done to rectify this problem (this happens on both platforms mac and pc)