July 11, 201213 yr 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
July 11, 201213 yr 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.
July 11, 201213 yr 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
July 11, 201213 yr 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?
Create an account or sign in to comment