Components All New MacOS Windows Linux iOS
Examples Mac & Win Server Client Guides Statistic FMM Blog Deprecated Old

MBS FileMaker Plugin Example Databases

Signature Appearance

All examples are included with download of MBS FileMaker Plugin.

Signature Appearance.fmp12

Overview
Tables1
Relationships0
Layouts1
Scripts3
Value Lists0
Custom Functions0
Custom Menus24
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 and Right, Top and Bottom
          		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
          Create Custom Annotation

          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.SetFillColorValue"; $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.SetFillColorValue"; $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") ]
            • If [ MBS("IsError") ]
            • Show Custom Dialog [ Title: "Failed to sign PDF."; Message: $r; Default Button: “OK”, Commit: “Yes” ]
            • Else
            • #Put in Container
            • Set Field [ Signature Appearance::PDF; $r ]
            • End If
            • #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]Next Script: [Create Custom Annotation]
                  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\dynapdf.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 dynapdf.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. // Use e.g. "Lite", "Pro" or "Starter" to use demo mode for just that mode. ]
                    • 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

                                  Previous Script: [InitDynaPDF]
                                  Script NameCreate Custom Annotation
                                  Run script with full access privilegesOff
                                  Include In MenuNo
                                  Layouts that use this script
                                    Scripts that use this script
                                      Script Definition
                                      Script Steps
                                      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: