DIGFM: FileMaker Standards 'Convention' (9/8/2022)

Don't just do things willy-nilly because FileMaker will let you.
Have some standards for TOGs sake!
The meticulous megamind of Matt Petrowsky of ISO Productions will be helping us with a discussion of FileMaker standards, such as naming conventions, etc.
Topics:
0:00:45 # The FileMakerStandards.org site
0:07:03 # New Dev.FileMakerStandards.org site
0:20:52 # Table Field Names
0:29:29 # Organizing with Alphabetization etc.
0:50:10 # Exhausting the field Comment
1:11:36 # Custom Function naming
1:18:15 # Style naming
1:39:39 # Collaborative Coding
1:47:37 # Developer Tools/Experience (DX)
2:00:00 # Themes
2:04:53 # Robert Naud on standards to Make your code more readable
2:11:00 # Layout Object Information
Meeting details and discussion here.
community.clar...
You can follow more of what we're up to with the Developer Innovation Group in FileMaker-and even offer us suggestions-at the following Community group:
community.clar...

[@DIGFM]

Topics:
0:00:45 # The FileMakerStandards.org site
0:07:03 # New Dev.FileMakerStandards.org site
0:20:52 # Table Field Names
0:29:29 # Organizing with Alphabetization etc.
0:50:10 # Exhausting the field Comment
1:11:36 # Custom Function naming
1:18:15 # Style naming
1:39:39 # Collaborative Coding
1:47:37 # Developer Tools/Experience (DX)
2:00:00 # Themes
2:04:53 # Robert Naud on standards to Make your code more readable
2:11:00 # Layout Object Information

[@siegfriedbarfuss9379]

at 45' why can you not use tilde "~" in scripts or calcs?

[@DIGFM]

