Here’s What We Found Interesting From WWDC18

Headline:

“Apple aims to put the customer at the center of everything we do”- Apple at WWDC18

This is something Kyo Logic and Apple have in common. We aim to provide the most user-centric services with everything we do, whether it is consulting, training, or FileMaker Development, making your business easier to run is our primary goal.

Here are some takeaways in iOS 12 that we found best upheld Apple’s promise:

Screen Time:

Smartphones have become an addiction, especially amongst the younger generation. Apple (being the number one contributor to that addiction) has begun to address this issue by implementing a new feature on iOS 12 called Screen Time. Screen Time provides you with a weekly report of how much time you have been spending on your iPhone, how often you check your iPhone, and what apps you’ve been spending the most time on.

The user-centric aspect of Screen Time is how customizable it can be. Users can:

  • Set limits for the time they spend on specific apps, with warnings when you get close to your limit
  • Set limits on their children’s devices remotely to help limit their usage
  • Set Downtime for when apps won’t be displayed and indicate when specific apps aren’t usable
  • Screen Time is Apple’s way to contribute to solving a social issue that they’ve helped create, all while keeping the user’s decisions to choose their settings in mind.

Security and Privacy:

In the tech world, people are always worried about their online presence, and whether their data is safe or not. Apple and Kyo Logic are two companies that show a similar drive to keep our user’s data safe. As per usual, Apple touched base on how up to date their security and privacy software is, but something especially interesting popped up that we found notable.

We have all seen the relentless “like” and “share” buttons on almost every website nowadays. These buttons can track and take down information from the user without even clicking them. Apple has made the stride to get rid of their user’s worry by disallowing this ability with iOS 12’s new Safari. To keep with Apple’s general theme of the conference of keeping the user at the center of everything they do, Apple has made this function optional. Every time one of these buttons is in effect, the user will have to allow access.

Apple is keeping the customer in the center of its update by thinking ahead of possible security threats, yet also allowing the user to bypass this security measure if they choose to do so.

Swift and The Apple Learning Community:

As any FileMaker user could tell you, coding is the language of technology and the future. Apple has been spreading the idea of how learnable the ability to code is through the implementation of Swift and Swift Playground. Both technologies have been out for a couple of years now, but Apple is pushing to get the public involved in coding for free.

Apps like Swift Playground make learning how to code very easy, and especially fun for inexperienced coders. Apple says, “We think everyone should have the opportunity to create something that can change the world. So we’ve designed a program that lets anyone learn, write, and teach code.”(Apple)

This entire movement falls under Apple’s overarching goal of the Apple Learning Community. Apple is pushing to get coding classes in all schools, enabling the next generation to create mind-blowing and groundbreaking apps that could change the world. For even more information on the Apple, Learning Community click here.

With the release of iOS 12, Apple includes an entire learning community with abilities of the public to become teachers and students to spread valuable knowledge.

By creating an available source of valuable education, and catering towards our youth, Apple has been continually showing us how customer-driven they are both for-profit and the betterment of society.

iOS 12 Beta

If you would like to access the Beta of iOS 12, click here, and help Apple make it their best release yet!

Work Cited:

iCrackUriDevice. “LIVE: Apple WWDC 2018 – IOS 12 & MORE – Video Stream (June 2018 Keynote)!” YouTube, YouTube, 4 June 2018, www.youtube.com/watch?v=61U4_ygZolo

“Everyone Can Code.” Apple, Apple.inc, www.apple.com/everyone-can-code/.

Welcome FileMaker 17!

FileMaker 17 Overview!

FileMaker 17 is finally here, and we are excited to review all the new features included! FileMaker releases new versions of the powerful database annually and this year may be the best release yet. In this post, we will review all the new features that have been released in FileMaker Pro Advanced, FileMaker Go, FileMaker Server, FileMaker Cloud, and FileMaker WebDirect. In separate articles, we will provide a more in-depth look at some of our favorite new features and a breakdown of the new licensing programs!

