richardbabley Posted July 11, 2012 Posted July 11, 2012 I'm trying to set up a Sort script so I can sort all my records by various fields. But the script I've set up isn't working and I don't know why! Could someone have a look and see what's going on with it? Thank you! H&S Database Test.fmp12.zip
mr_vodka Posted July 11, 2012 Posted July 11, 2012 What script? When you choose the pop up menu, the script associated with the trigger can not be found because its been deleted. Perhaps you accidentally deleted making the sample file? Also, I have deleted your duplicate post. Please do not double post.
Lee Smith Posted July 11, 2012 Posted July 11, 2012 is this the script? Script Triggers: Trigger | Sort Content List If [ $$SCRIPT_TRIGGER = "Off" ] Set Variable [ $$SCRIPT_TRIGGER; Value:"On" ] Exit Script [ ] End If Set Variable [ $$FIND_SIMILAR; Value:"" ] If [ /*Contents::Sort Selection = "Status"*/ ] Sort Records [ Keep records in sorted order ] [ Restore; No dialog ] Else If [ /*Contents::Sort Selection = "Type"*/ ] Sort Records [ Keep records in sorted order ] [ Restore; No dialog ] Else If [ /*Contents::Sort Selection = "Title"*/ ] Sort Records [ Keep records in sorted order; Specified Sort Order: ascending ] [ Restore; No dialog ] Else If [ /*Contents::Sort Selection = "Time Frame"*/ ] Sort Records [ Keep records in sorted order; Specified Sort Order: ascending ascending descending ] [ Restore; No dialog ] Else Sort Records [ Keep records in sorted order; Specified Sort Order: ascending ascending ] [ Restore; No dialog ] End If Go to Record/Request/Page [ First ] Note: The if statements are commented out
Lee Smith Posted July 11, 2012 Posted July 11, 2012 I agree with Barbara about giving a subject title that means something. Imagine if you will, if all of the subjects were named "Help" or something similar. Why not use the Table View for this layout, then they can just sort by using the columns?
Recommended Posts
This topic is 4819 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now