Jump to content


  • Content Count

  • Joined

  • Last visited

  • Days Won


Vaughan last won the day on June 4 2015

Vaughan had the most liked content!

Community Reputation

102 Excellent

About Vaughan

  • Rank
    Mostly Harmless
  • Birthday 03/30/1962

Profile Information

  • Gender
  • Location
    Sydney, Australia

FileMaker Experience

  • Skill Level
  • FM Application

Platform Environment

  • OS Platform
  • OS Version
    Sierra, Win 10

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. First get a backup copy of the database to play with, the optimum strategy will take some time to work out. Decide how you'd like to clean the data. For instance, should double-dots be replaced with a single dot or removed completely? Replacing double-dots to single would be Substitute( self ; ".." ; "." ) As for cleaning up the rest of the data, the easiest method is to replace the field contents with GetAsNumber( self ) which will take the data, interpret it as a number, and put that number back into the field. This will strip all non-numeric characters and spaces etc. You'll need to test it and see how it looks. "$4.60" will be replaced with "4.6" for instance.
  2. Vaughan

    Aligning FileMaker Security Requirements To Business Interests

    I have had a couple of small to medium clients become aware of their lack of security only when a staff member leaves and takes a copy of the clients (or even the whole database) with them.
  3. Vaughan

    Corrupted file?

    Do you have window zoom set to something other than 100%?
  4. What Matthew said: globals calculate differently when hosted. You need a preferences table to store the file path, not a global field.
  5. Vaughan

    Corrupted file?

    The scrolling issue sounds like software problems rather than file corruption. What version FMP are you using? If is anything less than FMP 10 then it's probably not compatible with your OS.
  6. Vaughan

    Runtime - Newbie Question

    Budget for a license of FileMaker Server and a dedicated box to use as the FMS host.
  7. Vaughan

    Server script on computer startup

    I say it too. My reasoning is this: if the server goes down *unexpectedly* the files need to be checked. If you come in on Monday morning and the files are not available then you know the server went down some time over the weekend. If the server automatically opened them there is no clue that something has gone wrong. I do not want the server opening the (possibly damaged) files up and users going back in a doing work with them. If they went down then they stay down until somebody checks them, possibly restores the previous backups and opens them back up. Also of the server opens the files again then the backup schedules will run. This could possible delete the previous backups that you need to restore from.
  8. Vaughan

    is this ironic or not?

    Once a currency has been de-monetised it is no longer acceptable as currency. The test is taking it to the bank. The old DM may have value to coin collectors, but if you accepted them you'd have to be interested in their condition. I agree with Wim: not a place to be funny. I initially assumed this was some sort of text parsing question. If this was in a contract I'd be reluctant to do business it shows a lack of acumen.
  9. Vaughan

    Cross Linked Primary Keys

    When weird things like this happen to me (typically users report that new records seem to be displaying old data in portals) it's because I've done an import or something and not updated the next serial numbers in primary key fields. Eg: in main table, next serial number is 101. Import 100 records process the data, create new primary keys, etc which now go up to 200. Forget to update the next serial number. User creates new record (pk=101) and it matches old data. So I'd start by checking all serial number key fields and making sure that they are not creating duplicate ehtries, or doing anything else unexpected.
  10. You cannot convert files from Bento to FMP, or FMP to Bento. Data entered into Bento can be imported into a FMP database, but that's not the same as "converting" the file: only re-using the data.
  11. The Get( WindowDesktopHeight ) and Get( WindowDesktopWidth ) functions will return something close to what you ask for, but what will you do with the information: have several different sets of layouts and switch between them based on whether the user has the dock on the bottom or top? You could I suppose, but it's be a HUGE amount of work to create and even MORE to maintain, and it still won't really solve the problem that there is an infinite variety of screen sizes and OS interface user preferences that the solution could run on, and for which you have no control. Any solution that uses applescript will not be cross-platform. The majority of FMP licenses are for Windows. Ultimately, the size and position of a solution's windows are under the control of the user, not the developer.
  12. Ultimately all you can do is design for the default sizes and positions of windows and OS widgets, or if you're keen, take into account the window size when the dock/taskbar is on the side rather than the bottom. If I want to make my task bar half the height of the window, there is nothing you (as developer) can do about it. Decide what the *smallest* screen your solution will support. For me it's Apple Macbook Pro 13 inch 1280 by 800. Make a test file with a layout and size this so the window just fits without the scroll bars appearing. Now move the dock to the side and resize the width of the window so it still fits. Load this same file onto a machine running Windows 7 (and/or 8) and resize the layout so it fits. Only make a dimension smaller, not larger. The resulting layout is now cross-platform.
  13. Preview mode only relates to FileMaker Pro. When accessing a database in IWP you're using a web browser.
  14. Vaughan

    Dynamically Resize Field / Layout

    Create a calculation text field that is = the other field, and put this cal field on the layout. Allow entry into the field and users can scroll, select and copy the text but cannot edit it (because it's a calc field).
  15. Page scaling and the generic "any printer" option (and print to pdf) is standard on Mac OS X but not WindOS. The page scaling option is usually available in WindOS if the driver is Postscript, but PS drives are not always available and if they are they are usually not installed by default so it cannot be relied upon even for PS printers. To make the printing more portable, consider using only the intersection of A4 and US Letter as your design template, then use the auto-sizing feature to allow the objects to expand if there is more room (or let them centre themselves on the page). A4 = 210 x 297 mm US Letter = 216 x 279 mm US Legal = 216 x 355 mm A design template for a "safe" print layout should be 210x279 mm.

Important Information

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