What’s New in FileMaker 17!

  • Layout Mode was redesigned for streamlined development
  • FileMaker now allows users to add default fields when you create new tables
  • FileMaker will now be able to handle multiple email attachments
  • FileMaker Data API is no longer a trail feature and supports scripts and uploading files to container fields
  • FileMaker Go will now support local notifications
  • Users can now drag and drop text, photos, and files between apps while using FileMaker Go!

Development

Group Object Selection

While developing in FileMaker you have had the ability to group together objects but when you needed to modify, reposition, or resize an individual object inside the group you would have to undo the groupings. With the Group Object Selection, you are able to select individual objects within a group and modify as needed.

Redesigned Layout Mode

FileMaker has redesigned layout mode for a more streamlined design environment. The Inspector, Fields tab and Objects tab will now be pinned inside the document window, so you will no longer lose them on other screens while working!

Default Fields

Most developers include a group of standard default fields in every application that is created, FileMaker has now added default fields to help streamline the process of creating new fields such as primary key, creation date, modification date, and who the record was created or modified by. Just add a new table within FileMaker and these fields will automatically be created. These fields can be customized or removed via an XML file.

Scripting Enhancements

FileMaker has added two new scripting enhancements to FileMaker 17. First, they have enhanced the Perform Script and Perform Script on Server script steps by adding the ability to specify which script should run by name. Second, They have added support for using variables in the input field to populate and retrieve text within a Show Custom Dialog script step.

Multiple Email Attachments

FileMaker has had the ability to send emails directly from your application for some time but up until now, users have been limited to only one attachment. In FileMaker 17 users will now have the ability to add multiple attachments when sending emails.

Copy and Paste Custom Menus

Save time while developing but reusing custom menus that you have created in other FileMaker apps. All you have to do is copy menu sets, menus, and menu items and paste them into your file!

FileMaker Data Migration Tool

Using the FileMaker Data Migration Tool developers will be able to cut the time it takes while importing large data sets in half. The new command-line tool will help when you update your deployed custom apps.

Deployment

FileMaker Server Admin Console

For easier administration of FileMaker applications, the FileMaker Server Admin Console was redesigned to provide a streamlined user interface. The Admin Console will feature a Dashboard page to easily monitor hosted apps, connected clients, and system statistics. Administrators will also receive notifications that will provide more detail on how to handle errors if they occur.

Work While Reconnecting

If a network connection to FileMaker Server is lost while you are working you will be able to continue working on files that do not depend on the host until the connection is restored.

Cloud

FileMaker Cloud will support all new features for FileMaker 17. Users will also have the ability to use the Comodo SSL certificate for 60-day free trails.

Mobility

Configure Local Notification

FileMaker Go will increase iBeacon technologies to include local notifications. Any iPad or iPhone that is using FileMaker Go that is running in the background will display local notifications such a meeting reminds, or when an iBeacon is near. Just set up scripts that will send local alerts based on info from your device!

Auto-Complete

Auto-Complete has been a great tool on the Desktop in FileMaker Pro but now this feature will be coming to FileMaker Go! Start typing a letter or two into a text field and a list of items that match what you are typing will appear!

Drag and Drop

FileMaker users will not have the ability to drag and drop text, photos, and files between apps on the iPad while running a minimum of iOS 11.

Integration

FileMaker Data API

FileMaker first introduced the FileMaker Data API as a trail in FileMaker Server 16 as an easy way to integrate your FileMaker data to other popular apps and we services using the industry standard REST API. In FileMaker 17 this will no longer be a trail and will include powerful new features including support for FileMaker Server scripts and the ability to upload files to container fields. FileMaker has also added more standardized API formats to make the FileMaker Data API easier to work with.

Security

Account Lockout

Security has been the main focus for FileMaker in the most recent releases. To continue strengthening security throughout the FileMaker Platform, users will now be temporarily locked out of accounts after failed login attempts. Users must wait 5 minutes before they can attempt to log back in.

