Filemaker_functions

Useful custom functions for Filemaker

Functions to script control

# example_sript
If [ function("main") ]
  Show Custom Dialog [ "main branch" ]
  Perform Script [ "example_sript"; Parameter: setParams("a&b"; param("a"; 1; type.number) & param("b"; "cat"; type.string))]
Else If [ function("a&b") ]
  Show Custom Dialog [ getParam("a") & ", " & getParam("b") ]
  # output "1, cat"
End If

Pure function examples

map_eval

map_eval(range(1;3);"e";"e*e") // "1¶4¶9"
map_eval("a¶b¶c";"e";"Char(Code(e)+10)") // "k¶l¶m"

reduce_eval

reduce_eval(range(1;100);"a";"e";"a+e";0) // 5050 (sum)
reduce_eval(range(1;6);"a";"e";"a*e";1) // 720 (factorial)
reduce_eval(range(1;10);"a";"e";"a & \"@\"";"") // "@@@@@@@@@@"

filter_eval

filter_eval(range(-3;3);"e";"not(e<0)") // "0¶1¶2¶3"
filter_eval(range(1;10);"e";"Mod(e;2)=0") // "2¶4¶6¶8¶10"

sort_eval

sort_eval("6¶3¶7¶1";"a";"b";"GetAsNumber(a) < GetAsNumber(b)") // "1¶3¶6¶7"
sort_eval(split("test");"a";"b";"a < b") // "e¶s¶t¶t"

split

split("abcde") // "a¶b¶c¶d¶e"

while_eval

Let(
  [
    $a=1;
    $i=0;
    w=while_eval("$i<10";
      "Let([$a=$a*2;$i=$i+1];True)"
    )
  ];
  $a
) // 1024

map

map("a¶b¶c";"Upper") // "A¶B¶C"
map("-1¶2¶-3";"Abs") // "1¶2¶3"

range

range(1;3) // "1¶2¶3"
range(2;-2) // "2¶1¶0¶-1¶-2"

array_include

array_include("a¶b¶c";"a") // True
array_include("a¶b¶c";"d") // False

Other

H

Set Variable [ $var[H("value 1")] ; 1]
Set Variable [ $var[H("value 2")] ; 2]

Show Custom Dialog [ $var[H("value 1")] + $var[H("value 2")] ]

Quine on Filemaker language

Let([q=Char(34);s="Let([q=Char(34);s=];Left(s;18) & q & s & q & Right(s;Length(s)-18))"];Left(s;18) & q & s & q & Right(s;Length(s)-18))