VOLUME LIX                 11/10/2020

Client Showcase

Wallace Cameron International is a leader in first aid products and medical supplies throughout the United Kingdom. And when WCI got sick of conducting audits and processing customer orders by hand, they turned to Ninox to help them improve their technological health.

The bespoke CRM solution provided by Nioxus enables Wallace Cameron field representatives to manage their entire inventory in real time and also conduct client audits and sales operations in their fully-integrated Ninox solution.

The Activity Management function (above) allows WCI personnel to keep track of every phone call, email, meeting and transaction. And the automated follow-up scheduler makes certain that each user’s To-Do list is current and accurate.

At the same time, the integrated online Audit & Compliance functions (below) allow field personnel to conduct up to four audits on a single form reducing processing time by 75% and eliminating 100% of the paper that everyone used to have to shuffle.

And when the bespoke customer Quote and Order Invoicing and document management function is added in, this medical manufacturing giant has a much healthier operating procedure that’s easier to learn, faster to operate and much more efficient both in the field and in the corporate office.

“I now have a system where, for the very first time, I can record all of my customer’s details while keeping track of my visits, audits, quotes and order details.

I can not thank Ninox and the team at Nioxus enough for producing a first-rate system that is so flexible and adaptable.”

-Anthony A., Wallace Cameron International


Reports Plus replaces the standard reporting and data visualization engines built into the Ninox database platform. Now – you can combine the power and ease-of-use of Ninox with the flexibility and robust feature set of a world-class data analytics, business intelligence and charting engine. 

Sign up for our next Learning Lab to learn more about ReportsPLUS, Nioxus’ newest reporting solution.


Clearing the Table

We’re often asked, “how do I get rid of blank records in my tables?” The answer is simple… Create a code block in the Trigger After Open section of the Options Screen. In that block, for each table that needs to be cleaned, write a line of code as follows: 

delete(select(‘Table Name’ where ‘Field Name1’ = null and ‘Field NameN’ = null))

In the code line, replace ‘Table Name’ with the name(s) of the table(s) you wish to clean and then replace each ‘Field Name’ with the fields that should never be blank in a valid record. Since this code block is in the Trigger After Open section, it will run automatically when you fire up the database and this will ensure that your tables remain clean and free of blank records.

Nioxus Today

By Amelia Neighbors, GM Global Operations

Another crazy week here at Nioxus! We have lots going on – supporting Ninox and building solutions, hosting webinars and uploading new content online – what a month, and it’s only just beginning!

Last week, we had a bunch of new Ninox developers, a couple who presented their questions live with the group – and lots of interaction among the audience. These Ninox University Learning Lab webinars – free on Thursdays – are getting lively! And sometimes that’s a good thing.

Well there’s just too much work to do right now to stop and say much – just that we hope you continue to read our newsletter, come to the learning lab, use the templates and ask questions via unlimited service desk tickets. The Nioxus elves are hard at working making miracles – and awesome software – so stay tuned for some very cool treats this month!

This Week in the Learning Lab

Come join us for our weekly Learning Lab! This week we’ll be hosting more open Q&A!  This upcoming Learning Lab will be Thursday, 11/12/20, at 12:00pm EDT! Register below!

Did you know that Nioxus has built over 125 templates which are available to all Nioxus customers – Standard, Deluxe and Premier?

Gold Star Program

By Jim Harris, The Stargazer

I am temporarily taking the wizard robe off (clothes still on) and just being Jim. 

I would like to ask our members and especially those who also go to the Learning Lab, what part of Nioxus is helping you as you learn (or have learned) how to use the Ninox Database application? Have the classes on Thursdays helped you as you begin to work on your individual masterpieces? Or is it the Learning Lab videos on You Tube? Please let me know how we are doing. The more feedback, the better we can serve you. Come on friends, don’t be shy. I and the rest of the Nioxus team won’t bite (much). 

I have a great job at Nioxus and on Thursdays as Andy is trying to teach the world of Ninox to you and Amelia tries to keep Andy from giving out all those Gold Stars and at the same time keeping track of questions, I get to joke along and have a laugh and yes, sometime give those precious Gold Stars. 

As I continue to work on the Gold Star Project, and I am not getting much input, maybe the question should be – What would it take to tell us just what do you want as per the Bling? Tees , Polos, Mugs, are probably be the standard but what if we also had something like the face masks, thermos-type mugs, or…?

This is your time to let us know what you would like to purchase (and possibly earn for free with enough Stars). Time is running out , so if you have an idea, please let me know. Until next week!

Jim the Stargazer


Radio Buttons: A Selective Choice For Choosing

By Jennifer Neighbors, Senior Consultant

I’ve noticed that, for some reason, few people choose radio buttons when selecting a style for their choice fields. I like radio buttons, however, and I use them whenever I think the situation is right. The main reason few people like to use them, I think, is because they take up so much vertical space on the screen, creating the dreaded “empty space” issue for what goes next to them. Let’s take a look:

See the space behind the red arrow in this illustration? That’s the empty space next to the radio buttons that can’t be used. However, in this example, the radio buttons work because this isn’t a data entry screen where blank space would be a bad thing. Instead, it’s a form that allows user to filter results in a View. I like the radio buttons here because the user can see all the choices for Fruit at all times. Also, all people intuitively understand how to make the choice they want by clicking the button next to their selection. And, it also works well here because there are only four choices for fruit. If the user is to be presented with, say, ten choices, then obviously radio buttons would take up too much vertical space. Let’s look at another situation that works well with radio buttons:

This example shows a multi-line text box next to radio buttons and I really like how well it uses the available space. I was able to narrow the width of the text box to just the right amount to get it snug up against the radio buttons on the same horizontal plane and it looks really good. Keep in mind that radio buttons aren’t just for choice fields. They work equally well for multiple choice fields, as well, and I want to point out something interesting about that. Here’s a similar scenario to that shown above:

Notice anything different? If you look closely, you will see that the radio buttons in this illustration are more square than round. And selecting choices here results in a checkmark rather than a circle inside the buttons. This is great, because it signals at a glance to the discerning user that this is a multiple choice type of radio button. If you have a lot of choices and you still want to use radio buttons, there is another method you can use. Take a look at this choice field with eight options to pick from:

To get this effect, create your choice field in the usual way and then resize it so that its width exceeds its height. Your selections will stretch across the screen. Note that in this example there is no empty space – only selections for the user to make. And finally, here’s a variant of the same idea:

In the example shown above, I have placed a sizable type of field on each side of my radio button field: an image field on the left and a formula field on the right. (In this instance, the formula simply displays some text.) I was careful to make both of these fields about the same height as my choice field; all three fields fit nicely together in this scenario with no wasted space. Check out the possibilities for radio buttons next time you design a form and you, like me, may end up using them more often as time goes on.

Copyright 2020 © All Rights Reserved.

All logos, trademarks and names are the protected property of Nioxus Corporation or their respective owners.

“Ninox,” “Ninox Database” and the blue Ninox owl eye logo are the property of Ninox Berlin and are used with permission.