To learn more about FileMaker 17 or incorporate these awesome new features in your FileMaker database today give Kyo Logic a call!

Introduction to FileMaker and SQL

Introduction to FileMaker and SQL

Are you looking for a way to take your FileMaker Database to the next level? Harnessing the power of SQL in FileMaker can help you streamline and easily access more of your data.

What is SQL and what are the benefits?

SQL is an abbreviation for structured query language and is a standardized programming language best used for managing a relational database. SQL also allows you to perform various operations on data and is used by developers to write data integration scripts and setting up and running analytical queries.

When using SQL in FileMaker you can there are many different benefits such as:

    • Quickly obtaining data for use in scripts
    • Versatility: Summarize, Join, Union, Find Within
    • Requires no persistent structures
    • Potentially very fast
    • Completely programmable

Well, this all sounds great but how do you get SQL to run in FileMaker?

With the latest versions of FileMaker, you can utilize the ExecuteSQL() function right within FileMaker which will allow you to perform select queries. SQL works well with Let functions and is often used to store data in global variables. Both simple or complex arguments can be entered into an SQL statement.

Additional FileMaker and SQL Recourses:
Conclusion

SQL is a great way to utilize your data in FileMaker. Whether writing simple or complex arguments you will be able to quickly use the ExecuteSQL() function in FileMaker to perform queries.

If you would like to harness the power of your data in FileMaker but do not want to do the heavy lifting contact us today.

Creating dashboards in FileMaker: a practical guide and free demo

Free FileMaker demo

Creating dashboards in FileMaker: a practical guide and free demo

Example files from Kyo Logic's dashboard webinar to help you plan your own FileMaker views.

You open FileMaker to find out which work needs attention today, then move between several screens to piece together the answer. A dashboard can bring the relevant measures into one view. Kyo Logic’s free FileMaker dashboard demo accompanies John Mathewson’s original dashboard webinar and gives you a resource to explore as you plan your own approach.

Key takeaways

  • A useful dashboard brings together the information your team needs to see.
  • Shared definitions help everyone understand what each key performance indicator means.
  • Charts, totals, and lists each offer a different way to understand your data.
  • The download includes example files you can explore for ideas for your own application.

About the FileMaker dashboard demo

This resource originated with Kyo Logic’s 2018 webinar on creating dashboards in FileMaker. The session covered approaches to dashboard design, implementation considerations, pivot tables and graphs, and establishing key performance indicators, or KPIs: measures used to track a specific business objective.

The demo gives you a way to explore those topics as you think about your own reporting needs. What belongs on your dashboard will depend on your data and what your team needs to see.

What would you like your dashboard to show?

Before building, we recommend thinking about what you want to measure or make visible. That might be the jobs due this week, orders that need follow-up, or work waiting for the next step.

A good starting point is something your team already looks up during the day. What information would make that easier to see in one place?

For a production manager, an overall count may be less useful than a list of the jobs that need intervention. An account manager may need the customer and promised follow-up date beside the total. Those day-to-day needs can help you decide what belongs in each view.

Helping everyone read the numbers the same way

It helps to agree on what a measure means before building the calculation. If your dashboard says a job is late, which date is it comparing? Does a completed job still count? What happens when someone changes the promised date?

Writing down the definition in plain language, including the period you’re measuring and which records belong in it, gives your team a chance to work through different interpretations before they become confusing numbers on a screen.

How often the information updates matters, too. A screen checked at the start of a shift may have different requirements from one used throughout the day. When your team knows how current the figures are, they can judge whether those figures are useful for the decision at hand.

Different ways to make your data easier to understand

A total can answer how many. A chart can help compare periods or categories. A list can show which records need action.

Pivot tables, which group data across categories so you can compare totals, were one of the topics in the original webinar. That kind of view can be useful when you want to see how a measure varies across teams or periods.

For a first version, we would recommend a few measures that are useful to the person reading them. Other information can have its own view if it serves a different role. That helps the dashboard stay easy to scan.

