VOLUME LVII 10/27/2020
When the International Cycling Federation needed new technology for their 2019 World Championships, they turned to Nioxus. With less than two months to go, the stadium announcer for the Championships in Pruszków, Poland needed a way to track hundreds of athletes and thousands of event results in order to be able to provide live commentary inside the BGZ Velodrome. The Nioxus team quickly designed a wagon-wheel architecture that enabled system users to access race results from anywhere in the world in mere seconds.
The Event Dashboard made it easy for system operators to review results from every event over the last eight years while the Athlete Management screen provided important information that was shared in real-time with the thousands of spectators in the arena.
Not only did the system need to report on individual riders, but entire national teams also had to be tracked for the multi-rider events. The Event Summary was the perfect solution for drilling down into the details of all the Olympic and World-Championship events over the past decade.
And the new Ninox Kanban view was perfect for creating the International Scorecard which summarized thousands of records instantly and accurately.
According to Anthony Cooper, the in-stadium announcer:
“The Nioxus application allowed me to instantly search for a rider’s past results in international competitions which I was then able to share with the crowd. In past events, I had relied on hand-written notes and my memory, but this time, it was immediate and accurate. The Nioxus solution was a tremendous help during the event. Thanks, Nioxus!”
Proving once and for all that building Ninox
solutions are truly, as easy as riding a bike.
End the frustration of losing time tracking down a misfiled document. eFileCabinet is a centralized solution for all your documents, making it simple to locate any file thanks to its intelligent organization and intuitive interface. It’s all of your documents at your fingertips no matter where you are.
Do As Server – Chapter 2
By David Gyenes, Senior Consultant
Now you see that a date has a time as well, it is just not visible in the UI of Ninox. When you pick a date in a Date field it defaults to 12:00 AM, LOCAL TIME.
Grab That Data!
By Jennifer Neighbors, Senior Consultant
Ever need a piece of information you stored in another table? It’s fast and easy to grab it if you
remember a simple phrase: “select [table where data is stored].[data field]”. Once you
memorize this phrase, you’ll use it over and over because it comes in so handy. Say you want to
insert a company telephone number onto a form like an invoice or payment receipt. Don’t
“hard code” it. Store it once in a table of company information (“Utilities”). When you want to
place it on your form, use the following formula:
Now when your company changes its primary telephone number, they can enter the new
number in their Utilities table and their forms will automatically be updated!
Deadlines in the Calendar
By Adam Davidson, Senior Developer
Events marked as a deadline in the Calendar are treated a bit differently from other events. Here are some tips and info to help you use the Calendar to manage deadlines:
Nioxus continues to be busy during the final days of October – can you believe it is almost November?!? Last week, in the Ninox University Learning Lab on Thursday, we had an engaging question and answer webinar that took over two hours! That was fun – and challenging – but we are going to try to keep 90 minutes or so going forward. We strive to answer all the questions the global Ninox community would like to discuss each week, and this week we realized just how many questions people had! We may end up having every other week just be answering Ninox questions live, which gives great insight into what are hot topics or popular subjects.
We continue to seek feedback on how we can improve the Ninox User’s Manual and our templates and materials on Nioxus.com – we continue to provide individual support for clients whether it is a large project to build a specific business solution, or a single hour of one on one assistance to address a stuck development question.
Even more exciting is the big release of our new Report tool – Ninox ReportsPLUS by Nioxus – which will be coming soon. Beta users are helping us ensure a smooth experience and helping to identify improvements to the user interface- and ideas about desired new features.
This is very exciting and we are proud to be able to provide such amazing and powerful tools for business intelligence and data visualization.
CalendarPLUS continues to gain widespread appeal among customers that maintain schedules and need to print different calendar views. Rich text and color blocking is coming soon.
For now, happy fall and let us know how we can help address your needs.
Most database applications feature a table containing data about the “central actor” that is the focus of the solution. It may be a table of vendors, customers, students or patients but it’s always at the core of the application. And then there are all the “other” people who need to be tracked; people like teachers, doctors, lawyers, consultants, plumbers and painters… the list goes on and on.
A mistake that a lot of database developers make is that they create a separate table for each category of “other” people. For example, consider a Hospital ERP system. The central actors in the system are ‘Patients’ and ‘Care Providers’, but then there are all the other people who are part of the hospital eco-system… security personnel, cooks, administrators, records clerks and, of course, volunteers.
Since each of these “others” have the same characteristics and, therefore, the same data fields – First Name, Last Name, Start Date, Job Title, etc. – put them all in the same table. Then add a choice field to the table which defines each person’s position. In this example, the choices would be “Security”, “Cafeteria”, “Admin”, “Maintenance”, and “Volunteer”. Then, when it’s time to popup a list of “others” at runtime, you can constrain the records in the selection list by using the Choice field as the constraint.
By consolidating all of the “others” into a single table, you end up with a more efficient database that is properly normalized and designed for maximum efficiency when it comes to operation, reporting, data analysis and performance.
Our topic for this week’s Leaning Lab will be ‘Time Cards and Payroll- Managing Employees Work Hours and Paychecks with Ninox’, and will be on 10/29/20 at 12:00pm EDT. Sign up below!
Template will be released 24 hours before the Learning Lab.
Did you know that Nioxus has built over 120 templates which are available to all Nioxus customers – Standard, Deluxe and Premier?
– Jim (a.k.a. The Starmaster)