The FileMaker Web Viewer as a Javascript Calculation Engine (CSV to JSON example) – SeedCode

GET YOUR THINKING CAP ON before reading this Jason Young’s latest.  Javascript is a robust scripting language with thousands of already written free routines–think of them as custom functions, if you’re having trouble wrapping your head around the concept.  Using the fmp: protocol now available in FileMaker 13v2, developers can harness the power of these free routines and save development time.

Like all good things, though, there is a bit of time involved in getting it set up.  Once done, it will save time–run the scripts in the example file to see how fast it processes 500o records.

There is some overhead in coming up with a framework for loading Javascript libraries into your web viewer, but once you’ve solved that, adding and deploying additional libraries should become as easy as looking up a custom function on the web.

Download the sample file here: FMP2JSON.fmp12

Let’s look at an example where we’ll take some FileMaker data and convert it to a JSON format (in FileMaker) using the Web Viewer and some simple JavaScript…

Be sure to read the comments for some great feedback.

More…The FileMaker Web Viewer as a Javascript Calculation Engine (CSV to JSON example) – SeedCode.

 

Thanks! You've already liked this
Need FileMaker Development Help? Or to purchase FileMaker Software?
Contact FM Pro Gurus for help