VOLUME LXXXVII              06/16/2021

How to Evaluate Multi Choice Fields

By David Gyenes, Director of IT

Many people are still struggling with multi-choice type fields. We have already seen examples on how to define the choices, how to add a selection to a multiple-choice field and how to remove a choice. However, we have not discussed how to check a value if it is part of the selected choices or not. There are two ways to check selected values but only one of them has the option to test the selection as follows:

numbers(‘Multi Choice Field’)


chosen(‘Multi-Choice Field’)

To simply evaluate the result, we would need to use the chosen() function. We can apply a second parameter to the syntax. Let’s examine how it looks generally:

chosen(‘Multi-Choice Field’, EVALUATION HERE)

This evaluation can be a number, array of numbers or a text string. When we talk about a number it refers to the ID of the choice. If we want to check for text, we must refer to one string. Here are the examples for that:

chosen(‘Multi-Choice Field’, 1)

(Is the first option chosen?)

chosen(‘Multi-Choice Field’, [1,2])

(Are the first two options chosen?)

chosen(‘Multi-Choice Field’, “text here”)

(Is the “text here” option chosen?)

What we are getting as a result is a YES (true) or NO (false) if it is matching or not. The single ID number and the text are straight forward, but the number array requires a little explanation. When we want to know if multiple values are included in the selection; the formula would check if every value would be part of the original selection. It is an “and” condition, not an “or”. If one number is not part of it, then the result would be NO (false). This would complete all the possible functions surrounding the MC fields.


New Progress Thermometer Template now available in the Membership Portal

Adding an animated progress thermometer to your Ninox database solution will add an informative and visually appealing dimension to your application. Users will now know exactly how much of a process has been completed and how much remains via any one of the six different progress alerts demonstrated in this template.

This is our 132nd template in the portal and there are many more Ninox learning tools available there. You will be able to download all our templates with a Standard, Premium or Deluxe membership.

And be sure to refer back to our Learning Lab video on progress thermometers, which you can access in the Webinar Video Vault in the membership portal.

Office 365 Integration and Team Collaboration Coming Soon to DocumentsPLUS!

This Week in the Learning Lab

Don’t forget to join us this Thursday the 17th at 12pm EDT for another open Q&A session. Be sure to bring us lots of questions!

Check Out Our Templates

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

Nioxus University YouTube Channel

Nioxus has created nearly 100 videos and over 200 hours of content teaching you how to use and optimize Ninox, as well as our supplementary products: CalendarPLUS, ReportsPLUS and DocumentsPLUS!

Top Technology Trends, Treasures and Triumphs

SpaceX vs. China: The Quest for Satellite Internet

Click images to zoom in

SpaceX has more than 1,000 satellites (called Starlink) beaming high-speed internet to Earth, but China promises to offer higher speeds with the launch of what it calls the world’s first 6G satellite which they say would provide faster service than what is available on Earth.

The satellite internet market is expected to be worth more than $400 billion by 2040. Namrata Goswami who is an independent researcher and has been studying global space policy for over 20 years says, “It’s first come, first serve. So, they are racing to occupy those orbital slots, because the ones that get there first, with the capability of presence, are going to be able to set the rules.”

 SpaceX is moving ahead with a larger fleet of satellites and China is betting on faster speeds to build a powerful internet network in space. The competition is taking place in an area known as Low Earth orbit.

It may have crossed your minds that there might be a security risk because with big networks of satellites you also could have a huge generation of personal data. Many believe that Starlink’s satellites are crowding orbit and endangering other satellites. The company’s ongoing launches of thousands of satellites for global high-speed Internet service may clash with preexisting environmental regulations as well. China could also face similar push-back from rivals since it also plans to launch more than 10,000 satellites.

SpaceX is moving ahead anyway by seeking permission for another 30,000 satellites. But China’s network could have one more advantage when it’s ready according to Namrata Goswami, “China can always make it mandatory for its citizens to have that kind of service in its devices.”

Just Jim

By Jim Harris, Stargazer

What a week!

The last two months of attendance at the Learning Lab has been awesome. Each week, we love to see who is new and who is a “regular” (aka Devoted Fan).

Last week, it was brought to our attention that one of our many devoted fans attended the Learning Lab right from the very beginning. That is true dedication and love! We are very excited that we have hit the 400th attendee mark. Thanks to all the attendees that have made this possible!

Remember, it is not just the Learning Lab where you can learn to use Ninox. We also have over 200 downloads in the member portal and Nioxus has spent hours and hours creating Ninox learning tools so that you can easily improve the efficiency of your databases.

Don’t forget to join us at the Learning Lab on June 17th at 12:00pm ET
This week is open Q&A! Please send in your questions early.


Weekly Comic

Copyright 2021 © 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.