djlane

Members
  • Content count

    165
  • Joined

  • Last visited

Community Reputation

0 Neutral

About djlane

  • Rank
    member
  • Birthday

Profile Information

  • Gender
    Male

FIleMaker Profile

  • FM Application
    14 Advanced
  • Platform
    Windows 2003
  • Skill Level
    Intermediate
  • Membership
    TechNet
  1. 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
  2. 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 ?
  3. 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 ?
  4. 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)
  5. 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
  6. 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.
  7. 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 ?
  8. 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
  9. 12 GB RAM ? OK, this is the point that I'm making Steven. FM says 8 GB is "recommended", and yet you say 12 GB is "a good starting point". So really what should be on the FM website as recommended for Windows 2008 server is "12+ GB".
  10. Great, thanks Wim. They need to put that info on their website as well !
  11. FM have issued a list of minimum and recommended specs for FM12 http://www.filemaker.co.uk/products/filemaker-server/server-12-specifications.html They show the recommended RAM and HDD space for each supported Operating System - my question is, does it make a difference which OS we use ? ie does it make any difference if we use Windows 7, or 2003 or 2008 ? Or 32 bit vs 64 bit ? FM just says they are all supported, but does not seem to say if one is better than another. Am I wrong in thinking that a server that is hosting databases that are larger or busier or have more users might run better on one OS vs another ? Or does it really not matter which one you use, as long as you follow the recommended RAM and HDD space for that OS? djlane
  12. Eyeguy, You can use the UniqueValues Custom Function http://www.briandunning.com/cf/596 Use a self join, and make a calculation field, eg. ZipCodeListAll which is List(related::ZipCode). That gives you a field containing a list of all the zip codes. Then create another field UniqueValues(ZipcodeListAll). You could also use a script to set these fields instead of using calculations, which might be a little slow to display.
  13. Your contacts table should have a Unique ID / Primary Key, eg. “pk_Contacts” generated by Filemaker on creation – not by script but on creation. Your Accounts (companies) table should also have a Unique ID, generated in the same way. The Accounts table should also have a field eg. “fk_Contact” which will store the foreign key (pk_Contacts) of the account. This is the field you use for your relationship. On the relationship graph create a new table occurrence and relate CONTACTS::pk_Contact to ACCOUNTS::fk_contact When you create a new contact, use a lookup to the Main Account table (ie not the Table Occurrence in the relationship above) to insert the foreign key into the fk_Contact field. If you place a portal to the Contacts on a layout in your Accounts table, you will see all the contacts for that account.
  14. Well, IE7 was also supposedly required for FM10 - http://www.filemaker.com/downloads/pdf/fm10_instant_web_publish_en.pdf but it seems to work fine with IE6. So this is a heads up for anyone using IWP with FMSA10 – it may not work properly with FMSA11 if your clients are using IE6. Apparently many corporate users still use IE6 – I guess if you are an IT department with thousands of users, you don’t want to have to upgrade their browsers unless you absolutely need to. I was pretty surprised to find out that my client is still using IE6 across the organization of 2,000+ users.