0

Really dumb .... just want to add 2 number fields together and display total in a 3rd field.

I must be an incomplete moron but I've been struggling to create a very simple database that sums two number entry fields and displays the total in another field. 
I've tried multiple ways but apparently am too stupid to enter the right formula to do this. 
Can anyone help this old retired nimcompoop get this done? 
Much appreciated!

Gary

9 replies

null
    • Fred
    • 1 yr ago
    • Reported - view

    Is your third field a formula field?

    If it is then you can do something like:

    field1name + field2name

    If it is number field then you can put this in Trigger after update of field2, or in field1 or in a button.

    field3name := field1name + field2name

    If those don’t work then please post the fieldnames and type of the three fields.

      • biogendron
      • 1 yr ago
      • Reported - view

       

      Fred, you must of answered while I was typing my last entry. Thanks I'll see if your suggestion works.

      thanks

      • biogendron
      • 1 yr ago
      • Reported - view

       

      I tried formula fields and number fields. All I want to do is add (number field #1) and (number field #2) together to propagate the 3rd field as a total amount. Seems absurdly simple but all the combinations of entries I've tried don't work.

      • biogendron
      • 1 yr ago
      • Reported - view

       

      Well through trying various different ways, I finally got the two field amounts to add together. Only problem now is the field column doesn't show on the main display page. It only can be seen as you are entering the data into fields. 
      Any ideas?

    • biogendron
    • 1 yr ago
    • Reported - view

    Thanks everyone.... thought someone would help but....

    One of the issues I'm experiencing is the fact that the program doesn't seem to be working right. Case in point the database I created doesn't let me add additional fields that show up when viewing the entires. If I delete database and start all over, then I can add whatever fields I want but after adding data into fields, I cannot add any additional fields. They show up in the entry tab but field doesn't show up in the main view. Think it's buggy.

    • Fred
    • 1 yr ago
    • Reported - view
     said:
    I finally got the two field amounts to add together. Only problem now is the field column doesn't show on the main display page. It only can be seen as you are entering the data into fields.  Any ideas?

     Just add the new field to the table view, by clicking on one of the columns and then click on Show column.

      • biogendron
      • 1 yr ago
      • Reported - view

       

      I don't know how I stumbled on it but that's exactly what I did. Everything is right with world now. I find this Ninox so hard to use. I used debase+ in its many versions and created many complicated and complex databases. I feel like a child trying to learn Chinese. 
      However thank you for helping out. Apparently all I had to do was simplify my expressions. 
       

      • Fred
      • 1 yr ago
      • Reported - view

      If you are satisfied with the answers, please mark this post answered when you get a chance.

    • Mel_Charles
    • 1 yr ago
    • Reported - view

    P.s There is nothing dumb about this question.

    To state a saying "We don't know what we err don't know"

    Ninox has a learning curve. Once you become familiar with the syntax or idiosyncrasies of how it is put together then day slowly dawns !!!

    One day Ninox will produce big book to help us all - You know just like the Microsoft Access Bible or similar ! 😁

Login to reply

Content aside

  • Status Answered
  • 1 yr agoLast active
  • 9Replies
  • 119Views
  • 4 Following