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?
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.
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.
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.
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 !
- Status Answered
- 2 mths agoLast active