filemakerhacks.com
FM 14: Separation Model Data Mining | FileMakerHacks
https://filemakerhacks.com/2015/07/06/fm-14-separation-model-data-mining
FileMaker tips, techniques and more. FM 14: Separation Model Data Mining. Note: Interface file #1 requires FM 14 or later; interface file #2 works with FM 12 or later. What do you get when you combine the Separation Model FM 14 placeholder text ExecuteSQL a million-record table a variable array Get(CalculationRepetitionNumber) the Mod and Ceiling functions a couple custom functions, with blazingly fast (local, LAN and WAN) performance thrown in for good measure? Picking a date triggers this script….
filemakerhacks.com
Version: FM 14 or later | FileMakerHacks
https://filemakerhacks.com/category/version-fm-14-or-later
FileMaker tips, techniques and more. Category Archives: Version: FM 14 or later. FM 14: Separation Model Data Mining. Note: Interface file #1 requires FM 14 or later; interface file #2 works with FM 12 or later. What do you get when you combine the Separation Model FM 14 placeholder text ExecuteSQL a million-record table a variable array Get(CalculationRepetitionNumber) the Mod and Ceiling functions a couple custom functions, with blazingly fast (local, LAN and WAN) performance thrown in for good measure?
filemakerhacks.com
PDF Thumbnails in FileMaker 14 | FileMakerHacks
https://filemakerhacks.com/2015/05/28/pdf-thumbnails-in-filemaker-14
FileMaker tips, techniques and more. PDF Thumbnails in FileMaker 14. 8220;It is a riddle wrapped in a mystery inside an enigma but perhaps there is a key. The key is how you get the PDF into the container field, and which platform and FM version you use to accomplish this.”. Winston Churchill, BBC radio address, 1939. Just kidding about the second sentence.). Today’s demo file, pdf thumbnails. Before we go any further, let’s introduce a couple of terms:. An image with maximum dimensions specified that th...
filemakerhacks.com
SQL | FileMakerHacks
https://filemakerhacks.com/category/sql
FileMaker tips, techniques and more. Tips ’n’ Tricks, part 1. Over the last few years I’ve been collecting miscellaneous tips and tricks with the thought of eventually aggregating them into a blog posting, and it appears that day has finally come. Ideally there will be something new and useful here for developers of all levels, from the neophyte to the most grizzled of FileMaker veterans. We start off with a couple FM 14-specific tips. Tip #1: Tool tips in layout mode. Continue reading →. Well, that shor...
filemakerhacks.com
Separation Model | FileMakerHacks
https://filemakerhacks.com/tag/separation-model
FileMaker tips, techniques and more. Tag Archives: Separation Model. FM 14: Separation Model Data Mining. Note: Interface file #1 requires FM 14 or later; interface file #2 works with FM 12 or later. What do you get when you combine the Separation Model FM 14 placeholder text ExecuteSQL a million-record table a variable array Get(CalculationRepetitionNumber) the Mod and Ceiling functions a couple custom functions, with blazingly fast (local, LAN and WAN) performance thrown in for good measure? Of this ar...
filemakerhacks.com
Placeholder Text | FileMakerHacks
https://filemakerhacks.com/tag/placeholder-text
FileMaker tips, techniques and more. Tag Archives: Placeholder Text. FM 14: Separation Model Data Mining. Note: Interface file #1 requires FM 14 or later; interface file #2 works with FM 12 or later. What do you get when you combine the Separation Model FM 14 placeholder text ExecuteSQL a million-record table a variable array Get(CalculationRepetitionNumber) the Mod and Ceiling functions a couple custom functions, with blazingly fast (local, LAN and WAN) performance thrown in for good measure? Of this ar...
filemakerhacks.com
Separation Aggregation Aggravation | FileMakerHacks
https://filemakerhacks.com/2011/05/29/sep-agg-agg
FileMaker tips, techniques and more. 7 June 2015: This technique has been substantially revised to work with FileMaker 14; see FM 14: Separation Aggregation Aggravation revisited. Today’s demo file is called aggregates-and-separation. Parent record in the Data file, with a couple newly created portal rows, and the three aggregate calc fields below the portal are tracking the changes in real time. Have it open. To test whether a record is open (a.k.a. locked or in-use) by another user, 1) ...But getting b...
filemakerhacks.com
Get(CalculationRepetitionNumber) | FileMakerHacks
https://filemakerhacks.com/tag/getcalculationrepetitionnumber
FileMaker tips, techniques and more. Virtual List Reporting, part 1. Self-plagiarism alert: to avoid repeatedly referring the reader back to earlier virtual list articles, portions of text from those earlier articles are incorporated here. Welcome to the first installment of a two-part series on producing reports using the virtual list technique, or more properly, collection of techniques. Demo file: VLR-part-1.zip. Invented and popularized by Bruce Robertson. This entry was posted in Level: Advanced.
filemakerhacks.com
ExecuteSQL | FileMakerHacks
https://filemakerhacks.com/tag/executesql
FileMaker tips, techniques and more. If you do complex data analysis, then from time to time you probably need to group, summarize, and parse data into variables and/or fields. There are various ways to accomplish this, including the Fast Summary. Technique, which regular readers of this blog may be familiar with, as it has made a number of appearances. Here over the years. This entry was posted in ExecuteSQL. Version: FM 13 or later. Perform Script on Server. March 30, 2016. What do you get when you com...
filemakerhacks.com
Level: Intermediate | FileMakerHacks
https://filemakerhacks.com/category/level-intermediate
FileMaker tips, techniques and more. Category Archives: Level: Intermediate. Portal Threading in FM 15. Demo file: fm15-portal-threading.zip. Continue reading →. This entry was posted in Level: Intermediate. Version: FM 15 or later. And tagged portal progress indicators. May 10, 2016. Set Variable by Name. This issue has come up from time to time on this blog over the last five years or so, most notably in Dynamic Variable Instantiation. Where I observed that…. This entry was posted in Level: Advanced.