Components | All | New | MacOS | Windows | Linux | iOS | ||||
Examples | Mac & Win | Server | Client | Guides | Statistic | FMM | Blog | Deprecated | Old |
MBS FileMaker Plugin Example Databases
ImageGallery
All examples are included with download of MBS FileMaker Plugin.
Overview | |
Tables | 2 |
Relationships | 0 |
Layouts | 2 |
Scripts | 2 |
Value Lists | 0 |
Custom Functions | 2 |
Custom Menus | 0 |
File Options | |
Default custom menu set | [Standard FileMaker Menus] |
When opening file | |
Minimum allowed version | 12.0 |
Login using | Account Name; Account= Admin |
Allow user to save password | Off |
Require iOS passcode | Off |
Switch to layout | Off |
Hide all toolbars | Off |
Script triggers | |
OnFirstWindowOpen | Off |
OnLastWindowClose | Off |
OnWindowOpen | Off |
OnWindowClose | Off |
OnFileAVPlayerChange | Off |
Thumbnail Settings | |
Generate Thumbnails | On; Temporary |
Table Name |
Statistics
| Occurrences in Relationship Graph |
Images |
2 fields defined, 0 record
| Images |
ImageGallery |
5 fields defined, 21 records
| ImageGallery |
Table Name: Images - 2 Fields | ||||||||
Field Name | Type | Options | Comments | On Layouts | In Relationships | In Scripts | In Value Lists | |
Image | Normal, Binary | Auto-Enter:
|
|
|
||||
Filename | Normal, Text | Auto-Enter:
|
|
|
|
Table Name: ImageGallery - 5 Fields | ||||||||
Field Name | Type | Options | Comments | On Layouts | In Relationships | In Scripts | In Value Lists | |
Image1 | Calculated, Binary | Calculation:
|
|
|
|
|||
Image2 | Calculated, Binary | Calculation:
|
|
|
|
|||
Image3 | Calculated, Binary | Calculation:
|
|
|
|
|||
Image4 | Calculated, Binary | Calculation:
|
|
|
|
|||
Image5 | Calculated, Binary | Calculation:
|
|
|
|
Layout Objects: Images
Field Name: Images::Image | |||||
Field Properties | Coordinates | Field Format | Field Behavior | Quick Find | |
|
| Field Format:
| Field Behavior:
| No |
Field Name: Images::Filename | |||||
Field Properties | Coordinates | Field Format | Field Behavior | Quick Find | |
|
| Field Format:
| Field Behavior:
| Yes |
Button Properties | Coordinates | Script/Script Step | ||||
|
| Perform Script [ “Import Image Folder” ] Scripts: |
Layout Objects: ImageGallery
Field Name: ImageGallery::Image1 | |||||
Field Properties | Coordinates | Field Format | Field Behavior | Quick Find | |
|
| Field Format:
| Field Behavior:
| No |
Field Name: ImageGallery::Image2 | |||||
Field Properties | Coordinates | Field Format | Field Behavior | Quick Find | |
|
| Field Format:
| Field Behavior:
| No |
Field Name: ImageGallery::Image3 | |||||
Field Properties | Coordinates | Field Format | Field Behavior | Quick Find | |
|
| Field Format:
| Field Behavior:
| No |
Field Name: ImageGallery::Image4 | |||||
Field Properties | Coordinates | Field Format | Field Behavior | Quick Find | |
|
| Field Format:
| Field Behavior:
| No |
Field Name: ImageGallery::Image5 | |||||
Field Properties | Coordinates | Field Format | Field Behavior | Quick Find | |
|
| Field Format:
| Field Behavior:
| No |
Import Image Folder |
Refresh |
Next Script: [Refresh] |
Script Name | Import Image Folder |
Run script with full access privileges | Off |
Include In Menu | Yes |
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 |
|
Previous Script: [Import Image Folder] |
Script Name | Refresh |
Run script with full access privileges | Off |
Include In Menu | Yes |
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 |
|
Function Name | Parameters | Availability | Definition | In Field Definitions | In Scripts |
GetImage | nRecord;nField;nFieldCount | All accounts | Let ( [ n = (nRecord-1) * nFieldCount + nField-1; sql = MBS( "FM.SQL.Execute"; ""; "SELECT Image FROM Images OFFSET " & n & " ROWS FETCH FIRST 1 ROWS ONLY" ); error1 = MBS("IsError"); count = If(error1 = 0; MBS( "FM.SQL.RowCount"; sql; n; 0 ); ""); error2 = MBS("IsError"); value = If(error1 = 0 and 0 < count; MBS( "FM.SQL.Field"; sql; 0; 0 ); ""); error3 = MBS("IsError"); r = If(error1 = 0; MBS( "FM.SQL.Release"; sql ); "") ] ; If(error3 = 0 and error2 = 0 and error1 = 0; value; "") ) | ||
ImagesCountPerRow | All accounts | Min( 5; Max ( 1; Round ( Get ( WindowWidth ) / 266 ; 0))) |
Menu Sets | Menus | In Scripts | In Layouts | Comments |
[Standard FileMaker Menus] |
|
Download example: ImageGallery
Used functions: