Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

1 Neutral

About typewriter

  • Rank

Profile Information

  • Title
  • Gender
  • Location
    Utrecht, The Netherlands
  • Interests
    content & document management, CRM applications, datawarehousing, SVG and Webtechnology using Javascript and D3.js, Best Practices in data modelling and solution building

Contact Methods

  • Website URL

FileMaker Experience

  • Skill Level
  • FM Application

Platform Environment

  • OS Platform
  • OS Version

FileMaker Partner

  • Certification
  • Membership
    FileMaker TechNet
    FileMaker Business Alliance

Recent Profile Visitors

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

  1. I posted this one earlier on a different part of this forum, but it be more appropriate here. Until recently, I have used jQuery and the jQueryUI slider widget to display a slider in FileMaker Pro (v17-18-19). This works fine but now I also need to have it work on FileMaker Go, so I tried my luck on jQuery Mobile 1.4.5. Not a very modern product (2017) but as long as it does what it promises... The slider Widget of jQuery Mobile is working nicely on FileMaker Pro, but not on FmGo 17, 18 or 19: it doesn't load, keeps displaying a spinning logo. When I publish the HTML page on a website and
  2. I use jQuery and the jQueryUI slider widget to display a slider in FileMaker Pro (v17-17-18-19). Works fine but I also need to have it work on FileMaker Go, so I tried my luck on jQuery Mobile 1.4.5. The slider is working nicely on FileMaker Pro, but on FmGo 17, 18 or 19 it doesn't load, keeps displaying a spinning logo. When I publish the HTML page on a website and open it in Safari Mobile it works fine. Any help appreciated! See the example file: just downlaod it and open it on FMGo. The Webviewer and the HTML are displayed side by side. sliderExample.fmp12
  3. Yeah, I would like Claris to embrace SVG fully and incorporate SVG in their graphics. And integrate the 'button info' dialog with the style palette in a neat and useful way. Someone was asleep there when they introduced the svg-buttons in FM14.
  4. I have a problem with FileMaker Go (iPad, iOS 13.x). The app crashes when I adding an autograph to a container field using Insert from Device. Does anyone have a similar experience? I has worked fine, using older versions of FMGo. How does this function work anyway? Is it kind of interactive webviewer that is called using Javascript to capture the autograph and putting it back as a graphic into the container field? Claris' documentation is non-existing on these kind of topics. NB on other occasions, I noticed that an 'interactive container field' is in fact a webviewer that int
  5. If you need the control over record display like you showed in your example, you could consider using a webviewer in combination with a html table and some css.
  6. If your code worked allright prior to FM16, it may have to do with changes in the Webviewer. I have a similar problem with FMP16: a GoogleMaps display with an SVG custom marker as overlay. Marker and other objects print to PDF, but the map doesn't. In FM15, it works fine. (problem is the same on Windows and Mac).
  7. Well, I repeated my comparison tests many times, with simple queries and queries that require a lot of processing and although I get consistently longer process times, results are not always as bad. Sometimes the difference between a normal run and a 'record in use' run is only 30%, which I do not consider dramatic. Which leaves me wondering how and when Filemaker executes a FQL query on the server. When a record is locked, will it still use the index? And what information is cached?
  8. Did some testing on a table with 100K records, running on a 4core MacMini w/FMS16: depending on the client and network, the speed difference is at least 10fold. I also did some testing in a local file (no network, single user) and in a peer-to-peer setup. When running locally the 'record in use' effect is still there, but only a factor 2. My guess is that Filemaker can't use the index when a record is in use, resulting in a slowdown. In a peer-to-peer setup, the diffrence is much greater, up to 700x!
  9. Well, the point here is this: for Table Occurrences I always make a separate set of 'reference TO's' which are only used for SQL, and 'behind the scenes' tasks like track and trace functions. Once you have these TO's it doesn't make sense to rename them, and you can blindly type their names in SQL code, knowing that they'll be there and represent what they're supposed to represent. For field names it's different, but frankly I don't see the point in changing names later on, especially once you've started scripting. I know that Filemaker is so nice to allow this, but using SQL in a profess
  10. If they only would add SVG support for the 'background graphic' for buttons and other layout objects, that would solve everything. To me it seems that the button palette was developed by a different department than the one that worked on the tool palette! Perhaps they should meet at some time...
  11. indeed these blog entries and manuals are well worth reading. I might add my two cents in that you should consider keeping your FileMaker solution 'SQL clean'. By that I mean three things: 1. use names for tables and fields so that you don't need escape codes. It makes your SQL much nicer to read and maintain. 2. use a separate set of Table Occurrences for your SQL. SQL operates without the Filemaker context, so there there's no need to stick to your schema and you don't need cryptic names in your SQL statements. 3. don't use SQL in field definitions. You will run into reco
  12. Still not decided whether I should use these SVG buttons at all, although I am a strong supporter of SVG in other areas (such as the webviewer). Has anyone found a way to REPLACE an SVG graphic with another one, so that all the buttons with that icon in my solution will change automatically? AFAIK, the SVG is copied to each and every object that uses it and has no 'link' to the repository, does it? So, suppose I have developed a big solution with a particular button appearing at 300+ places and my customer prefers a different graphic, guess what? I'll have to change these 300+ buttons on
  13. Oh well, that's my fault. I hadn't taken the time to update the profile. Thanks for the feedback. I would be pleased to see additional authoring functions in FMPA17. Like the ability to open a particular script like I mentioned in my post. But displaying the ID's of layouts, scripts and fields in listings would also make life a little easier for people who need to take care of other developer's creations. This consumes some screen real estate, but that that is no probem anymore. By the way, the Open Script Workspace... command in combination with copy/paste works pretty well.
  14. Is it possible to use AppleScript to open the Script Workplace, select a particular script and even scroll to a particular line? I looked through several AppleScript sources (there are not so many...) as well as the Dictionary of FIleMaker Pro Advanced 15, but all examples seem to deal with using the database (i.e. finding and manipulating records), not authoring. Why would be handy? I have an authoring database where I can store the scripts and scriptsteps of a solution. These are converted from FIlemaker XML using the MBS plugin, not that complicated. Then it's possible to select t
  15. The exact dialog is a simple progress dialog: Sorting...' with a progress bar and a Cancel button. No information on the table or field, not even the number of records or bytes. Users often click the cancel button and the dialog disappears, but often re-appears a couple of seconds later. Although a MacMini is not the fastest beast on the block, there are only 3 or 4 users at maximum at the same time. Problems seem to be worse when connected through a VPN. The server could be upgraded form an earlier version, I'll check on that. But you have to remove a previous version of FMS first when u
  • Create New...

Important Information

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