-0 Robert Naud: cqdf.ca/
-0 Eric Matthews: engageu.eu
-0 James Toland: That was Michael’s thing
-0 Chris Moyer to Tony White: So when you say it tolerates two machines with the same IP, I assume you mean v4 and not V6?
-0 # The FileMakerStandards.org site
0:01:15 Vincenzo Menanno: filemakerstandards.org
0:02:24 Eric Matthews: filemakerstandards.org
0:06:01 Tony White: ~ as the Let vars prefix is one of my favorite conventions
0:06:21 Tom: tilde schmilde
0:07:03 # New Dev.FileMakerStandards.org site
0:07:16 Tony White to Chris Moyer: Same IP was causing issues. unique IP fixed it!
0:07:17 Matt: dev.filemakerstandards.org
0:08:41 Tom: the great thing about standards is that there are so many of them
0:16:10 Eric Matthews: By the way, Robert Naud's presentation might make a good answer to "So what?" on standards: ruclips.net/video/n5xQtyMAa6w/видео.html
0:17:10 Tony White to Chris Moyer: Code object to add..Script Folders. I like "Table ->"
0:20:52 # Table Field Names
0:21:36 Tony White: Script Folders. I like "Table ->" or ...
0:24:04 Tony White: ...ie Script Folder: "130 Navigation ->"
0:25:04 David Head: I did a Devcon presentation years ago arguiong that primary keys should be named ID. With survey results of what others were using.
0:28:16 Vincenzo Menanno: What do people name foreign keys
0:28:53 David Head: My basic name for a FK is IDentity
0:29:18 Eric Matthews: E.g. People_id
0:29:21 David Head: So a relationship is: ID = IDperson
0:29:29 # Organizing with Alphabetization etc.
0:29:32 Tom: we used 'id' for awhile but ultimately found clarity in 'TableID' e.g. PersonID etc. This works for both primary and foreign keys
0:29:34 Eric Matthews: E.g. People_ID
0:30:34 Tony White: +1 on "nameFirst" rather than "personNameFirst"
0:30:41 David Head: per Matt's argument, I think the PK does not need the entity in the name. So that means that if I see and entity name in an ID, then I know it is a FK.
0:31:04 Vincenzo Menanno: totally agree
0:33:36 Tom: alphabetical order rules
0:36:37 Tony White: zz_prefix for fields that you want to hide for the user as best you can by pushing them to the bottom
0:37:29 Eric Matthews: My distaste for underscore makes that zzPrefix.
0:37:46 David Head: not a fan of zz or __
0:39:42 David Head: Problem with using field comment for JSON is the limited access to the field - you could potentially have a lot of JSON in there but poor access to read/edit it.
0:39:52 Eric Matthews: You can use ›› in JSON?
0:40:32 David Head: yes we are lacking org tools for many things
0:41:50 David Head: we need public and private fields
0:44:31 Eric Matthews: Emoji Standards?
0:44:50 Vincenzo Menanno: 😆 standards
0:46:31 David Head: 🤦🏼‍♂
0:50:10 Tom: github.com/filemakerstandards/fmpstandards
0:50:10 # Exhausting the field Comment
0:55:23 Eric Matthews: ...with JSON
0:57:15 Tom: that's pretty neat
1:09:32 Tom: Robert, that's a good point - sometimes the standard needs to adapt to the applications, and not always v. versa
1:11:36 # Custom Function naming
1:14:55 Tom: I agree on this one - I've never seen the value of making CFs distinct from native functions
1:15:32 Eric Matthews: There's a separate folder for them in the calc editor anyway.
1:16:33 Eric Matthews: Wish there were just default object names or ids.
1:18:12 Tom: it's still a button ...
1:18:15 # Style naming
1:25:07 Darrin Southern: the exception proves the rule . . .
1:25:59 Tom: in apex blue, new file, 2nd button style is blank ... is it just me?
1:29:57 Darrin Southern: isolutions-inc.com/free-filemaker-templates/
1:30:47 Matt: templates.fm
1:34:07 Tom: thanks so much - gotta run - Fitch out
1:39:39 # Collaborative Coding
1:43:24 Eric Matthews: Does anyone have links to other published naming standards?
1:47:37 # Developer Tools/Experience (DX)
1:53:25 Eric Matthews: If only developers could make their own DX: community.claris.com/en/s/idea/0870H000000fz9UQAQ
1:58:35 Jorden Harris: I have no idea how the lookups work
1:59:56 Eric Matthews: FFFight Club: ruclips.net/p/PLjIg0e80DKaXLnSqYRiswD_aCfwtr59fn
2:00:00 # Themes
2:04:53 # Robert Naud on standards to Make your code more readable
2:07:17 Vincenzo Menanno: I have to go ... thank you Matt and great discussion.
2:07:25 Matt: See ya vince.
2:11:00 # Layout Object Information
2:11:48 Robert Naud:
community.claris.com/en/s/question/0D53w00005rLfORCA0/getlayoutobjectownerinfo-crosslayout-dependency-issue
2:12:17 Tony White: help.claris.com/en/pro-help/content/getlayoutobjectownerinfo.html
2:14:05 Robert Naud: help.claris.com/en/pro-help/content/layoutobjectuuid.html
2:20:07 Tony White: Here is what I have Eric • FMDev_ConvNov05.pdf support.claris.com/s/article/White-Paper-FileMaker-Development-Conventions-1503692947223
We need more standards! ;-) philosophyoffilemaker.com/naming-standards-165 dbservices.com/blog/filemaker-naming-conventions-and-standards www.clickworks.eu/wp-content/uploads/2021/05/ClickWorks-Naming-Conventions-V7.3.pdf filemakerstandards.org/display/cs/Naming+Conventions www.squaremoon.se/download/FileMaker_Naming_Convention.pdf skeletonkey.com/filemaker-naming-conventions/ www.productivecomputing.com/documents/Core4/Developers_Guide_Core4.pdf www.productivecomputing.com/documents/Core4/Developers_Guide_Core4.pdf coresolutions.ca/blogs/blog-downloads/CoreSolutions-Software-Inc-FMP-Naming-Standards-Dec-2010.pdf
www.yzysoft.com/kb/filemaker-naming-convention/