Jump to content


  • Content count

  • Joined

  • Last visited

  • Days Won


OlgerDiekstra last won the day on November 21

OlgerDiekstra had the most liked content!

Community Reputation

10 Good

About OlgerDiekstra

  • Rank

Profile Information

  • Title
    FileMaker Developer
  • Gender
  • Location
    Gold Coast, Australia

FileMaker Experience

  • Skill Level
  • FM Application
    16 Advanced

Platform Environment

  • OS Platform
  • OS Version

FileMaker Partner

  • Certification

Recent Profile Visitors

6,709 profile views
  1. Halt Server scheduled script from OnWindowOpen

    What if you 'exit application'? I would expect that to work.
  2. Export FM Data to DXF

    DXF being a text based format (https://en.wikipedia.org/wiki/AutoCAD_DXF), it's trivial to write a DXF file with FileMaker. The challenge will be building the commands for DXF so it comes out as intended. Considering you can already create SVG, and you're looking to convert the SVG into a DXF I'd use a commandline converter (ie, using BaseElements to invoke the commandline converter from FileMaker) such as https://www.coolutils.com/CommandLine/TotalCADConverter. I just googled for it, and have no experience whatsoever with it.
  3. Custom link name separate from URL

    Escape the quotation mark. You can do that with a \. Like this: \"
  4. Custom link name separate from URL

    You can if you use html email formatting. In that case you simply create an anchor tag: <a href="http://test.com/this/can/be/a/very/long/url">Short URL</a> Your customer will need to be able to display html emails though. Most email clients do.
  5. External data sources on FMGO

    I had taken that into account, ensuring the external data source isn't accessed until the global is populated. But I do like that approach of an empty table for opening and closing a database. I should then also be able to close an external data source once I'm on a layout based on an empty table? I've had some trouble closing a data source once opened.
  6. External data sources on FMGO

    MyApp uses a single record table (basically a table for application settings) as the first layout which is local. When MyApp starts, it uses the OnFirstWindowOpen trigger to execute a startup script, which sets the global for the data source. So the external source is not touched until everything is in place. The global is set as one of the first actions in the script, but perhaps I should try pausing for a sec and see if that makes a difference. Will have to wait until I have a couple of iPads again as they've just gone out today. Only have a few older minis that won't upgrade to iOS 10 anymore, and as a result only FMGOv15 installs. :-( I haven't tried setting a static data source, but presumably that works. Will have to test too though.
  7. External data sources on FMGO

    Yep, the file is in the documents folder for sure. The reason I decided to use a dynamic path, is for one because I can, and also to be able to update the file in case I need to. Which goes back to a previous post, about updating an app. I created a MyApp_Launcher.fmp12 which would launch MyApp_v1.0.fmp12. MyApp would then pull its data from MyAppData_v1.0.fmp12. Which means if I wanted to updated either MyApp or MyAppData, I could do that by simply downloading a new version, storing the version number in the launcher and calling a different MyApp file or MyAppData file (the latter's version number would be stored in MyApp). Which means that dynamic external data sources are very handy. However, something is not working as advertised or I'm missing something, or doing something wrong. Thanks for the link to Tony's PDF, found that a while ago too. Very handy.
  8. Hi Folks, I'm having some difficulty getting external data sources to work on FMGO (v16). MyApp consists out of two parts (its basically data separation), one app has the brains and UI, the other only holds the data. In my case the data is just imagery. MyApp is a slide show and a gallery to show customers samples. The iPads that MyApp will run on are used in the field and rarely get back to head office. They will have an internet connection but as images are not often updated, I wanted to separate UI and and data so that if the UI side of it needs an update, it's only an 800KB file, not a 100MB file (400 something images). Images will get updated from time to time, but only some, not usually the whole lot. So I created a main MyApp that has an external data source (using a global variable) and which points to the images file using the fmp protocol. (fmp://~/MyAppData.fmp12). I also tried using file://~/MyAppData.fmp12 but that also didn't work. FMGO complains it can't find the data file. What could I be doing wrong? I have searched but found no info that external data sources are limited on GO or don't work. I use a home screen shortcut using the fmp protocol to launch the MyApp file and that works fine, so the location is correct. Can I not use a dynamic external data source on GO? It works fine on a desktop (Win7) using the documents folder. Thanks!
  9. Updating a FMGO app

    Had a sticky beak at the EasyDeploy solution. I actually worked something similar out over the weekend. I opted for a launcher that is always fired using a shortcut on the home screen, which will check for an update. Currently every time it fires, but I intend to modify that so it only checks every x days. The launcher checks the server, and if there's an update downloads it. Otherwise it fires MyApp and closes. Like the EasyDeploy solution, I make use of External data sources and the fmp url. Haven't figured everything out yet but getting there. The MyApp is only small in size, once complete will only be maybe half a MB so I don't really need the segmented downloading EasyDeploy uses. One of my previous approaches was using an updater file as well, but that failed too. The launcher seems to do the trick though. Thanks for your reply!
  10. Updating a FMGO app

    Hi Guys, Looking for some ideas as I'm running out. I'm developing an offline iOS app (lets name it MyApp.fmp12) that needs to be updated from time to time. On the homescreen I have a shortcut that invokes MyApp.fmp12 using a fmp url. Currently it works as follows: At startup check the HO Master_MyApp.fmp12 to see if there's an update. This is done using an external data source and checking a script. When an update is available, a copy of MyApp.fmp12 on the iOS device is made called Prev_MyApp.fmp12 and an "open url" script step invokes a script in the Prev_MyApp.fmp12 to proceed the upgrade using "fmp:/~/Prev_MyApp.fmp12?script=update&$UPDATE=Download" In the startup script I detect the "Prev_" in the filename and break off processing the startup script (the startup script is called after my invoked script in the script stack and I lose the parameter, by terminating the startup script I land back in the script I want, convoluted but works. I need a startup script.) The update script then closes the MyApp.fmp12 as it needs to be replaced with a new copy using another fmp url calling a "close database" script in MyApp.fmp12. The idea is to download a new copy from the server out of a container field. That part works just fine. The problem enters when I close MyApp.fmp12 as that also closes the script stack and therefore all my scripts terminate. I can't update MyApp.fmp12 until it's closed. If I close MyApp I loose the stack and everything stops. What I need is a way to launch Prev_MyApp.fmp12 when MyApp.fmp12 exits. Anyone know of a way? The app will run on remote iPads, I can''t expect staff to do manual updates, as they are likely to break it. So I'm trying to automate it as much as I can. Let me know if I'm not clear, I've been butting my head all week against this now, trying all sorts of different approaches.
  11. Nice, but what's the benefit of using this over a Code 128 Barcode font? Using a font seems much simpler? I've had good results with fonts such as these: http://www.dafont.com/code-128.font
  12. user interface

    You can't do what you want without a portal. FileMaker doesn't allow you to dynamically add fields to a layout. If you really want to get rid of the portal, then you have to pre-define the filter fields on the layout and conditionally hide them until such time they are needed. Which means you'll be limited in the number of filter fields to whatever amount you set. With a portal you can have 1, 10, 25 or any number. You can create a similar feel in a portal, by putting add buttons on portal rows and making the rows higher than they are now.
  13. Need advice -- one man, one database

    Or, buy a FileMaker Server Development License (US$99), which includes FM Pro, server and webdirect licenses. Then install the server on your Mac, and access the DB via the server from Pro on the Mac and Go on the mobile device. You can still host your FMS anywhere you like, but you'll need to find a provider that either has Mac or Windows servers available. Not too sure if there are any Mac providers out there, as Apple doesn't seem to make server hardware (ie rack mountable), but there are heaps of Windows providers out there. It'll be much more expensive than hosting it at home though.
  14. Filemaker Server 16 and Windows 10

    In my last job we developed for a customer that ran their FMS on a Win7 system. They had constant issues and rebooted the box nearly daily. We kept telling them to move it to a proper server OS. They haven't as yet. You can always buy a Mac mini and run it on that for those few users. Here in Australia they sell for $800 and it's supported by FileMaker. Just make sure you don't skimp on backups as the mini only has a single drive.
  15. A ton of blog posts on FileMaker 16...

    One thing that we haven't heard anywhere and only discovered today, is that FM16 now also displays the sliding panel animation as on Mac and iOS. Especially Windows users are being treated bigtime with the application window gone. Finally.

Important Information

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