{"id":6240,"date":"2020-09-03T11:19:21","date_gmt":"2020-09-03T18:19:21","guid":{"rendered":"https:\/\/app.works\/?p=6240"},"modified":"2022-08-02T10:55:44","modified_gmt":"2022-08-02T17:55:44","slug":"virtual-intermediate-filemaker-class-series","status":"publish","type":"post","link":"https:\/\/app.works\/virtual-intermediate-filemaker-class-series\/","title":{"rendered":"Virtual Intermediate FileMaker Class Series"},"content":{"rendered":"\n<p>Starting in early October, AppWorks is offering a virtual class series for intermediate-level developers looking to hone their Claris&#8217; FileMaker skills. Classes will utilize FileMaker Pro Advanced 19, which can be provided if needed.<\/p>\n\n\n\n<!--more-->\n\n\n\n<p>Classes will be held on Wednesday and Friday afternoons from 3:30-5PM PST via Zoom, starting on Friday, October 9th and ending on Wednesday, November 4th. Classes will include lectures, breakout sessions, hands-on development and Q&amp;A sessions. Recordings will be available after each class for review purposes.<\/p>\n\n\n\n<p>Classes are available for purchase in <strong><a href=\"https:\/\/app.works\/shop\/\">AppWorks&#8217; store<\/a><\/strong>, and may be purchased individually for $100 each, or <strong><a href=\"https:\/\/app.works\/product\/virtual-intermediate-filemaker-class-series\/\">as a series<\/a><\/strong> for $600 total ($200 savings).<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"1024\" height=\"1024\" src=\"https:\/\/app.works\/wp-content\/uploads\/2020\/09\/Brown-Black-Friday-Sale-Instagram-Post-1024x1024.png\" alt=\"Picture showing a laptop and a banner with &quot;Virtual Intermediate FileMaker&quot; class series\" class=\"wp-image-6238\" srcset=\"https:\/\/app.works\/wp-content\/uploads\/2020\/09\/Brown-Black-Friday-Sale-Instagram-Post-1024x1024.png 1024w, https:\/\/app.works\/wp-content\/uploads\/2020\/09\/Brown-Black-Friday-Sale-Instagram-Post-150x150.png 150w, https:\/\/app.works\/wp-content\/uploads\/2020\/09\/Brown-Black-Friday-Sale-Instagram-Post-768x768.png 768w, https:\/\/app.works\/wp-content\/uploads\/2020\/09\/Brown-Black-Friday-Sale-Instagram-Post-300x300.png 300w, https:\/\/app.works\/wp-content\/uploads\/2020\/09\/Brown-Black-Friday-Sale-Instagram-Post-600x600.png 600w, https:\/\/app.works\/wp-content\/uploads\/2020\/09\/Brown-Black-Friday-Sale-Instagram-Post-100x100.png 100w, https:\/\/app.works\/wp-content\/uploads\/2020\/09\/Brown-Black-Friday-Sale-Instagram-Post.png 1080w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h2 class=\"has-medium-font-size\">The class schedule will be as follows:<\/h2>\n\n\n\n<ul><li><strong>Class 1 &#8211; October 9th<\/strong><ul><li>Layout Design &#8211; building a data entry layout that is simple to use <ul><li>Using themes, styles and consistency in design<\/li><li>Using columns and guides to divide your layout into zones<\/li><li>Using Button Bars, Popovers, and <a href=\"https:\/\/app.works\/card-windows\/\">Card Windows<\/a> to make complex tasks simple<\/li><\/ul><\/li><\/ul><\/li><li><strong>Class 2 &#8211; October 14th<\/strong><ul><li>Working with fields &amp; relationships<ul><li>Text, number, date &amp; timestamp fields \u2013 when and how to use each type<\/li><li>Primary and foreign keys<\/li><li>The importance of UUID keys vs. serial numbers<\/li><li>Working with container fields and storage<\/li><\/ul><\/li><\/ul><\/li><li><strong>Class 3 &#8211; October 16th<\/strong><ul><li>Key calculation functions<ul><li>Case ()<\/li><li>Let ()<\/li><li>Text parsing, concatenation, listing and summarizing<\/li><li>The strange beauty of <em>Not IsEmpty ()<\/em><\/li><li>Importing &amp; exporting data<\/li><\/ul><\/li><\/ul><\/li><li><strong>Class 4 &#8211; October 21st<\/strong><ul><li>Intermediate Scripting Part I<ul><li>Iteration and building complexity over time<\/li><li>Calling subscripts<\/li><li>Script philosophy: keeping things contained and simple<\/li><li>Commenting best <a href=\"https:\/\/app.works\/community\/best-practices-video-archive\/\">practices<\/a><\/li><\/ul><\/li><\/ul><\/li><li><strong>Class 5 &#8211; October 23rd<\/strong><ul><li>Relationships &amp; Data Modeling<ul><li>Creating relationships<ul><li>One to many<\/li><li>One to one<\/li><li>Many to many<\/li><\/ul><\/li><li>The primary function of the the Relationship Graph (is probably not what you think)<\/li><li>Sorting and filtering portals<\/li><\/ul><\/li><\/ul><\/li><li><strong>Class 6 &#8211; October 28th<\/strong><ul><li>Reports &amp; Dashboards<ul><li>Using a List layout as a report<\/li><li>Working with Sub-summaries<\/li><li>Using a Sort script<\/li><li>One layout, many reports<\/li><\/ul><\/li><\/ul><ul><li>Building a dashboard<ul><li>Show meaningful data<\/li><li>Simple navigation<\/li><li><a href=\"https:\/\/app.works\/product\/fmrecent-records\/\">fmRecentRecords<\/a>, fmLog &amp; other free tools<\/li><\/ul><\/li><\/ul><\/li><li><strong>Class 7 &#8211; October 30th<\/strong><ul><li>Using JSON<ul><li>Key functions:<ul><li>JSONSetElement ()<\/li><li>JSONGetElement ()<\/li><li>JSONFormatElements()<\/li><\/ul><\/li><li>Scripting with <a href=\"https:\/\/app.works\/passing-multiple-parameters-natively-in-filemaker-16-using-json\/\">multiple parameters<\/a><\/li><li>Beware: JSON is case sensitive<\/li><\/ul><\/li><\/ul><\/li><li><strong>Class 8 &#8211; November 4th<\/strong><ul><li>Intermediate Scripting Part II<ul><li>Looping<\/li><li>Error checking<\/li><li>Logging<\/li><li><a href=\"https:\/\/app.works\/automatically-perform-script-on-server\/\">Perform Script on Server<\/a><\/li><\/ul><\/li><li>Tie it all together<\/li><\/ul><\/li><\/ul>\n\n\n\n<p>Please contact sales@app.works for class placement assistance if you would like to attend, but are unsure if intermediate classes are the right fit for your abilities. We are looking forward to these sessions, and hope you&#8217;ll join us at our Virtual Intermediate FileMaker Class Series on Zoom!<\/p>\n\n\n\n<div class=\"is-layout-flex wp-block-buttons\">\n<div class=\"wp-block-button\"><a class=\"wp-block-button__link has-background\" href=\"https:\/\/app.works\/product\/virtual-intermediate-filemaker-class-series\/\" style=\"background-color:#0023a3\">Register for Classes<\/a><\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Starting in early October, AppWorks is offering a virtual class series for intermediate-level developers looking to hone their Claris&#8217; FileMaker skills. Classes will utilize FileMaker Pro Advanced 19, which can be provided if needed.<\/p>\n","protected":false},"author":8,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[58,40,18],"tags":[579,578,520,519,580,20,313],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\r\n<title>Virtual Intermediate FileMaker Class Series - AppWorks<\/title>\r\n<meta name=\"description\" content=\"AppWorks is offering a virtual class series for intermediate-level developers looking to hone their Claris&#039; FileMaker skills.\" \/>\r\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\r\n<link rel=\"canonical\" href=\"https:\/\/app.works\/virtual-intermediate-filemaker-class-series\/\" \/>\r\n<meta property=\"og:locale\" content=\"en_US\" \/>\r\n<meta property=\"og:type\" content=\"article\" \/>\r\n<meta property=\"og:title\" content=\"Virtual Intermediate FileMaker Class Series - AppWorks\" \/>\r\n<meta property=\"og:description\" content=\"AppWorks is offering a virtual class series for intermediate-level developers looking to hone their Claris&#039; FileMaker skills.\" \/>\r\n<meta property=\"og:url\" content=\"https:\/\/app.works\/virtual-intermediate-filemaker-class-series\/\" \/>\r\n<meta property=\"og:site_name\" content=\"AppWorks\" \/>\r\n<meta property=\"article:published_time\" content=\"2020-09-03T18:19:21+00:00\" \/>\r\n<meta property=\"article:modified_time\" content=\"2022-08-02T17:55:44+00:00\" \/>\r\n<meta property=\"og:image\" content=\"https:\/\/app.works\/wp-content\/uploads\/2020\/09\/Brown-Black-Friday-Sale-Instagram-Post-1024x1024.png\" \/>\r\n<meta name=\"author\" content=\"Eleanor Fulton\" \/>\r\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\r\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Eleanor Fulton\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\r\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/app.works\/virtual-intermediate-filemaker-class-series\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/app.works\/virtual-intermediate-filemaker-class-series\/\"},\"author\":{\"name\":\"Eleanor Fulton\",\"@id\":\"https:\/\/www.app.works\/#\/schema\/person\/5941dd881519558c983b47c4dafc3e83\"},\"headline\":\"Virtual Intermediate FileMaker Class Series\",\"datePublished\":\"2020-09-03T18:19:21+00:00\",\"dateModified\":\"2022-08-02T17:55:44+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/app.works\/virtual-intermediate-filemaker-class-series\/\"},\"wordCount\":421,\"publisher\":{\"@id\":\"https:\/\/www.app.works\/#organization\"},\"keywords\":[\"Claris classes\",\"Claris Training\",\"developer training\",\"FileMaker classes\",\"FileMaker Intermediate Classes\",\"Filemaker Training\",\"training\"],\"articleSection\":[\"Appworks FM Training\",\"Blog\",\"FileMaker Training\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/app.works\/virtual-intermediate-filemaker-class-series\/\",\"url\":\"https:\/\/app.works\/virtual-intermediate-filemaker-class-series\/\",\"name\":\"Virtual Intermediate FileMaker Class Series - AppWorks\",\"isPartOf\":{\"@id\":\"https:\/\/www.app.works\/#website\"},\"datePublished\":\"2020-09-03T18:19:21+00:00\",\"dateModified\":\"2022-08-02T17:55:44+00:00\",\"description\":\"AppWorks is offering a virtual class series for intermediate-level developers looking to hone their Claris' FileMaker skills.\",\"breadcrumb\":{\"@id\":\"https:\/\/app.works\/virtual-intermediate-filemaker-class-series\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/app.works\/virtual-intermediate-filemaker-class-series\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/app.works\/virtual-intermediate-filemaker-class-series\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.app.works\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Virtual Intermediate FileMaker Class Series\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.app.works\/#website\",\"url\":\"https:\/\/www.app.works\/\",\"name\":\"AppWorks\",\"description\":\"Designing Smart Apps Geared to Work for You\",\"publisher\":{\"@id\":\"https:\/\/www.app.works\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.app.works\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.app.works\/#organization\",\"name\":\"AppWorks\",\"url\":\"https:\/\/www.app.works\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.app.works\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/app.works\/wp-content\/uploads\/2021\/02\/cropped-logo-aw-dis-big-1.png\",\"contentUrl\":\"https:\/\/app.works\/wp-content\/uploads\/2021\/02\/cropped-logo-aw-dis-big-1.png\",\"width\":175,\"height\":67,\"caption\":\"AppWorks\"},\"image\":{\"@id\":\"https:\/\/www.app.works\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.app.works\/#\/schema\/person\/5941dd881519558c983b47c4dafc3e83\",\"name\":\"Eleanor Fulton\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.app.works\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/4cd2b743e511b29d848d94203bc47e0c?s=96&d=identicon&r=pg\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/4cd2b743e511b29d848d94203bc47e0c?s=96&d=identicon&r=pg\",\"caption\":\"Eleanor Fulton\"},\"url\":\"https:\/\/app.works\/author\/eleanor\/\"}]}<\/script>\r\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Virtual Intermediate FileMaker Class Series - AppWorks","description":"AppWorks is offering a virtual class series for intermediate-level developers looking to hone their Claris' FileMaker skills.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/app.works\/virtual-intermediate-filemaker-class-series\/","og_locale":"en_US","og_type":"article","og_title":"Virtual Intermediate FileMaker Class Series - AppWorks","og_description":"AppWorks is offering a virtual class series for intermediate-level developers looking to hone their Claris' FileMaker skills.","og_url":"https:\/\/app.works\/virtual-intermediate-filemaker-class-series\/","og_site_name":"AppWorks","article_published_time":"2020-09-03T18:19:21+00:00","article_modified_time":"2022-08-02T17:55:44+00:00","og_image":[{"url":"https:\/\/app.works\/wp-content\/uploads\/2020\/09\/Brown-Black-Friday-Sale-Instagram-Post-1024x1024.png"}],"author":"Eleanor Fulton","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Eleanor Fulton","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/app.works\/virtual-intermediate-filemaker-class-series\/#article","isPartOf":{"@id":"https:\/\/app.works\/virtual-intermediate-filemaker-class-series\/"},"author":{"name":"Eleanor Fulton","@id":"https:\/\/www.app.works\/#\/schema\/person\/5941dd881519558c983b47c4dafc3e83"},"headline":"Virtual Intermediate FileMaker Class Series","datePublished":"2020-09-03T18:19:21+00:00","dateModified":"2022-08-02T17:55:44+00:00","mainEntityOfPage":{"@id":"https:\/\/app.works\/virtual-intermediate-filemaker-class-series\/"},"wordCount":421,"publisher":{"@id":"https:\/\/www.app.works\/#organization"},"keywords":["Claris classes","Claris Training","developer training","FileMaker classes","FileMaker Intermediate Classes","Filemaker Training","training"],"articleSection":["Appworks FM Training","Blog","FileMaker Training"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/app.works\/virtual-intermediate-filemaker-class-series\/","url":"https:\/\/app.works\/virtual-intermediate-filemaker-class-series\/","name":"Virtual Intermediate FileMaker Class Series - AppWorks","isPartOf":{"@id":"https:\/\/www.app.works\/#website"},"datePublished":"2020-09-03T18:19:21+00:00","dateModified":"2022-08-02T17:55:44+00:00","description":"AppWorks is offering a virtual class series for intermediate-level developers looking to hone their Claris' FileMaker skills.","breadcrumb":{"@id":"https:\/\/app.works\/virtual-intermediate-filemaker-class-series\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/app.works\/virtual-intermediate-filemaker-class-series\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/app.works\/virtual-intermediate-filemaker-class-series\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.app.works\/"},{"@type":"ListItem","position":2,"name":"Virtual Intermediate FileMaker Class Series"}]},{"@type":"WebSite","@id":"https:\/\/www.app.works\/#website","url":"https:\/\/www.app.works\/","name":"AppWorks","description":"Designing Smart Apps Geared to Work for You","publisher":{"@id":"https:\/\/www.app.works\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.app.works\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.app.works\/#organization","name":"AppWorks","url":"https:\/\/www.app.works\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.app.works\/#\/schema\/logo\/image\/","url":"https:\/\/app.works\/wp-content\/uploads\/2021\/02\/cropped-logo-aw-dis-big-1.png","contentUrl":"https:\/\/app.works\/wp-content\/uploads\/2021\/02\/cropped-logo-aw-dis-big-1.png","width":175,"height":67,"caption":"AppWorks"},"image":{"@id":"https:\/\/www.app.works\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.app.works\/#\/schema\/person\/5941dd881519558c983b47c4dafc3e83","name":"Eleanor Fulton","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.app.works\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/4cd2b743e511b29d848d94203bc47e0c?s=96&d=identicon&r=pg","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/4cd2b743e511b29d848d94203bc47e0c?s=96&d=identicon&r=pg","caption":"Eleanor Fulton"},"url":"https:\/\/app.works\/author\/eleanor\/"}]}},"_links":{"self":[{"href":"https:\/\/app.works\/wp-json\/wp\/v2\/posts\/6240"}],"collection":[{"href":"https:\/\/app.works\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/app.works\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/app.works\/wp-json\/wp\/v2\/users\/8"}],"replies":[{"embeddable":true,"href":"https:\/\/app.works\/wp-json\/wp\/v2\/comments?post=6240"}],"version-history":[{"count":7,"href":"https:\/\/app.works\/wp-json\/wp\/v2\/posts\/6240\/revisions"}],"predecessor-version":[{"id":9036,"href":"https:\/\/app.works\/wp-json\/wp\/v2\/posts\/6240\/revisions\/9036"}],"wp:attachment":[{"href":"https:\/\/app.works\/wp-json\/wp\/v2\/media?parent=6240"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/app.works\/wp-json\/wp\/v2\/categories?post=6240"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/app.works\/wp-json\/wp\/v2\/tags?post=6240"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}