DIGFM: Fundamental Features for Fantastic FileMaker Files (4/14/2022)

Show Notes and Timestamp Links

0:00:01

Intro

0:06:36

FileMaker Text Editor

0:09:06

Send HTML Email from Apple Mail

0:10:05

Fun FileMaker Facts

0:12:11

Color Documents

0:13:36

Custom Function hex_to_rgb.result:

0:13:56

Lets look at some code

0:16:46

Concept: the hex color code for the button text is the same as applied to the text selection

0:19:21

CF: hex_to_RGB.result ( hex_code ) -> https://www.briandunning.com/cf/2585

0:21:46

Tip: do not specify a field to take action on the ActiveField

0:22:56

TextStyle examples

0:26:31

Text functions to modify text: lower, UPPER, Proper

0:27:36

re-factored from monolithic script to suite of scripts

0:29:21

OOPS, there is nothing wrong with the getAsCSS

0:31:01

OOPS, Field not sleepy. Tony Sleepy!

0:32:46

Ordered and Unordered lists

0:37:41

Tools to change ~ to $$ and $$ to ~ for debugging calcs -> https://the.fmsoup.org/t/macos-services-to-help-write-filemaker-code/1261/6

0:39:16

Can you build in an undo feature?...

0:43:06

Just tested and it looks like you CAN pass styled text between Files, depending on how you do it:
https://community.claris.com/en/s/question/0D73w000006XTRHCA4/digfm-fundamental-features-for-fantastic-filemaker-files-4142022

0:49:01

Demo that the tools work on any field. Pros and Cons?

0:50:01

AppleScript to create HTML email to Apple Mail -> https://forum.latenightsw.com/t/create-mac-mail-msg-with-rich-text-content-that-also-has-cc-address-filled-in/2037/4

0:52:36

Rich Text Editor add-on text editor from Claris -> https://marketplace.claris.com/detail/1551.html

0:54:16

Thing that we find useful in a list view...

0:54:46

Fit Rows

1:07:16

Sort Records by field blac box Script

1:09:06

Last years presentation -> https://www.youtube.com/watch?v=0kQ7i7s99m4

1:12:41

Tip Do not specify the "FileName" in design functions to target the current/internal file (manage scope)

1:17:06

CF: value.index.ci ( a_list ; a_value ) -> https://www.briandunning.com/filemaker-custom-functions/results.php

1:21:01

Is it a "Wizard" or a "Feature Revealer"

1:22:51

OOPS, email address is tony_white at twdesigns.com

1:24:06

Unsort

1:24:56

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

1:26:21

Keith Proctor's presentation -> "DIGFM: Performance Review & What Makes it Better? Ask Keith! (3/10/2022)" https://www.youtube.com/watch?v=xjzcTUpUveE&t=9068s

1:33:06

Omit feature

1:35:16

Enter Find on field using ObjectName

1:37:41

Finding is harder than it looks! What could go wrong?

1:40:56

Find Matching Records is a script step (not a function)

1:42:31

How to escape a find? Let FileMaker do it!

1:45:46

Omit by Content or Selection

1:47:31

BrowserNav -> https://www.apjuk.com/browsernav/

1:49:01

Find Step by Step

1:52:01

FMBUG presentation link -> https://www.youtube.com/watch?v=ms7hYpvXMK0

1:52:41

Questions

2:00:46

Announcements

1:58:56

Symbols and a Popover for troubleshooting

2:04:16

Closing thoughts