Comments for filemakerhacks

Comment on Outer Joins in FileMaker 12, part 1 by Dickie Chung

Dickie Chung — Sun, 19 May 2013 13:22:04 +0000

They work great, simple and elegant. Thank you.

Comment on Outer Joins in FileMaker 12, part 1 by Kevin Frank

Kevin Frank — Sat, 18 May 2013 16:46:19 +0000

You're absolutely right. Here are two replacements for demo 3b: Demo 3c and Demo 3d. The former adds a little "wakeup" tickle to the total calcs; the latter does the same but replaces individual fields with repeaters where possible.

Comment on Outer Joins in FileMaker 12, part 1 by Dickie Chung

Dickie Chung — Sat, 18 May 2013 11:48:45 +0000

Hi Kevin,

Thank you for sparing the time to answer my question and create the demo 3a and 3b. Demo 3a uses built-in relationships to do the calculation of totals. It works perfectly.

There is a problem with Demo 3b. The formulae of the calculation fields and summary fields would not get evaluated when the -7, -1, T, +1, +7 buttons are clicked. Thus the totals displayed at the bottom remain unchanged, unless the user switches to Sales Data tab and click back to Week View tab. (Switch to Employee tab will not get the totals updated. Both tab “Show records from employees” table occurrence.)

The problems with Demo 3b were exactly what I encountered before I post my question. Is there anyway to force the calculation fields and summary fields of a table to be evaluated by script steps? It seems to me that Go to Layout and then back to original layout, or Refresh Window would not do the trick. Do I miss anything?

Comment on Outer Joins in FileMaker 12, part 1 by Kevin Frank

Kevin Frank — Fri, 17 May 2013 05:56:03 +0000

I created a couple variants on demo 3 for you. If you always want to see totals for all employees (in other words, daily summaries), then demo 3a will do what you want. If on the other hand you'd want the summaries to reflect the current found set of employees, then check out ~~demo 3b~~ [superceded by demos 3c and 3d below].

Comment on Outer Joins in FileMaker 12, part 1 by Dickie Chung

Dickie Chung — Wed, 15 May 2013 01:08:24 +0000

Is there a easy way to add a total amount of sale by all employees on each day at the bottom of the report using the traditional relational filter method?

Comment on A Simple Backup Script, revisited by Jeremy

Jeremy — Fri, 03 May 2013 15:00:55 +0000

I’m getting ready to wrap-up a version of this solution for ModularFileMaker.org, but I’d like to know if you have any thoughts on my implementation before I post it. https://github.com/jbante/FM-LocalBackup

Comment on Long Documents in FileMaker 11 by Michael van Drempt

Michael van Drempt — Fri, 03 May 2013 03:05:40 +0000

You know I just had the exact same thought? It’s actually quite simple to add a space, since I’ve already got a calculation field that’s designed specifically for this usage, so I’m not worried about breaking other systems. I’ve changed the paragraph calc to:

Let ( [
a = GetValue ( $$virtualList ; Extend ( serialNumber ) ) ;
b = GetAsCSS ( a ) ;
c = Get ( CalculationRepetitionNumber )
] ;

Case (
c = 1 and IsEmpty ( a ) ; ” ” ;
c = 1 and PatternCount ( b ; “text-align: ” ) = 0 ; a ;
c = 2 and PatternCount ( b ; “text-align: center” ) > 0 ; a ;
c = 3 and PatternCount ( b ; “text-align: right” ) > 0 ; a ;
c = 4 and PatternCount ( b ; “text-align: full” ) > 0 ; a ;
“”
)

) // end let

So any empty lines are represented as spaces, and the spacing looks exactly right, regardless of the number of empty lines! Looks like this is going into the production version.

Here’s my fixed example:

https://dl.dropboxusercontent.com/u/77795925/FMP/Long%20Documents%20in%20FM%2012%20From%20Scratch%20-%20Line%20Spacing%20Fixed.fmp12

Comment on Long Documents in FileMaker 11 by Kevin Frank

Kevin Frank — Fri, 03 May 2013 02:50:29 +0000

Hi Michael,

a) You’re welcome.

b) If your supposedly-empty row actually contained a single space, it would still appear to be an empty row but perhaps you’d have better results. I’m not suggesting polluting your original document, but when the “preview document” script runs, perhaps a bit of creative substitution would be in order? And in that case you might want to restore the objects on the layout back to their original heights.

Regards,
Kevin

Comment on Long Documents in FileMaker 11 by Michael van Drempt

Michael van Drempt — Fri, 03 May 2013 02:35:51 +0000

Ah, okay, I see now. You did put that in the post, I just can’t read. Unfortunately it seems that using this technique the spacing only looks correct if you have a single empty line in between paragraphs. Any more or less and the spacing looks wrong. I guess there’s only so much that can be done to replicate the exact formatting using a workaround like this. Thanks for your help!

Comment on ExecuteSQL: Using IN with Faux Dynamic Variables by Larry Schunk

Larry Schunk — Thu, 02 May 2013 18:58:10 +0000

Here is what worked thanks to Jason Young:

Let ( [
$name = Get ( AccountName );
$myquery = "SELECT FullName FROM a_plants_A_EMPLOYEES Where UPPER ( FullName ) = ? " ;
$myresult = ExecuteSQL ( $myquery ; "" ; "" ; UPPER ($name) )
];
$myresult
)