EthanK

Alright, let's get complicated. What if I am working with text as well as numerical quantity and price information?

That makes complete sense that Filemaker wouldn't allow sorting by a global field. You'd think there would be an error message or some physical method to keep you from even trying. Here's how I set it up. Not quite as elegant as yours, but it works. 5 Fields: - gAscending - gDescending - cAscending = GetField (gAscending) - cDescending = GetField (gDescending) - gSortToggle (either "A" or "D") - Portal is told to sort by cAscending (Ascending), then by cDescending (Descending) - BUTTON SCRIPT (Parameter = Name of actual field to sort by) If (gSortToggle <> "A") SetField [gDescending; ""] SetField [gAscending ; get (ScriptParameter)] SetField [gSortToggle ; "A"] Else SetField [gAscending ; ""] SetField [gDescending ; get (ScriptParameter)] SetField [gSortToggle ; "D"] End If Refresh Window [Flush cached join results]

Thanks a lot. Actually, I just got it using a slightly different method. Right now I have two global fields (AscendField and DescendField), and two Unstored Calculations that GetField info from the Global Fields. I'm using a multi-field sort on my portal (AscendCalc ascending, then DescendCalc descending). My script then clears out one global field, and puts the necessary Field Name in the other. Then it changes a separate SortToggle Field so it knows whether it's sorted ascending or descending and does the opposite each time you click the button. But still... why does it have to be sorted by a calculation field? Shouldn't just telling the portal to sort by the global fields and changing the those fields with the script work? Thanks for the help.

Alright I got it. Right now I have two global fields (AscendField and DescendField), and two Unstored Calculations that GetField info from the Global Fields. I'm using a multi-field sort on my portal (AscendCalc ascending, then DescendCalc descending). My script then clears out one global field, and puts the necessary Field Name in the other. Then it changes a separate SortToggle Field so it knows whether it's sorted ascending or descending and does the opposite each time you click the button. But still... why does it have to be sorted by a calculation field? Shouldn't just telling the portal to sort by the global fields and changing the those fields with the script work? Thanks for the help.

I am having difficulty wrapping my head around a script that will sort a portal in my document. Basically I would like to create button for each one of the column headers above my portal so that it will sort like Table View. I understand that this is done by telling the portal to sort by a special field that is recalculated by the script, but I'm not sure how to set up the script to change that field for each record. Can someone show me an example of how this is done? Also, can it be done using one script and different parameters, or do I need a new script for every single button? Thanks. Ethan

That is a cool idea. is there a way to lock up the program and keep a window on top until another script is executed?

Is there a way to widen the buttons in a custom dialog so my text doesn't get cut-off? Ethan

$299 is a pretty steep upgrade for just that one feature though... is there anything else that Advanced does that I can't live without? Ethan

Does anybody know of a plug-in or workaround to add Tool Tip Formatting to Filemaker Pro 8? Thanks. Ethan

Hi, Script Steps Reference states that for SetField, the specified fields do not have to be on the current layout. But do they have to be on the current table? If so, is the best way to copy data from a field in one table to a field in another? Right now, this is the only way I can get it to work (code abridged) Go to Layout [X] SetVariable [$fieldX] Goto Layout [Y] SetField [$fieldX] Is this the best way? Thanks. Ethan

Who said anything about numbers? I was talking calculations ;-) Thanks a lot. Ethan

Hi, I'm trying to find a calculation function that will allow me to force a calculation's result to contain a certain number of digits. So if I say 4 digits, then calculations of 1 or 15 would result in 0001 or 0015. Any ideas? Thanks Ethan