MBS FileMaker Plugin Example Databases

Signature Appearance

All examples are included with download of MBS FileMaker Plugin.

Signature Appearance.fmp12

Overview
Tables1
Relationships0
Layouts1
Scripts2
Value Lists0
Custom Functions0
Custom Menus0
File Options
Default custom menu set[Standard FileMaker Menus]
When opening file
Minimum allowed version12.0
Login usingAccount Name; Account= Admin
Allow user to save passwordOff
Require iOS passcodeOff
Switch to layoutOff
Hide all toolbarsOff
Script triggers
OnFirstWindowOpenOff
OnLastWindowCloseOff
OnWindowOpenOff
OnWindowCloseOff
OnFileAVPlayerChangeOff
Thumbnail Settings
Generate ThumbnailsOn; Temporary

 

Tables

Table Name
Statistics
Occurrences in Relationship Graph
Signature Appearance
2 fields defined, 1 record
Signature Appearance

Fields

Table Name: Signature Appearance - 2 Fields
Field NameTypeOptionsCommentsOn LayoutsIn RelationshipsIn ScriptsIn Value Lists
PDFNormal, BinaryAuto-Enter:
  • Allow editing
Validation:
  • Only during data entry
Storage:
  • Repetitions: 1
      CertificateNormal, BinaryAuto-Enter:
      • Allow editing
      Validation:
      • Only during data entry
      Storage:
      • Repetitions: 1

          Layout Objects: Signature Appearance

          Regular Fields

          Field Name: Signature Appearance::PDF
          Field PropertiesCoordinatesField FormatField BehaviorQuick Find
          • Top: 52 pt
          • Left: 138 pt
          • Bottom: 521 pt
          • Right: 616 pt
          • Anchoring: Left, Top
          Field Format:
          • Edit Box
          Field Behavior:
          • Allow field to be entered: In Find mode, In Browse mode
          • Touch keyboard type: Default for Data Type
          • Go to next field using: Tab key
          No

          Field Name: Signature Appearance::Certificate
          Field PropertiesCoordinatesField FormatField BehaviorQuick Find
          • Top: 396 pt
          • Left: 754 pt
          • Bottom: 521 pt
          • Right: 1007 pt
          • Anchoring: Left, Top
          Field Format:
          • Edit Box
          Field Behavior:
          • Allow field to be entered: In Find mode, In Browse mode
          • Touch keyboard type: Default for Data Type
          • Go to next field using: Tab key
          No

          Buttons

          Button PropertiesCoordinatesScript/Script Step
            Type:
          • Text: Create Signed PDF
          • Top: 57 pt
          • Left: 643 pt
          • Bottom: 85 pt
          • Right: 847 pt
          • Anchoring: Left, Top
          Perform Script [ “Create PDF” ]

          Scripts:


          Script Hierarchy

          Create PDF
          InitDynaPDF

          Next Script: [InitDynaPDF]
          Script NameCreate PDF
          Run script with full access privilegesOff
          Include In MenuNo
          Layouts that use this script
          Scripts that use this script
            Script Definition
            Script Steps
            • #Initialize DynaPDF if needed
            • If [ MBS("DynaPDF.IsInitialized") ≠ 1 ]
            • Perform Script [ “InitDynaPDF” ]
            • End If
            • #New PDF document
            • Set Variable [ $pdf; Value:MBS("DynaPDF.New") ]
            • #Some Metadata
            • Set Variable [ $r; Value:MBS("DynaPDF.SetDocInfo"; $pdf; "Creator"; "My FileMaker Script") ]
            • Set Variable [ $r; Value:MBS("DynaPDF.SetDocInfo"; $pdf; "Author"; Get(UserName)) ]
            • Set Variable [ $r; Value:MBS("DynaPDF.SetDocInfo"; $pdf; "Title"; "Custom digital signature appearance") ]
            • Set Variable [ $r; Value:MBS("DynaPDF.SetCompressionLevel"; $pdf; "none") ]
            • #Add a page
            • Set Variable [ $r; Value:MBS("DynaPDF.AppendPage"; $pdf) ]
            • #write something on page
            • Set Variable [ $r; Value:MBS("DynaPDF.SetFont"; $pdf; "Arial"; 0; 14) ]
            • Set Variable [ $r; Value:MBS("DynaPDF.WriteFText"; $pdf; "left"; "This file is digitally signed with a self sign certificate. The appearance of the signature field is created with normal DynaPDF functions. However, it would also be possible to import a PDF page, an EMF file, or an image into the appearance template.¶¶When creating an individual signature appearance make sure to place the validation icon properly with PlaceSigFieldValidateIcon(). The appearance of the validation icon depends on the Acrobat version with which the file is opened. However, the unscaled size of that icon is always 100.0 x 100.0 Units. It can be scaled to every size you want but it is usually best to preserve the aspect ratio and the icon must be placed fully inside the appearance template.") ]
            • #add signature field
            • Set Variable [ $sigField; Value:MBS( "DynaPDF.CreateSigField"; $pdf; "Signature"; -1; 200; 500; 200; 80) ]
            • Set Variable [ $r; Value:MBS( "DynaPDF.SetFieldColor"; $PDF; $sigField; "BorderColor"; "DeviceRGB"; 4294967281) ]
            • Set Variable [ $r; Value:MBS( "DynaPDF.PlaceSigFieldValidateIcon"; $PDF; $sigField; 0; 15; 50; 50) ]
            • Set Variable [ $r; Value:MBS( "DynaPDF.CreateSigFieldAP"; $PDF; $sigField) ]
            • Set Variable [ $r; Value:MBS( "DynaPDF.SaveGraphicState"; $PDF) ]
            • Set Variable [ $r; Value:MBS( "DynaPDF.Rectangle"; $PDF; 0; 0; 200; 80; "NoFill") ]
            • Set Variable [ $r; Value:MBS( "DynaPDF.ClipPath"; $PDF; "Winding"; "NoFill") ]
            • Set Variable [ $sh; Value:MBS( "DynaPDF.CreateAxialShading"; $PDF; 0; 0; 200; 0; ,5; MBS("DynaPDF.RGB"; 255; 255; 255) /* white */; MBS("DynaPDF.RGB"; 120; 120; 220); 1; 1) ]
            • Set Variable [ $r; Value:MBS( "DynaPDF.ApplyShading"; $PDF; $sh) ]
            • Set Variable [ $r; Value:MBS( "DynaPDF.RestoreGraphicState"; $PDF) ]
            • Set Variable [ $r; Value:MBS( "DynaPDF.SaveGraphicState"; $PDF) ]
            • Set Variable [ $r; Value:MBS( "DynaPDF.Ellipse"; $PDF; 50,5; 1; 148,5; 78; "NoFill") ]
            • Set Variable [ $r; Value:MBS( "DynaPDF.ClipPath"; $PDF; "Winding"; "NoFill") ]
            • Set Variable [ $sh; Value:MBS( "DynaPDF.CreateAxialShading"; $PDF; 0; 0; 200; 0; ,5; MBS("DynaPDF.RGB"; 120; 120; 220); MBS("DynaPDF.RGB"; 255; 255; 255) /* white */; 1; 1) ]
            • Set Variable [ $r; Value:MBS( "DynaPDF.ApplyShading"; $PDF; $sh) ]
            • Set Variable [ $r; Value:MBS( "DynaPDF.RestoreGraphicState"; $PDF) ]
            • Set Variable [ $r; Value:MBS("DynaPDF.SetFont"; $pdf; "Arial"; 2+4 /* bold + underline */; 11) ]
            • Set Variable [ $r; Value:MBS("DynaPDF.SetFillColor"; $pdf; MBS("DynaPDF.RGB"; 120; 120; 220)) ]
            • Set Variable [ $r; Value:MBS("DynaPDF.WriteFTextEx"; $pdf; 50; 60; 150; -1; "Center"; "Digitally signed by:") ]
            • Set Variable [ $r; Value:MBS("DynaPDF.SetFont"; $pdf; "Arial"; 2+1 /* bold + italic */; 18) ]
            • Set Variable [ $r; Value:MBS("DynaPDF.SetFillColor"; $pdf; MBS("DynaPDF.RGB"; 100; 100; 200)) ]
            • Set Variable [ $r; Value:MBS("DynaPDF.WriteFTextEx"; $pdf; 50; 45; 150; -1; "Center"; Get(UserName)) ]
            • Set Variable [ $r; Value:MBS( "DynaPDF.EndTemplate"; $PDF) ]
            • #end page
            • Set Variable [ $r; Value:MBS("DynaPDF.EndPage"; $pdf) ]
            • #Write certificate to temp file
            • Set Variable [ $path; Value:MBS( "Path.AddPathComponent"; MBS( "Folders.UserTemporary" ); "test.pfx") ]
            • Set Variable [ $r; Value:MBS( "Container.WriteFile"; Signature Appearance::Certificate; $path ) ]
            • #Save PDF
            • Set Variable [ $r; Value:MBS( "DynaPDF.SaveAndSignFile"; $pdf; $path; "123456"; "test"; ""; "test.pdf") ]
            • #Put in Container
            • Set Field [ Signature Appearance::PDF; $r ]
            • #Cleanup
            • Set Variable [ $r; Value:MBS("DynaPDF.Release"; $pdf) ]
            Fields used in this script
            Scripts used in this script
            Layouts used in this script
              Tables used in this script
              Table occurrences used by this script
              Custom Functions used by this script
                Custom menu set used by this script

                  Previous Script: [Create PDF]
                  Script NameInitDynaPDF
                  Run script with full access privilegesOff
                  Include In MenuNo
                  Layouts that use this script
                    Scripts that use this script
                    Script Definition
                    Script Steps
                    • #Locate DynaPDF library
                    • #you can have libraries in container and export at runtime to folder of your choice.
                    • #Or install library somewhere and pass path.
                    • #If library is in same folder as plugin, you can only pass only file name.
                    • If [ MBS("IsServer") ]
                    • #Put the path you use for your server here:
                    • If [ Get(SystemPlatform) = -2 ]
                    • #Server on Windows
                    • Set Variable [ $path; Value:"C:\Programs\FileMaker Server\dynapdf64.dll" ]
                    • Else If [ MBS("IsLinux") ]
                    • #Server on Linux for FileMaker Cloud
                    • Set Variable [ $path; Value:"/opt/FileMaker/FileMaker Server/dynapdf.linux.so" ]
                    • Else
                    • #Server on Mac
                    • Set Variable [ $path; Value: "/Library/FileMaker Server/dynapdf.dylib" ]
                    • End If
                    • Else
                    • #For desktop and our examples we look in same folder as database:
                    • Set Variable [ $databasePath; Value:Get(FilePath) ]
                    • Set Variable [ $databasePath; Value:MBS("Path.FilemakerPathToNativePath"; $databasePath) ]
                    • Set Variable [ $databasePath; Value:Substitute ( $databasePath ; ".fp7" ; ".fmp12") ]
                    • Set Variable [ $databaseName; Value:Get(FileName) & ".fmp12" ]
                    • If [ Get(SystemPlatform) = -2 ]
                    • Set Variable [ $path; Value:Substitute ( $databasePath ; $databaseName ; "dynapdf.dll" ) ]
                    • #plugin will look for dynapdf.dll and if not found also for dynapdf64.dll (64-bit) and dynapdf32.dll (32-bit).
                    • Else
                    • Set Variable [ $path; Value:Substitute ( $databasePath ; $databaseName ; "dynapdf.dylib" ) ]
                    • #Mac dylib is usually 32 and 64 bit together.
                    • End If
                    • End If
                    • #You can test for free.
                    • #If you like to get a dynapdf license, please follow links on our pricing page:
                    • #https://www.monkeybreadsoftware.de/filemaker/pricing.shtml
                    • Set Variable [ $LicenseKey; Value:"" // put your key here or leave empty for demo. ]
                    • Set Variable [ $r; Value:MBS( "DynaPDF.Initialize"; $path; $LicenseKey) ]
                    • If [ $r ≠ "OK" ]
                    • Show Custom Dialog [ Title: "Error"; Message: $r; Default Button: “OK”, Commit: “No”; Button 2: “Cancel”, Commit: “No” ]
                    • Halt Script
                    • End If
                    Fields used in this script
                      Scripts used in this script
                        Layouts used in this script
                          Tables used in this script
                            Table occurrences used by this script
                              Custom Functions used by this script
                                Custom menu set used by this script

                                  Download example: Signature Appearance

                                  Used functions:




                                  Links
                                  MBS FileMaker tutorial videos