Ideas for your own FileMaker application

The ZIP includes two FileMaker example files, PivotTablesAndDrillingData18.fmp12 and TrendLines18.fmp12, plus AccessInformation.txt with the access details. An untouched copy of the examples will give you something to refer back to as you explore them in a test environment.

As you explore, you may spot ideas that would work in your own application. It helps to think about which of your records would supply the data and what you would want the calculation to show. That connects what you see in the demo with something useful for your team.

Once you have a first version, comparing its figures with records your team can check directly will help you spot calculation problems. That includes a case where there are no matching records. Feedback from someone who will use the dashboard can help, too: what do they understand from the screen, and what would they do next? Their answers can show you where a label, calculation, or layout needs a little more work.

Frequently asked questions

Is this an add-on I can drag onto a layout?

Not quite. This download contains example FileMaker files from the dashboard webinar. You can open them separately to explore the techniques before working out how they might fit your own application.

Can the demo give me ideas for my own dashboard?

Yes! You can explore the examples and think about where similar views would help your team. We recommend starting with what you want to measure or make visible, then looking at how those ideas could work with your data.

Should every department use the same dashboard?

Not necessarily. A production manager may need to see jobs waiting for attention, while an account manager needs upcoming customer follow-ups. We would recommend views that suit each team, with shared definitions for any measures they have in common.

What should I do if the dashboard total disagrees with a report?

We recommend checking whether both views include the same records, date range, and status rules first. A dashboard counting all open jobs will differ from a report showing only jobs due this week. Once those definitions line up, it is easier to see whether a calculation needs adjusting.

Want a hand with your dashboard?

The free FileMaker dashboard demo gives you examples to explore as you work out what would be useful in your own application. If you would like help defining the measures or building a view for your team, talk with Kyo Logic about data visualization. We build custom Claris FileMaker and manufacturing software for teams in New England and beyond.

Get the FileMaker dashboard demo

Tell us where to send your free dashboard demo download link.

Kyo Logic Announces New Website

Norwalk, Sept. 1, 2017… Kyo Logic has launched their newly revamped website. The new site will include updated information about the services offered by Kyo Logic as well as a better understanding of the company’s value proposition and client benefits. The revamped site will have blog posts and press releases that are updated monthly for up to date industry news on custom software development and FileMaker.

The new site has enhanced functionality and a clean and streamlined design that puts a focus on the Kyo Logic mission to provide easy to use custom software to streamline client’s businesses. The new site will be launched September 1st and be compatible across all platforms.

“A website redesign is more than a fresh coat of paint, it’s an entirely new opportunity to engage with our clients in a deeper and more meaningful way. As someone who is client facing, there’s a lot to be excited about with this update” said Stoddard Horn, Sales Associate at Kyo Logic.

Kyo Logic’s new site will be updated regularly with new services, FileMaker news, and industry standards. We encourage visitors to leave feedback and sign up for our monthly newsletters for all the latest updates.

About the Kyo Logic:

Kyo Logic is located in Southern Connecticut and was started in 2002 with a goal to change the way you think about FileMaker Pro development projects. We create custom apps and integrated mobile solutions for clients across all business sectors.

With Certified Platinum level skills and thousands of hours of real-world production experience, we can build the powerful, customized and integrated software solutions you need. Our team leverages these advantages even further by providing our clients with shorter development times and lower overall project costs. We are able to do this because of our commitment to efficiency and our decades of combined experience. We also have a deep understanding of FileMaker and its power, functionality and flexibility, so we can bring the very best solutions to the table.

We extend our services to webinars, speaking engagements, educational opportunities, and workshops. We use each event as an opportunity become a better development partner.

Connect Your Website to Your FileMaker Databases

Small businesses are looking for the same solutions that enterprise-level companies use, but at a small-business price. Now there is good news: we can customize a web solution allowing customers, employees, and others to access specific information in your database directly from your website.

Whether you’re familiar with the Filemaker Platform or not, these solutions can save you and your employees valuable time and money.

