Jump to content

Jeep Watson

  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About Jeep Watson

  • Rank
  • Birthday 04/22/1947

Profile Information

  • Gender
  • Location

FileMaker Experience

  • Skill Level
  • FM Application
    16 Advanced

Platform Environment

  • OS Platform
  • OS Version
  1. For quite a while now, I've been trying to perfect a good List View sorting framework that would take a minimum of fields and scripts and be fairly portable. I recently saw one that Ocean West posted that hit almost all the needs. I had been using a script very similar to his, but Stephen took it one step further by abstracting the column header names. Instead of each header being static type, he created a sortfield calculation that calculated the button's name, sort direction, and sort indicator --- MUCH easier to move to a different table or solution. http://fmforums.com/forum/topic/69150-sorting-lists-sort-order-indicators/?hl=dynamc+sort#entry327786 The only drawbacks I found were that if the sort status changed, the indicator did not. Also more importantly, if you entered Find Mode, the calculated type in the headers disappeared. I played around with things and came up with a couple of solutions that work. I added a condition in the sortfield calc that If Get ( SortState ) ≠ 1 then the Indicators disappeared. As for the Find mode problem, I used an OnModeEnter script trigger that called a script called Set FieldNames that set a global variable ($$FieldNames) to a string that equaled the names of the sort headers. It was a little tricky to get the spacing correct --- trial and error with spaces. Then I placed the global on the layout exactly on top of the headers and used conditional formatting so that the global would only be visible in Find Mode. I also changed the color of the header for the sorted column with conditional formatting. I'm posting the file here for others to dissect and see if they can come up with a more elegant solution for the Find mode dilemma. I really don't like type stacked on top of type in layout mode --- it's so hard to read at a glance without moving something. It's also time consuming to format. My initial efforts were to try to add the conditions in the sort field calculation. That would be nice and tidy but I got zilch, nada... Any ideas out there?? Sort - JW.zip
  2. I've attached a sample file showing one method using a separate table occurence for each of the statuses (I only implemented 3) and establishing relationships based on those statuses. It might be a bit to get your head around initially but read the Filemaker help files about relationships. StatusTrack.zip
  3. I think you might be missing Bruce's point. It's now very quick and efficient to do this with conditional formatting and a 2 line script. Not clunky at all. Try this... RowHighlight.fp7.zip
  4. I stumbled on this post about a month later. If you're still looking for ideas, try doing what programmers do in other languages -- draw the new window offscreen. I do it all the time for a wide variety of reasons. Attached is a screenshot of a Printing script that needs a formatted layout that I'd rather the end user not see. He just sees a quick progress bar and the visible layout never changes.
  5. Your profile shows that you're using 8 Advanced. Your request talks about "triggering" a script. The attached file does what you are asking but requires v10 to work. If you are using v10, try this -- it does exactly what you are asking for. Notice also that the Value List (a list of layout names) in this case is built dynamically by using a design function -- LayoutNames ( Get ( FileName ) ). If you're not using v10, you're missing out on the best FM upgrade ever. Script triggers alone are worth the upgrade price -- absolutely awesome. EventDrivenMenus_v4.fp7.zip
  6. Make one container with 4 repetitions (one for each graphic) and one container to display the desired graphic. Have your script tell the display container which repetition of the storage container to display. I've attached a small demo doing it all in one window (a little more compact interface) and also doing it with a new window to display the result. If you need to use a new window for the display there are some drawbacks if you need to see more than one display window at a time (for side by side comparisons for example). All the windows would display the same graphic. I'm sure it can be worked around but I'm too tired to work it out right now. 2Containers.zip
  7. In my experimentation with custom menus, I created a new menu set and then added some custom menu items. It seems that once you create an item, you can not delete it without deleting the whole menu set and starting over. I created a menu set for a particular layout and added a custom menu "Job Scripts". When I discovered that you CAN indeed delete the [scripts] menu from your set and create your own custom Scripts menu with no naming conflict, I did just that. Now I want to delete the original "Job Scripts" but there is no delete option - only Create, Edit or Duplicate. Seems like a real faux pas on Filemaker's part. I realize that I could rename the menu and change the definitions in it and just re-use it but it seems very inelegant. Anybody have any ideas or am I missing something?
  8. Try this: Just make a script with one step: Show Custom Dialog []. Then paste the following into the message field: Get ( WindowHeight ) & " Height¶" & Get ( WindowWidth ) & " Width¶" & Get ( WindowTop ) & " Top¶" & Get ( WindowLeft ) & " Left" Anytime you run the script it will show the specs for the active window. Jot them down and make your changes.
  9. hey comment... that's great! I think I like the custom function better - it's a little easier to plug into other solutions. I'll have to spend some time and try to get my head around the Div function and how Mod and Div work in conjunction in the custom function. Are they used together like this frequently?
  10. to all... I've also played around with trying to create a recursive custom function for the Sum of the Digits but haven't been able to work it out. Here's the last approach I worked with but if you try it, you'll see it's close but no cigar. (recursion makes me dizz!y). Anybody have any ideas? Let ( len = Length ( num ) ; Case ( len > 1 ; SumDigits ( Left ( num ; len-1 ) ) + Left ( num ; len ) ; num ) )
  11. max... coming in late to this discussion, but it's one I've been dabbling with for a year and a half... 1 - a checksum IS required for all zips whether they be 5,9, or 11 digits 2 - the explanation directly from the USPS Publication 25 Chapter 4... "Correction Code: Whether it represents five-, nine-, or eleven-digit ZIP Code information, the POSTNET barcode is always printed in a format that begins and ends with a frame bar (full or tall bar). To ensure POSTNET accuracy during mail processing, a correction character (five bars) must be included immediately before the rightmost frame bar of all POSTNET barcodes (see exhibit 5-3). The correction character is always the digit that, when added to the sum of the other digits in the barcode, results in a total that is a multiple of 10. For example, the sum of the ZIP+4 barcode 12345-6789 is 45. Adding a correction character of 5 results in the sum of the 10 digits being a multiple of 10." 3 - The first part, summing the digits - The Luhn Algorithm may or may not work but it seems like a rather odd approach for a non-mathematician. The most elegant solution for the Sum of the Digits I've come up with so far is: Let ( n= ZipStrip ; Evaluate ( Substitute (n ; [ "0" ; "0+" ] ; [ "1" ; "1+" ] ; [ "2" ; "2+" ] ; [ "3" ; "3+" ] ; [ "4" ; "4+" ] ; [ "5" ; "5+" ] ; [ "6" ; "6+" ] ; [ "7" ; "7+" ] ; [ "8" ; "8+" ] ; [ "9" ; "9+" ] ) & "0" ) ) where ZipStrip is a previously created calc to strip unwanted chars: Filter ( Zip ; "1234567890" ) If anyone has a shorter, more elegant way, I'd love to see it... 4 - The other MAJOR part of the solution is to calculate the Checksum or Checkdigit. I've done calcs that are 60 or 70 lines long that worked - I've seen approaches by others that were very similar. But they all seemed overly long and complex for something that should be able to be expressed as a rather simple mathematical statement. It took me a long time and a lot of research to come up with but here is the most elegant solution to this part: Mod(10-Mod(calc_SumDigits; 10); 10)
  12. Yes - automatic progress bars! And along the same lines, how about automatic row highlighting in list view - another thing that takes a lot of developer effort but should be built in and simple. And one other thing that takes a LOT of work to set up and maintain is column header buttons to indicate sort status and direction. It SHOULD be simple - its already there in table view. Click the column header to sort by that column and the header is highlighted - click it again to toggle the sort direction.
  13. This was a problem that took me a long time and a lot of research to solve. Here's a sample of what I came up with. It uses the free FM Example plugin that comes with FM 7 Developer and FM 8 Pro Advanced. It has the added advantage that it works with any method of record selection (not just clicking but also moving up or down with keyboard commands). hilite_test.zip
  14. What version of FM? I have a simple demo I wrote of precisely what you want to do but it is in FM7 and uses a free plugin (supplied by Filemaker) that is attached to the file.
  15. Sounds like a font cache problem. We encounter this occasionally in our prepress department where we use hundreds of different fonts a day. Careful font management can eliminate this but is beyond the scope of a quick reply. Basically you probably have conflicting fonts or different versions of the same font running simultaneously. The quick fix is to download a font cache cleaner and run it. I like Font Finagler - it's a one trick pony that you can get at Versiontracker.com. Other more full featured cleaners (like Cocktail) would probably work also. Run Font Finagler and it will force a restart of your machine. After the restart all should be fine. Be advised though that the problem will likely return unless you take tighter control of your fonts. There are articles on the internet addressing this. I think Extensis has a couple of fairly generic articles (not just ads for Suitcase) addressing this.
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.