Jump to content


  • Posts

  • Joined

  • Last visited

Profile Information

  • Gender

FileMaker Experience

  • Skill Level
  • FM Application

Platform Environment

  • OS Platform
  • OS Version
    Win 10

FileMaker Partner

  • Certification
    Not Certified
  • Membership
    FileMaker TechNet

Recent Profile Visitors

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

djlane's Achievements

Community Regular

Community Regular (8/14)

  • First Post
  • Collaborator
  • Conversation Starter
  • Week One Done
  • One Month Later

Recent Badges



  1. Resolution : It's a bug in this release of scribe, fixed in V5
  2. Hi Sean, Thank you for that. It works, but I'm having an issue. If I try to change the background color of a cell that contains a value, I get a Java Null Pointer Exception Error It works fine if the target Excel cell is empty. It also works fine in your demo file - I can change the background color of any cell no problem. See below image - B17 is OK because it's empty, C17 is not. Any idea what might be causing this ? thanks david
  3. Hi Sean, How do I do this : "use ScribeDocWriteValue as a function instead" ? thanks
  4. Turns out this was just in the field definitions. UNCHECK : Do not replace existing value of field UNCHECK : Prohibit modification of value during data entry CHECK : Data validation, unique values only, Validate always UNCHECK : Data validation, allow user to override during data entry
  5. We have a duplication script takes a single record and duplicates it (plus all related records) around 50 to 100 times. We are using get(UUID) as the auto entered calculation of the pk. Maybe once in one hundred times or less, MS reports a duplicate pk. When we check the database where the record was created (Hub), there is no duplicate key. The duplicate is only on the spoke database, ie in a record created completely by MS. (For this test we created all records on the Hub only). So this means that MS is creating a record in the spoke database but using the wrong primary key for that record, presumably the pk from the record that was duplicated. We observed that this only happens when the duplication script runs while MS is actively syncing. So, we are wondering if it's possible that MS is somehow able to capture the primary key of the original record just as it is in the process of being duplicated? Is it possible that when FM makes a duplicate record, the record is published to the database first, then the auto enter pk calculation updates the record with the new pk , and in that millisecond window, MS has grabbed the old pk ?
  6. FM17 What's New page says : "Work while reconnecting If you lose your network connection, continue working with files that don’t depend on that host while the connection is being restored." Is this referring to the infamous spinning blue circle in WebDirect ? That thing happens way too often.. I'm also wondering what files you might be working on that "don’t depend on that host" ?
  7. I'm having the same problem now when displaying Google maps in a Web viewer. The WebViewer says that my browser is not supported, but when I click on "Learn More" it shows that I have the latest version of IE (IE 11 on Windows 10) The exact error message is "You are using a browser that is not supported by the Google Maps JavaScript API. Consider changing your browser. I updated to the latest Java, still the same. This google api page shows that IE 11 is supported https://developers.google.com/maps/documentation/javascript/browsersupport I have tried everything here http://answers.microsoft.com/en-us/ie/forum/ie11-windows_7/getting-message-that-ie-browser-is-not-supported/be916dc1-b8a8-4967-a2fe-eab537e47fea?auth=1 No change, and anyway Google Maps works fine in an actual IE 11 window. The Web Viewer seems to actually work fine - just has that annoying message. it's happening in Fm 14 and 15
  8. Thanks Wim. I had no idea that you can use a browser like that to view data and perform actions in a hosted database. But my original question still remains - is there a way to trigger a script automatically when a field value is changed via ODBC ?
  9. I'm creating a simple system to update a remote FM file from an android device, using Cellica Database". http://www.cellica.com/Products.html An ODBC connection has been created, and I can add, modify and delete records in my FM database from my android. I want to trigger a script in FM when a field is modified via the ODBC connection. None of the native FM script triggers work as they are dependent on layouts or user actions. I have tried DoScript, Scriptmaster and EventScript - using field validation. All work OK if I modify the value within FM, but none trigger when the value is modified via ODBC. With EventScript and DoScript, I get a failure message on the device that the record failed validation. With ScriptMaster "CallScriptImmediately", the record updates OK, but the script is not triggered. Any suggestions ?
  10. I have a system for calculating golf handicaps. I noticed that a handicap of 14.5 rounded to 14 instead of 15. A players playing handicap for a round of golf is calculated as Handicap Index / 113 * Course Slope Rating. In this case the Handicap Index is 14.5 and the Slope is 113. The playing handicap is 14.5, which rounds to 15. So I opened a data viewer window and entered Round(14.5, 0). The result is 15, which is correct. Again in the data viewer I entered Round(14.5/113*113) and the result is 14. That seems wrong to me. I entered 14.5 / 113 * 113 on my calculator (an old Casio), and strangely, the answer is 14.4999999. On my phone calculator and in excel, 14.5/113*113 evaluates correctly to 14.5 Round(14.5/113*113) correctly evaluates to 15 in Excel. Am I doing something wrong? (This is in FMPA13)
  11. I have an application that was using IWP under FM Server 12, to allow my friends and friends of friends to upload their golf scores, and my system would calculate their USGA handicaps. After upgrading to FM Server 13, IWP not longer exists, and WebDirect does not support mobile devices. So, I set up an alternative server using FM12. A lot of guys that I don't have contact details for, used that IWP based system to upload golf scores. So I don't have a way to tell them all the new URL. Using the old IWP URL, you are presented with a screen that says "The requested page is not found. Check the URL you are using to access FileMaker WebDirect." I want to edit that page to add some additional information telling them the new URL etc. But I can't find any document with that content in any FM Server folder or sub folder. Anyone know where I can find it ? thanks
  12. OK, I found what i think is the problem, and a partial solution. Problem The problem appears to be the keyboard. On a mobile device, the keyboard pops up when you enter an entry field. When using WebDirect on a mobile, you will notice that when you place the cursor in any field, the keyboard keeps appearing and disappearing, making it almost impossible to enter anything. If you do manage to enter a few characters and get one wrong, you will have as much difficulty trying to erase characters. It happens in any field, not just drop-downs. I assume (but cannot confirm) that a mobile with a fixed keyboard won't have this issue. Partial solution SwiftKey Keyboard app has an option whereby you can dock and undock the keyboard. If you undock the keyboard, the problem mentioned above does not happen. (Well, the keyboard disappears once only, not continuously). When the keyboard is undocked, you can move it around the screen, however, it might cover the part of the screen you are interested in, so you might need to push the screen or keyboard around so you can see what you are entering. In normal mode, the keyboard will never block the field you are entering. Maybe it's this behaviour that's causing difficulty for FM. So, a little inconvenient, but if you need to access a database using Webdirect on an android mobile, it does work. (not yet available for iPhone or Windows phones) Swifkey is available here : https://play.google.com/store/apps/details?id=com.touchtype.swiftkey New note : seems that in Find Mode, you can't enter text at all. You'll have to use a workaround for finds.
  13. Dropdowns in IWP using a mobile device worked fine, but with FM13, IWP is gone. FM says that "FileMaker WebDirect is not currently designed for use on a mobile device." Well, that's a little inconvenient for those of us who own a device which does not support FM Go. I have a system which tracks golf handicaps for my golfing group. The guys enter their scores after playing a round, usually using their phone. Now it doesn't work anymore. I have tried Firefox, Chrome and Dolphin browsers. I tried using popup menu and drop-down list. None work properly on a mobile, all work fine using a desktop browser. Anybody gotten this to work ?
  14. I had this same problem and it had me stumped for a week. Apparently, both the programs for 64 bit and 32 bit ODBC DSN have the SAME NAME ! They are both called odbcad32.exe If you go to Start > Run on Windows 7 64 bit and run odbcad32.exe what you are actually running is the 64 bit version. I had wrongly assumed it was the 32 bit version due to the 32 in the name. So make sure to use the version of odbcad32.exe in c:WindowsSysWOW64
  • Create New...

Important Information

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