0

Ninox forgetting entries

Hello Forum.

I am a new user. I have setup a databass that works pretty well but I have noticed that from time to time, Ninox forgets entries within records. Just recently, I have two records where I keep checking check box entries that perform a simple calculation to add some values. All is fine until I leave the record and then go back in and the check marks and values are missing.

The form entries in question consist of sets of check boxes derived from separate child databases. 

I have seen something similar before but overlooked it thinking the mistake was mine. Now I am concerned because I see that there are quite a few records which now have missing information. In some cases, these are not check box entries but other types of field.

I use the database via the cloud and access it from a computer and an ipad. In case there was some confusion with two machines accessing data at the same time, I have closed the software on one machine but the problem continues.

I would be interested to learn if anyone else has experienced this issue and hopefully let me know how I can address the problem. Obviously, if the sofware has a bug that makes it unreliable, this is very problematic.

Thank you,

Nick

8 replies

null
    • Fred
    • 4 mths ago
    • Reported - view

    Are you in the cloud or local storage?

    I notice that in the cloud you can not check/uncheck dynamic multiple choice fields quickly. It takes the browser a second to register the click. Next time watch the cloud icon next to the DB name when you check/uncheck. It is syncing with the server. So if you try to check/uncheck during this time it will not remember it.

    • nicholas_hartell
    • 4 mths ago
    • Reported - view

    Hello,

    I am in the cloud. I can see the cloud icon updating within a second or two of checking the box but even though the update has registered, when I go to another record and then back to the first, the information is gone. This seems very worrying if a database is losing data.

    • John_Halls
    • 4 mths ago
    • Reported - view

    Hi Nick. It would be unusual if Ninox weren’t saving data correctly. The forum would be swamped with queries on the subject. Can you post a sample of your system? Or a screenshot?

    thanks John

    • Ninox partner
    • RoSoft_Steven.1
    • 4 mths ago
    • Reported - view

    Maybe the setting Binding is not correct of that field?

      • John_Halls
      • 4 mths ago
      • Reported - view

      That crossed my mind too. Seems the obvious one to look at. 

      • nicholas_hartell
      • 4 mths ago
      • Reported - view

       i am not sure what the Binding setting is or how to check it. I looked it up online and only found a reference to a post by you saying it existed but I didn't find out what it was or how it might relate to my database.

       

      If I go back and look at past records in my database, quite a few have lost the information set via two sets of check boxes which sum an amount which is the total for an invoice I generate. It is a cost for a service performed and some guitar strings purchase. However, whereas as some have lost the information, other records are fine. Below is an example of a record. I haven't shown it all as it has personal information in it but you can see two check box lists that I have checked and the cost for those services/parts are added together to make a total charge. This should be reflected in the second image which is the list view of records. You can see that some of them have zeros and those records have forgotted the information provided but the others have not. Rows 40 and 41 are persistent problems as I have gone back and forth updating the values for each and when I change one, the other forgets. There are some similarities between these records as they are for the same client but that should not make a difference because each record must have its own unique ID regardless of customer ID derived from a separate database (Client Details Brief).

      This is puzzling and I would like to get to the bottom of the problem because although I print a copy of the invoice and so have a record elsewhere, the amounts that I would eventually like to use to keep track of income etc are now of no use at all if some of the values are missing.

    • John_Halls
    • 4 mths ago
    • Reported - view

    Thanks for your reply. It’s not binding. Can you show how the Work Job is connected to Client Detail Brief. How are the Job Charges calculated? Thanks John

      • nicholas_hartell
      • 4 mths ago
      • Reported - view

       Hello John. Thanks for your replies.

      The calculation is this:

      sum('Job Charges' + 'String Charges' + 'Parts/Supplemental Charges' + 'Labour Charge' -
          'Optional Discount')

      This sits inside a formula field called total charge.

      Below is a screenshot showing the relationship betwen work job which is the parent database and client details brief which is a list of clients and their contact details.

Login to reply

Content aside

  • 4 mths agoLast active
  • 8Replies
  • 62Views
  • 4 Following