Two Solutions: Custom Web Publishing and WebDirect

The FileMaker Platform allows small businesses to connect their databases to their web pages using either Custom Web Publishing or WebDirect. The differences lie in how many simultaneous users you need to accommodate.

WebDirect is for small businesses with up to 500 distinct users needing to access information in their databases at any given time.

Custom Web Publishing can handle thousands of simultaneous users, making it powerful enough to function as a cost-effective enterprise solution at a fraction of the cost.

How Does it Work?

Kyo Logic’s expert developers can write a web page on any web server to display data directly from your Filemaker Pro database onto your company’s website. This “portal” for lack of a better term blends in with your current website perfectly, is easy to use, and can automate and streamline your customer service experience.

If you’re familiar with the Filemaker Platform, you can use WebDirect yourself to create a portal on your website. Once you’ve created your database and programmed it correctly, WebDirect can help you turn your database into a website.

It’s important to have everything programmed correctly for WebDirect to work. Kyo Logic can help ensure your code is clean, you’ve set up security properly, and you’ve considered hosting and reliability before deploying WebDirect.

Custom Web Publishing requires more programming and finesse, so it’s better to hire a consultant to help you create your solution.

Kyo Logic can create customized solutions more swiftly than other consultancies. And for larger systems, we can deliver a solution customized to your needs and requirements in months where others might require years.

Let’s consider a real-world example

Self-Advocacy Association of New York State (SANYS) is a non-profit, grassroots organization serving people with developmental disabilities. They help disabled persons by offering support and training to enable them to become self-sufficient.

SANYS organizes several regional and local seminars for the disabled. They also host a large statewide conference in New York that pulls in significant numbers of registrants. SANYS traditionally captured registration information through paper forms and phone calls.

It was very cumbersome for the volunteers to organize and manage a large number of registrants for these conferences. SANYS came to Kyo Logic for a customized solution to help them control the registration process.

We created a Filemaker solution database to let them capture who’s attending, special meal requirements they may have, emergency contact names and numbers, and what conference they’re signed up for. Here’s an example of registrants for a particular event in SANYS’s database:

The next logical step was to create a web portal so the participants could go to SANYS’s website and register themselves.

Registrants now have a form to fill out their personal information, meal preferences, and other particulars without any human intervention from SANYS.

Automating registration has dramatically decreased the time spent on participant organization and management. This allows SANYS to help more people through education and support than ever before.

 Do you have a business problem the Filemaker Platform could solve?

Most companies have databases containing business critical information like inventory, sales, customers, accounting, products, raw materials, and more. Even if you provide a service, you still have data to be tracked.

Do you get emails from your storefront with orders that need to be filled? A cost-effective web portal can capture the order directly from the shopping cart, send the order to operations for fulfillment, adjust inventory, and capture the charges in your accounting database. All from your website.

If you’re using manual processes to capture the information you need for your business to operate, the Filemaker Platform and Kyo Logic offer a better way. We eliminate the redundancy of manual entry so you and your employees can concentrate on growing your business and increasing revenue.

Contact Kyo Logic at 203.221.3033 today to discuss how to gain control of your business operations using the FileMaker Platform and connecting to your website.

Welcome to the family FileMaker 16!

Welcome FileMaker 16, the newest version of FileMaker is here!  The new release will help make creating custom apps with FileMaker even easier! Let’s walk through all the new features of FileMaker Pro 16, FileMaker Go 16, and FileMaker Server 16. Also, join us May 22nd for a live FileMaker 16 Demo!

New features in the FileMaker 16 Platform:

Mobility:

Animations & Transitions, enhanced signature capture, region-monitoring script, custom paper sizes

Development:

Layout Objects windows, Cards, pdf support in FileMaker Server and FileMaker Webdirect, new Windows OS interface, copy/paste value list, variables in FileMaker data source references, enhanced Data Viewer

 Integration:

Enhanced cURL options, JSON functions, FileMaker Data API, Tableau Web Data Connector for FileMaker, external script steps

 Security:

