DIGFM: Fun FileMaker Facts, featuring fundamental functionality (4/9/2020; Online Only)

0:00:03

Introductions

0:03:00

What is a Fun FileMaker Fact?

0:06:40

Colorful Relationship Graph

0:08:53

Code readability for the Perform Find script step

0:10:13

Text formatting functions - underutilized aspect of the FileMaker platform

0:16:12

Keyboard shortcuts - utility by Matt Petrowsky @ https://www.filemakermagazine.com/resources

0:18:47

Custom functions vs. script functions

0:25:36

Show Custom Dialog script step

0:28:37

Constrain Found Set, Extend Found Set, and more! - wrong use of "diacritical"

0:32:55

Preferences, User Name, Assisted Install, Accounts Table, and more

0:38:38

Zebra Stripes

00:42:34

Layout Object Names - correction: Function is GetLayoutObjectAttribute

0:46:53

FileMaker REST'ful integrations are awesome

0:48:23

Custom data formatting of type date + pad the date in lists and portals

0:49:54

Layouts sit "on top of" Table Occurrences, which sit on top of Source Tables...

0:51:43

Script Folders (use a good naming convention) [with real time correction]

0:55:05

Click a button with the keyboard - https://www.teamdf.com/blogs/modal-magic/

0:56:40

Snapshot Links (compare with using FMP URL)

1:05:13

Auto-Enter Trigger fields - granular modification functionality

1:09:11

Script Call Stack - possible today - easier in the future? Vote Product Idea

1:13:37

Field naming convention

1:17:50

Liquid Layouts

1:23:20

{{Layouts Symbols}}

1:25:29

Cleaning Crufty Object Names

1:27:32

FMP URL Protocol

1:29:08

Conditional formatting

1:30:40

Future Fun FileMaker Facts (might split these our later)

1:31:28

Evaluate function to "future proof" code

1:32:28

FileMaker database, to track Functions, Script Steps, etc.

1:34:01

Un-stored (corrected) Fields do not load until they are "shown"...

1:34:49

Records have an underlying RecordID that can be exposed using calc fields

1:35:38

Sorting portals https://scalefm.com/2018/12/tasty-sort-reverse-natural-order/

1:36:32

"Counting" Related Records

1:39:03

Layout Badges

1:41:42

Buttons showed up in FM 12. Before that we had grouped objects...

1:42:28

Monkeybread LayoutID + AppleScript to Go to LayoutID

1:45:00

Fewer comments!

1:46:20

SVG icons [Glyphs]

1:47:18

Global Fields + Text Formatting functions = Layout Dialogs

1:48:06

Insert Text into a $variable

1:48:49

Monkeybread Script readability features

1:49:37

Script triggers + Popover https://filemakerhacks.com/2016/10/25/modal-popovers-and-magic-date-value-lists/

1:50:12

Custom Function syntax ideas

1:50:42

Field calculation syntax for building text blocks

1:51:16

Scripting use case for Get ( LayoutTableName )

1:52:16

Experimental user interface pattern for a single layout wizard

1:53:32

Keep a file from closing

1:53:39

Closing thoughts