• Content count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About Guy_Smith

  • Rank
  • Birthday

Profile Information

  • Gender
  • Location

FIleMaker Profile

  • Profile Updated
  • FM Application
    15 Advanced
  • Platform
    Mac OS X El Capitan
  • Skill Level

Recent Profile Visitors

1,022 profile views
  1. Thanks for your time and patience on this, webko, but I think I'm even more confused now: I thought the whole purpose of sliding left was to strip away the extra blank space in the leftmost block to allow for differing lengths of text, such as names. Is there a better way to merge the fields together to avoid this 'gap-osis'? Thanks again!
  2. Lee and webko: Thanks so much for your feedback. The revised calc makes my solution a LOT more robust and will prove useful in making some of my earlier attempts work much better! webko: I'm still a bit confused about "...The problem was that the second text black had a fixed left point, leading to the extra space..." Where do I find the fixed left point setting? I've gone through every panel in the inspector, but can't find anything different between the two strings: The text attributes are the same, there is no padding in either, and all indents are set to zero. Can I please bug you one more time and have you explain this to me in noob-speak? Thanks again - you guys rock!
  3. I've read through the previous posts on things not sliding left properly and I've tried all of the known fixes, and I'm still stumped. Here's my problem: I'm trying to get a mailing label layout to display a comma and then any suffix that may follow a person's name (such as Ph.D, PE, MSCE, etc.), but if there is no suffix, then I do not want the comma to display. Should be a piece of cake, right?! Ummm...Nope! I have fields for prefix (Dr., Ms., Mr., etc.), first name, last name, and suffix. I first added a calculation field to combine the prefix, first name, and last name: = Prefix & " " & First_Name & " " & Last_Name and a second calculation field to combine a comma and the suffix: = ", " & Suffix. The comma and suffix field is conditionally formatted to be white if there is no suffix. When viewed in Browse Mode, it's looks wonky, but, OK, it's sorta supposed to look goofy, so I can handle that - let's switch to Preview mode and see what happens: There is a gap between the last letter of the last name and the comma - about two letter-width's. And printing it shows the same problem - way too much room between the last name and the comma. I have quadruple-checked the following: The fields are touching - I've even tried overlapping by a pixel or two just to make sure, to no avail. All fields are set to left and top, all padding is set to zero, and, yes, I did check the 'Remove blank space by: Sliding Left' checkbox. And I've tried the above using the original text fields (plus a new text field for the comma), my added calc fields, and merge fields. I'm also not sure why I have a blank label/page between each entry - may be a field is too close to the edge, but I'll worry about that later. I have attached a copy of the offending file for reference. I'm sure it's something simple, but I just can't find it - any help would be greatly appreciated! Mailing_Label_test_1.fmp12
  4. Thanks to the both of you - That answered my concerns about the DDR not showing all of the script calls possible and I also now know how to test for OMG's. As always, your time and assistance are greatly appreciated. Best Regards, Guy
  5. Is it always safe to delete a script when the DDR lists no Layouts that use the script and no other Scripts that call the script? I'm trying to clean up my file without shooting myself in the foot: I can't think of why I would ever need such a script, but don't want to find out the hard way that I could still need them. Thanks in advance, Guy
  6. Thanks, Gentlemen: Turns out the problem was a layout that "lost" its association to a Table - once I reassigned the table, everything worked as expected. Your knowledge and assistance are greatly appreciated! Best Regards, Guy
  7. YIKES! I tried to generate a DDR for my solution and got the following error: SAXParseException: Invalid character 0x12 in attribute value 'PlatformType' (Occurred in entity C:/Users\guys\AppData\Local\Temp\FMTEMPFM5128_4.tmp', at lime 24503, column 981.) I have attached a screenshot for clarity. The PlatformType bit is interesting as I work on the file at my office on a PC (Windows 10) and at home on a Mac (OS X Sierra). I clicked the OK Button three times and a DDR popped up, but only contained the Report Overview Page: The correct amounts of Tables, Relationships, etc. showed up, but none of the links work: It's an empty DDR. After shutting down FMP, reopening the file and trying again, I received the same error except the "FMTEMPFM5128_4.tmp" changed slightly to "FMTEMPFM5128_6.tmp". (the 6 replaced the 4) I am, as usual, clueless - any ideas out there? Thanks, Guy SAX Parse Exception 092916.pdf
  8. Hmmm... Could be. I already reset the font cache and the problem went away - if it comes up again, I'll try the restart trick and see what happens. Thanks for the added insight.
  9. Thanks, Josh - I sure appreciate the quick response! I'll have to get my IT gurus to get that done - they have our computers locked down pretty tight, but I'm glad to hear that it's not terminal!
  10. This is getting frustrating: About ten percent of the time I open a file, all of the layouts are displaying in a font named Z@R701E.tmp or, less commonly, Z@R6FAB.tmp. If I close and reopen the file a number of times, the problem will sometimes self-correct and show the normal fonts (I only use Arial, Calibri, and Times New Roman), but sometimes I have to go through every layout and reset the fonts. This only happens to my FMP 15 files - no other programs have been affected. I have attached a screen shot for clarification. Any ideas? Thanks, Guy Weird font example.pdf
  11. Admittedly I'm a noob wading around in the deep end of the pool, but can't you use the data tab on the Inspector to set the number of decimal places to 1? The underlying data in the Table doesn't change from what was entered so the accuracy isn't altered, but the display is now in the format I think you are looking for (You entered 1.0 and it will display as 1.0). hth
  12. Hmmm... After evaluating my true abilities at database design, the model that best matches my talents is the Amorphous/Chaotic concept! Now that I understand the rationale behind the duplication in the A/B model, i will probably continue with that for my current project, but am looking forward to exploring other methods as I gain more familiarity with FMPro. Thanks again to all of you for your insights. Best Regards, Guy
  13. Wim: Thanks very much for the link. Interestingly, the Kevin Frank & Associates website states "Note: These legacy materials are more than ten years old, and are provided as a service to the FileMaker community. We no longer use, or advocate using, the Anchor/Buoy technique." I've now gotten a thumbs down from both KF&A and comment about using Anchor-Buoy: For a relatively simple solution (a dozen tables and a max of a few thousand total records), what graph model would you choose?
  14. Comment: Thanks very much for the link to Ray Cologon's outstanding article on graph modeling. Your characterization of the TO redundancy in anchor-buoy model being the model itself really made sense to me after reading the article. As scary as it sounds, I think that I'm actually starting to understand the finer points of how the Relationships Graph works. Thanks again for your guidance and enjoy your day! Best Regards, Guy
  15. Thanks very much for the link, comment! I'm used to twelve steps, so a mere 9 ought to be a piece of cake May I assume you prefer Selector/Connector?