We have reset all users FileMaker related profile fields. Please take the opportunity to update your information,  this will provide background to members whom read your posts. Click here.

Jump to content


  • Content count

  • Joined

  • Last visited

Community Reputation

1 Neutral

About jasonwood

  • Rank
  • Birthday 01/08/1982

Profile Information

  • Real Name
    Jason Wood
  • Gender
  • Location
    Toronto, Canada
  1. Troi Serial Plug-in

    If you are having problems, I suggest you open the Terminal.fmp12 file that comes with the Troi Serial Plug-in. You can talk to your serial device there without doing any programming, to make sure the problem is not relating to hardware or serial drivers.
  2. Nesting Portals

    You could also use the List function in Cases to create a field that shows all notes. I assume you are only wanting to read the notes from your Customer layout (no editing), if so, the benefit of showing all notes in one field is that you are not constrained by the fixed height of a portal row. Long and short notes simply flow one after another. First create a calculation in notes that contains everything you want to display for each note (id, user, date, time, note), then create a calculation in Cases using a List() function to combine all the notes into one. You could adapt comment's suggestion #2 by placing a portal to cases on one side of the screen, and a single notes field on the right, which would show all of the notes for the selected case.
  3. Need through relationship

    If you have a field in Products which is a count of suppliers, this will use your relationship and is completely unrelated to the decision on how to setup your portal. If you want to know how many unique suppliers a product has, then I would use a calculation in Products that is a count on PK_Suppliers using your relationship. Depending on your setup, it may be sufficient to count FK_Suppliers from the Lines, but this would double-count suppliers that appear on more than one line (if this is possible in your system). It would also count Lines that have an invalid value in FK_Suppliers (a value that does not correspond to a Supplier). As for the portal, if you only want to display information from Suppliers, then the portal should be to Suppliers (although it doesn't really matter in most cases), but if there is ANY information that you want to display from Lines, then the portal should be from lines. It is no problem to "extend" the relationship with a field from Suppliers in the portal to Lines, but you will have problems if you set up the portal to suppliers and then decide you want to stop half way to get some fields from lines - you'll end up with a line for each supplier but the additional data pulled from Lines will just be a repeat of the first matching Line record on every line of the portal.
  4. Recursive function is the answer. Here's what I came up with: ReplaceOtherChars ( string ; ignorechars ; replacechars ) If ( Filter ( Left ( string ; 1 ) ; ignorechars ) = "" ; replacechar ; Left ( string ; 1 ) ) & If ( Length ( string ) > 1 ; ReplaceOtherChars ( Right ( string ; Length ( string ) - 1 ) ; ignorechars ; replacechar ) ; "" ) Example: ReplaceOtherChars ( "ABC 123 (hello.world!)" ; "0123456789abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ" ; "_" ) Output: ABC_123__hello_world__ The reason I needed this is because native AppleScript no longer works for changing printers in Mac OS X v 10.9 Mavericks because "Printer Setup Utility" is no longer included, so I've realized that rather than installing an old version of Printer Setup Utility, I can just use the lpoptions terminal command to change printers, but the printer name seems to require all non-alphanumeric characters replaced with underscores, otherwise the command fails. (I still want users to be able to enter & view their printer names normally so this custom function will be used each time the printer is changed)
  5. How would I write a calculation to replace all non-alphanumeric characters with an underscore? For example ABC 123 (hello.world!) would become ABC_123__hello_world__
  6. <no values defined> when record access is limited

    yes. My problem was solved when I used a global field instead of a global variable. I don't see why the behaviour should be different, but I'm happy to have gotten it working...
  7. <no values defined> when record access is limited

    PatternCount ( $$userCompanyAccess ; "¶" & id & "¶" ) $$userCompanyAccess contains a list of id's of the company records users are allowed to access. It works from a record viewing perspective. It just breaks the value list for an unknown reason.
  8. <no values defined> when record access is limited

    If I change the record access to "Yes", the value list works, so this is not an issue with layout or value list access. Only once I choose "Limited..." and enter a calculation to determine access, the value list breaks, even if they still have access to some or all of the records (based on the calculation).
  9. I have a value list of the type "Use values from field" and "Use all values". A second field is shown (same table). When I change the record "view" access to "Limited" for the user's privilege set, that user is no longer able to use the value list, even if they have view privileges for all of the records in the table! Popup menus simply display "<no values defined>" Is this normal?
  10. FMSA 12 - Console wont launch - Java Update

    I just noticed FileMaker has updated the below instructions and following the instructions now will resolve the issue completely. http://help.filemaker.com/app/answers/detail/a_id/11958/~/admin-console-wont-start-on-mac-os-x-10.6.8-with-java-1.6.0_51-b1
  11. FMSA 12 - Console wont launch - Java Update

    I had the same problem and fixed it with the instructions here: http://help.filemaker.com/app/answers/detail/a_id/11958/~/admin-console-wont-start-on-mac-os-x-10.6.8-with-java-1.6.0_51-b1 However my web publishing engine still will not start! Help please!
  12. I dragged the "stderr" file from Logs to my desktop. Then I created a new blank file with the same name and permissions and put it in Logs. It didn't work. Then I noticed that the original file, even though it was moved to the desktop, was still receiving new log entries. I tried putting it back in Logs and renaming it, thinking that renaming might be another way to break the link, but no such luck. I guess my next step is to delete the stderr file, and hopefully then it will create a new one?
  13. I am writing a script to periodically update my product catalog in MySQL using data from FileMaker. The MySQL tables have been added to the file. The encoding of the MySQL tables is UTF-8. The method I am using right now is: 1) Find records that I want to be copied to MySQL 2) Go to layout of MySQL table 3) Import records This works well in most cases but problems occur if the product contains a special character like "™". "511™ Slim Fit Jeans" goes into the MySQL text field properly if viewed from Sequel Pro, but in FileMaker, it reads back in as "511 1 1 1 1 1 1 1 1 1 1 1 1". Another example: If I type "Sample™ Product" in a MySQL table in FileMaker, it will read back in as "Sample e e e e". Also, if I attempt to edit these records in FileMaker, I get the error message, "This record was modified by another user since you started editing it. Do you want to save your changes anyway and possibly overwrite their changes?" What's going on here?
  14. The file is normally edited every 5 minutes when a schedule runs. After I dragged the log file to the desktop, the system did not recreate the file. When I put it back in the Logs folder, it resumes editing every 5 minutes. Any idea why it wouldn't recreate the file?
  15. I have a file in Library/FileMaker Server/Logs called "stderr" and it is 3.23GB. My client has one that is 450GB. Mostly it seems to be very detailed errors relating to ScriptMaster bulk email sending. Can I delete this file and system will just create another one? Can I set it up so it delete's older entries to keep the file size reasonable?