ISO FileMaker Magazine: FileMaker Video Tutorials, Templates, Help & More

One of the cool new features for the site is including FileMaker code. Simply wrap the code in blockcode html tags. The code will show up nice and pretty.

 
 
Logicals = If, Case, Choose, IsEmpty, IsValid, IsValidExpression, Let, Evaluate
Variables = $var or $$global_var
Operators = and, or, xor, not
Functions = GetAsText, GetField
Script Steps = Unsort Records, Go to Portal Row
Get Functions = Get(ScriptParameter)
Symbols = ( ) [ ] { } ! ¶ & * /  ≤ ≥ ≠
Comments = //Comment line
Strings = "this is some text"
Numbers = 1024
 
 

 
 
Let( [
$unix = ( GetAsDate(current_timestamp) - Date(1;1;1970) ) * 86400;
$offset = ( Hour( GetAsTimestamp(current_timestamp) ) - time_zone ) * 3600
];
 
$unix + $offset
)
 

The above code is a custom function which will convert a FileMaker date or timestamp value into a unix compatible timestamp.

An example script

 
 
If [ Get( ScriptParameter ) = "download" ]
  Set Field [ Resources | Articles::Resource_Download; Abs( Resources | Articles::Resource_Download - 1) ]
Else If [ Get( ScriptParameter ) = "b"
 
// Body ]
  Set Field [ Resources | Articles::<Field Missing>; Abs( Resources | Articles::<Field Missing> - 1) ]
Else If [ Get( ScriptParameter ) = "free"
 
// Free vs. Paid ]
 
  Set Field [ Resources | Articles::Resource_Free; Abs( Resources | Articles::Resource_Free - 1) ]
Else If [ Get( ScriptParameter ) = "time" ]
  Set Field [ Resources | Articles::Resource_AddToTotal; Abs( Resources | Articles::Resource_AddToTotal - 1) ]
End If
 
 

Love the new site!

Congraturations! It's totally changed! I found a lots of new features but couldn't notice this code comment feature! It's fun.

Matt,

I had to drop you a quick comment and wish you congratulations from everyone at FMPug Headquarters.

We know what it is like to get "Smacked in the face" by web design and implimentation. Your site is beautiful (but then we would not expect any less from you) and extrmely functional and well laid out. And your FileMaker code view is fantastic.

The only thing missing is the link to FMPug at the top (oh, and the Function poster!)

All the best

Andy Gaunt & the FMPug Team

I have started to email them daily. I cannot find any other way to put on pressure. Has anyone got a suggestion? Is there a way to online petition them to support 8.5?

Geraldo