OAuth 2.0 support for accounts, clickable security lock icons, field-level text encryption 

Scalability:

FileMaker WebDirect scalability

FileMaker 16 Live Demo:

Join us for an exclusive event showcasing the new FileMaker 16 Platform. Discover how the new FileMaker Platform lets you create custom apps that work for your team on iPad, iPhone, Windows, Mac, and the web. See how the new features improve the mobility, development, integration, security, and scalability of your custom apps. Join us for this exciting live event and bring a laptop to try FileMaker 16 for yourself!

Date: May 22nd, 2017
Time: 12 pm to 2 pm
Location: Kyo Logic office, 37 North Ave, Suite 105 Norwalk, CT 06851
Register Here

Need to upgrade to FileMaker 16? Kyo Logic is a certified reseller and can help you upgrade or purchase FileMaker licenses! Call us at 203.221.3033!

FileMaker Go Rated Best App of 2017

FileMaker Go Ranked Top App of 2017

FileMaker Go was ranked one of the best iPad apps of 2017, in a recent article published by PC Magazine. This ranks FileMaker with other productivity products like Microsoft Word, PowerPoint, and Mint.

FileMaker Go

What is FileMaker Go?

FileMaker Go is a FREE app that allows you to connect directly with a FileMaker Pro database. This allows users to can productive no matter where they are.  According to Jeffrey Wilson, Senior Analyst, Software, at PC Magazine “The database program’s excellent design, multiple file layouts, integrated search, digital signature capture, and charting capabilities make it a must-download app for FileMaker users. You still can’t create new files, but FileMaker Go will keep you productive while on the go.”.

With the FileMaker platform, you can easily create customized apps for your business needs. Within a few hours or days, you can build out a customized app to start managing contacts, projects, inventory and much more. The FileMaker Platform comes equipped with the following powerful features:

  • Built-in Reporting
  • Easy integration options
  • Data Security
  • Cloud Hosting
  • Cross-platform capabilities

To learn more about the FileMaker Platform and how to implement the power into your company email Kyo Logic at info@kyologic.com or call 203-221-3033!

Learn More About FileMaker Cloud Hosting!

FileMaker Cloud

Are you looking for a better way to host your FileMaker solution? Do you spend hours trying to manage your current hosting software? Would you like an easy way to host and manage your FileMaker database so you can share all data with all users? Have you heard of FileMaker Cloud but not sure what it is?

If that’s a yes, then join Kyo Logic and Ronnie Rios at this months CT FileMaker Developers Group! Ronnie is the Senior Consulting Engineer at FileMaker and all around FileMaker Guru! On February 15th at 10 am Ronnie will show us the ins and outs of FileMakers newest product, FileMaker Cloud. FileMaker Cloud provides secure and reliable access to all your FileMaker custom apps without the knowledge and admin hassle of traditional hosting!

If you would like to learn more about FileMaker cloud hosting join us February 15th at 10 am! For more information or to register join our meetup, http://meetu.ps/35D9wN or call 203-221-3033!

FileMaker 15 Release Events

Join Kyo Logic at the Apple Store, Westfarms or Boylston Street, for an exclusive FileMaker event showcasing the new FileMaker 15 Platform. Discover how this latest platform provides stronger essentials to make custom business apps that work seamlessly across Mac, iPad, iPhone, Windows, and the web. Learn about the newest features that enhance mobility, integration, security, and performance.

Reserve your spot today; space is limited.

WestFarms:
Date: May 25, 2016
Time: 8:30-10:00 am
Location: Apple Store, Westfarms
Address: 500 Westfarms Mall, Farmington, CT 06032
RSVP:  http://info2.filemaker.com/FM15-Launch-Events.html

Boylston Street:Date: May 24,2016
Time: 8:30-10:00 am
Location: Apple Store, Boylston Street
Address: 815 Boylston Street, Boston MA
RSVP:  http://info2.filemaker.com/FM15-Launch-Events.html