navarre.ai

Slide archive

JSON Session

FileMaker Week Rome · 2023 · Matt Navarre · 57 slides

See the slides

Slide 2JSON

Matt Navarre

Slide 3JSON

Slide 4Let’s Interact

Slide 5About Matt

Hey, nice suit ^

Slide 6Free Stuff

Slide 7Quick Poll

Slide 8Two Part Agenda

Slide 9What is JSON?

Slide 10What is JSON?

Slide 11Why?

Like with anything in life, there are things that seem difficult at first, but then bring simplicity to your life.
Staying upright on a bike.
Playing a scale.
Creating a multi-user relational database that ends world hunger.

Slide 12Use Cases

Slide 13When?

Slide 14Who?

Slide 15Who?

Slide 16Who?

Slide 17Who?

Slide 18Who?

Slide 19Who?

Slide 20Who?

Douglas Crockford

He didn’t invent it, but he did popularize it

Slide 21Two Functions

Let’s dive into Set Element. Why start with the easy one, right?

Slide 22Data Viewer

Slide 23Data Viewer

Click here

Slide 24Set

FM Defaults

What’s important?

My preferred formatting

Slide 25Set : Single

Let’s all head to DataViewer and type this.
JSONSetElement ( "" ; "color" ; "green" ; jsonstring )
Those of you who are JSON jockeys - it’s a good time to check your email.

Slide 26Code Break

Slide 27String Number Boolean, etc.

Each line can have a type. These three are the basics

Slide 28Punctuation

Slide 30Code Break

Slide 31Just Kidding

We will get there though

Slide 32We were here

Why No Workie?

Copy and paste the line with the name, value, and type.
Remove the last semicolon, just as in a Case ( )

Slide 33Punctuation Marks

[ ]

Nope

Yup

Here’s how to fix. Each line needs to be encased in [ ]
Oh by the way, did you note that you can type jsonstring and it turns into JSONString?

Slide 34Real Example

Slide 35Define as Object

Slide 36Let ( ) us do more

Did you know that you can use a LET function to define a global variable?
Well now you do. And it’s great for this class.
Let’s duplicate the line in Data Viewer, and wrap the JSON in a Let, so we can create a global variable

Slide 37Code Break

Slide 38Get

Let’s jump over to the Current tab in Data viewer
Notice that the $$variable we defined is there. This is great, because now we can learn the second, easier function: JSON GET element

Slide 39Get

It just has two arguments. Name and Value
Both can be text. Or fields. Or variables.

Slide 40Code Break

Slide 41Get

Slide 42Other Things you should know

Slide 43Code Break

Slide 44Passing Parameters

Let’s integrate the simple code we just wrote. We will copy and paste the SetElement. Oh, and this is the last time you’ll need to write one from scratch - from now, just copy, paste, and edit. The beauty of DataViewer.

Slide 45More…

Slide 46fmLog

Slide 47Record Snapshot

Slide 48Record Snapshot

Slide 49API & Claris Connect

JSON is the language of the internet

Slide 50Configuration & Prefs

Slide 51Dashboard Data Display

Slide 52SearchResults 7

Slide 53Settings & Preferences

Slide 54AI

Slide 55SearchResults 7

Slide 56Part Deux