Add Data Format Section to User Manual
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.
3 replies
-
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.
Best, Jörg
-
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:
https://ninoxdb.de/en/manual/tables/data-field-typesNote that "%" (as "$" or "€") are just labels stitched to the number field.
Birger
Content aside
- 6 yrs agoLast active
- 3Replies
- 2371Views