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

MBS FileMaker Plugin Example Databases

JSON to HTML

All examples are included with download of MBS FileMaker Plugin.

JSON to HTML.fmp12

Overview
Tables1
Relationships0
Layouts1
Scripts4
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
JSON to HTML
4 fields defined, 2 records
JSON to HTML

Fields

Table Name: JSON to HTML - 4 Fields
Field NameTypeOptionsCommentsOn LayoutsIn RelationshipsIn ScriptsIn Value Lists
JSON InputNormal, TextAuto-Enter: Validation:
  • Only during data entry
Storage:
  • Repetitions: 1
  • Indexing: None
  • Automatically create indexes as needed
  • Index Language: German
      JSON OutputNormal, TextAuto-Enter: Validation:
      • Only during data entry
      Storage:
      • Repetitions: 1
      • Indexing: None
      • Automatically create indexes as needed
      • Index Language: German
          CSSNormal, TextAuto-Enter:
          • Allow editing
          Validation:
          • Only during data entry
          Storage:
          • Global
          • Repetitions: 1
          • Index Language: German
                Dark ModeNormal, NumberAuto-Enter:
                • Allow editing
                Validation:
                • Only during data entry
                Storage:
                • Repetitions: 1
                • Indexing: None
                • Automatically create indexes as needed
                • Index Language: German

                    Layout Objects: JSON to HTML

                    Regular Fields

                    Field Name: JSON to HTML::JSON Input
                    Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                    • Top: 52 pt
                    • Left: 138 pt
                    • Bottom: 330 pt
                    • Right: 510 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
                    Yes
                    Conditional FormattingConditionFormat
                    1.

                      self:normal .self
                      {
                      background-color: rgba(0%,0%,0%,1);
                      }
                      self:normal .icon
                      {
                      -fm-icon-color: rgba(0%,0%,0%,0);
                      }

                    Field Name: JSON to HTML::JSON Output
                    Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                    • Top: 336 pt
                    • Left: 138 pt
                    • Bottom: 501 pt
                    • Right: 510 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
                    Yes
                    Conditional FormattingConditionFormat
                    1.

                      self:normal .self
                      {
                      background-color: rgba(0%,0%,0%,1);
                      }
                      self:normal .icon
                      {
                      -fm-icon-color: rgba(0%,0%,0%,0);
                      }

                    Field Name: JSON to HTML::CSS
                    Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                    • Top: 36 pt
                    • Left: 135 pt
                    • Bottom: 465 pt
                    • Right: 511 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: Update
                    • Top: 277 pt
                    • Left: 17 pt
                    • Bottom: 312 pt
                    • Right: 106 pt
                    • Anchoring: Left, Top
                    Set Field [ JSON to HTML::JSON Input; JSON to HTML::JSON Input ]

                    Fields:


                    Popover Buttons

                    Popover Button PropertiesCoordinates
                      Type:
                    • Text: CSS
                    • Top: 231 pt
                    • Left: 17 pt
                    • Bottom: 266 pt
                    • Right: 106 pt
                    • Anchoring: Left, Top
                    Popover PropertiesCoordinates
                      Show Title Bar:
                    • Yes
                      Title:
                    • "Popover"
                      Position:
                    • Right
                    • Top: 18 pt
                    • Left: 117 pt
                    • Bottom: 480 pt
                    • Right: 526 pt
                    • Anchoring: Left, Top
                    Popover Content
                    Tab ControlsSlide ControlsFieldsButtonsPortalsWeb Viewer ControlsCharts
                        Field Objects

                        Web Viewer Controls

                        Web Viewer Control PropertiesCoordinatesWeb Address
                          Additional Properties:
                        • Allow interaction with web viewer content
                        • Display progress bar
                        • Display status messages
                        • Automatically encode URL
                        • Top: 52 pt
                        • Left: 519 pt
                        • Bottom: 501 pt
                        • Right: 1010 pt
                        • Anchoring: Left and Right, Top and Bottom
                        "data:text/html;charset=utf-8;base64," & Base64Encode ( JSON to HTML::JSON Output )

                        Script Hierarchy

                        Colorize JSON
                        Colorize JSON dark mode
                        Clear
                        Update

                        Next Script: [Colorize JSON dark mode]
                        Script NameColorize JSON
                        Run script with full access privilegesOff
                        Siri Shortcut VisibleOff
                        Include In MenuYes
                        Layouts that use this script
                          Scripts that use this script
                            Script Definition
                            Script Steps
                            • Set Field [ JSON to HTML::Dark Mode; 0 ]
                            • Set Field [ JSON to HTML::JSON Input; MBS("JSON.Colorize"; JSON to HTML::JSON Input) ]
                            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: [Colorize JSON]Next Script: [Clear]
                                    Script NameColorize JSON dark mode
                                    Run script with full access privilegesOff
                                    Siri Shortcut VisibleOff
                                    Include In MenuYes
                                    Layouts that use this script
                                      Scripts that use this script
                                        Script Definition
                                        Script Steps
                                        • Set Field [ JSON to HTML::Dark Mode; 1 ]
                                        • Set Field [ JSON to HTML::JSON Input; MBS("JSON.Colorize"; JSON to HTML::JSON Input; JSON to HTML::Dark Mode) ]
                                        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: [Colorize JSON dark mode]Next Script: [Update]
                                                Script NameClear
                                                Run script with full access privilegesOff
                                                Siri Shortcut VisibleOff
                                                Include In MenuYes
                                                Layouts that use this script
                                                  Scripts that use this script
                                                    Script Definition
                                                    Script Steps
                                                    • Replace Field Contents [ JSON to HTML::JSON Output; Replace with calculation: "" ] [ No dialog ]
                                                    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: [Clear]
                                                            Script NameUpdate
                                                            Run script with full access privilegesOff
                                                            Siri Shortcut VisibleOff
                                                            Include In MenuYes
                                                            Layouts that use this script
                                                              Scripts that use this script
                                                                Script Definition
                                                                Script Steps
                                                                • Set Error Capture [ On ]
                                                                • #we just set field to itself to trigger calculation
                                                                • Set Field [ JSON to HTML::JSON Input; JSON to HTML::JSON Input ]
                                                                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: JSON to HTML

                                                                        Used functions: