I would like to see a section in the user manual that explains the detailed format of the data for each type of field. This has been the biggest hurdle to using Ninox. I have to create test cases and use trial and error to figure out how to evaluate different expressions.
Hi, there is already a chapter in the User manual: https://ninoxdb.de/en/manual/tables/data-field-types, for newer field types you are invited to a look into our "What's new" section:https://ninoxdb.de/en/whatsnew.
If you still miss something, please let us know.
I've seen this information. However, I'm trying to understand the exact underlying format that Ninox is using for each field type. For example, what is the exact format of a "Choice" or "Multiple Choice" field? Is it a number, or text, or something else? For example, when trying to do a compare to a "Multiple Choice" field, how do you handle one or more of multiple possible values?
I'm trying to have a exact understanding of how to compare and manipulate data within fields. Without an exact understanding of what the underlying data type is, this becomes a guessing game. Really, what I'm referring to is a detailed programming section. For example, it took me a very long time before I realized that you need to use ":=" to assign a value, as opposed to "=". This is especially important, since some of the value and formula/programming conventions you use are not typical. For example, if you format a cell as a percentage, it should be that. But it is actually 100 * the percentage. For example, 10% would actually be 0.1. But in Ninox, 10% is actually 10. Little things like this can cause all kinds of issues, if it is not stated clearly somewhere.
Here is a list of the available field types:
Note that "%" (as "$" or "€") are just labels stitched to the number field.