VOLUME XCV             08/26/2021

Bulk Operations

Databasics

Do you like making repetitive changes to “every” record in your database? Yeah, neither do we. We’re in luck because Ninox has given us a very powerful tool when it comes to making updates to multiple records. It’s called (as you would imagine), Updating Multiple Records and it’s located in menu accessed via the gear icon at the top of the table view page.

And while this tool lets you make massive updates to your database, which is amazing, there are some really great features that take it to the next level. First, there are there 4 ways to update each field individually as demonstrated below:

These options allow you to control what exactly is updated; from a static value to a calculated value and even removing any existing value from that one field. You have control over which fields are updated and how they are updated.The second great thing that Ninox can do is allow you to control what records in the table are updated by selecting one of the two update options that are accessed via the popup menu at the bottom, left-hand corner of the table view screen.

This feature is key in updating a select group of records, instead of the whole table. Update SelectedRecords gives you the opportunity to make a selection (an Array) of specific records within the table – just click on the record to select! The Update Visible Records does exactly that – it updates every record that is “visible” in your table. Now this one can get a little tricky. If you open a table and have no filters set, then every record in that table will be updated. However, if you go in and add a filter so you only see a subset of your data, then those are the records that will be updated.So, whether you’ve added a new field that requires content or you are making widescale changes to the information in your database, the Update Multiple Records functionality will make it easy as pie. And after all… Who doesn’t like pie!

DocumentPLUS upgrade now available including Office 365 Integration and Team Collaboration

Learning Lab

Be sure to visit us this Thursday at 12:00pm ET or 6:00pm CET for the Learning Lab! This week we’ll be doing an open Q&A so bring your questions so you can earn some gold stars!

Gold stars can be redeemed at the end of the year for prizes, so try and earn as many stars as you can! For more information about the Gold Star Program, click here.

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!

Let's Get Stylized

Databasics

Using the styled() function is a great way to add pop & pizzaz to your database.

The styled() function takes up to 3 elements – styled(text, color, icon).

Text: This element can be hardcoded or any text field. This is the only required field for the styled() function.

Color: Indicates what color the formula field will be. You can use a hex number, or a simple statement of “red”.

Icon: The icon you want to show.

So if you want your text to be orange and have a warning the formula would look like this:

styled(“This is a Warning”, “orange”, “warn”)

And this is what you would get:

CLICK IMAGE TO ENGLARGE

Predictive / Scheduled Maintenance

Template of the Week

If you use equipment, then you have to maintain it. And it’s a lot cheaper to perform scheduled routine maintenance than it is to repair things after they’ve broken down. But how do you know when it’s time for the next service call? Easy – You use this template to make sure that every machine, truck, copier, and tractor (and whatever else you need to maintain) is always up-to-date with the scheduled repairs.

This template translates miles and hours and any other measure of usage into calendar schedules for routine service and maintenance.

Check it out in the Nioxus Member Portal today.

Code Annotations and Embedded Formula Comments

Databasics

This week’s tech tip is as valuable as it is simple.  As your formulas become more and more complex and the number of lines in your programs increases, you will find it useful to embed comments inside the code itself.  This will enable you to better understand your syntax and automated processes when it’s time to return to your code for enhancement, testing and debugging.

To embed comments and annotations inside of your code, simply enclose the entire text string in double quotation marks (example: “Date of Last Code Update: Jan 21, 2021”).

Recommended uses of this code documenting technique include describing the use of variables, explaining the purpose of loops and decision structures and indicating where a specific section of code begins and ends.  An example of the annotated code is displayed below in red

The comments in lines 2, 10, 19 and 26 above describe the code blocks in the lines that follow while the first and last lines (1 and 34 respectively) describe the purpose of the entire code block when it was last updated.  The embedded carriage returns at lines 8, 17, 24, and 32 are there to make it easier to see where one sub-process ends and the next begins.  Annotating your code as you write it will make it easier to leverage, test and share your code across large databases and with other members of your Ninox team.

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.

en_USEN