Wrapping up 2017 with a simple but powerful tip for Nitro Query grid apps... Very often lists of business data include columns that can be classified as boolean, with text representing values of yes/no, true/false, 1/0, etc. When you're creating a Nitro Query grid app that includes such columns, you can make "truthy" values stand out much more clearly by replacing the column text with a visual checkmark.
One of the most powerful widgets available in Nitro Query is the Edit Grid. Traditionally queries are read-only, but with an Edit Grid you can actually allow users to update records in a single-file data source — right from within the query itself! In some cases you may find you can simply create a query for data entry in lieu of coding an actual app, saving yourself a ton of time and effort.