0

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.

3replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
    • Support
    • Support
    • 4 yrs ago
    • Reported - view

    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

    Like
  • 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.

    Like
    • Birger H
    • Birger_H
    • 4 yrs ago
    • Reported - view

    Here is a list of the available field types:
    https://ninoxdb.de/en/manual/tables/data-field-types

    Note that "%" (as "$" or "€") are just labels stitched to the number field.

    Birger

    Like
Like Follow
  • 4 yrs agoLast active
  • 3Replies
  • 2351Views