How to calculate this simple total amount?

HCL Domino Domino Forum
1

Hi ,I have this simple question, but I just can not figure it out now.

I have three number fields, let’s say: amount1,amount2,amount3, they are editable and number.

I also have another field call TotalAmount, Computed and number, this field will be equals the total of above 3 fields.

so it will be like this: TotalAmount = amount1+amount2+amount3.

when user finished entering the number on amount3 field, the TotalAmount will be automaticaly calculate the total.

the problem is I have to press the F9 key to refresh the computed field (TotalAmount), how to make it automaticaly display the total? I know I can add the refresh code on the exit event of amount3 field, but it will be happened when user click the outside of amount3 field.

Anybody know any other easy way?

Thanks a lot for any help,

2

Subject: How to calculate this simple total amount?

I’ve tried using the exiting event but this isn’t any good if you don’t have any fields after the third amount.

I’ve either added a “calc” button or opened a pop-up dialog box to enter the amounts and then populate the form after they’ve entered the information.

If someone does have a better way, I too would love to hear it.

3

Subject: RE: How to calculate this simple total amount?

Hi Stephen,Thanks a lot for the help,

Basically, these 3 fields are as this:

amount1: user enter the invoice amount,

amount2:user enter the GST of tax(federal government tax)

amount3:user enter the PST of tax(provincial tax)

ToalAmount: will be the computed field, it equals amount1+amount2+amount3

so it is so simple, I just do not want to create extra steps for user data entry, creating popup window probably will be working(make the totalamount field refreshed), but I just do not want the extra step for this kinds of simple calculation.

anybody have any good solutions, please help here,thanks a lot,

4

Subject: RE: How to calculate this simple total amount?

well…why dont you HIDE the total field till fields one two and three are filled in…

then the total would only show after the data was entered

i think this will work again set the refresh fields …

or show a fake brakets image and swap it out with the total using hide whens after the third value is entered.

5

Subject: How to calculate this simple total amount?

Ope Form, Choose Porperties, first tab, make sure “Automatically Refresh Fields” is set.

6

Subject: RE: How to calculate this simple total amount?

Hi April,Thanks a lot for the help,

that works if I have another field located under the TotalAmount field and when I move the cursor to this new field, yes, the TotalAmount field will be updated. but the thing is I do not have any field under the TotalAmount field, the TotalAmount field is the last field on that form, its location can not be changed, so that means “Automatically Refresh Fields” is not working for this case.

Any other thoughts?

7

Subject: How to calculate this simple total amount?

Peter,

There are many ways, but none are without flaws.

You can set auto-refresh, but that has many drawbacks in terms of performance.

You can put a little button next to TOTAL that says, “Click here to refresh Total”.

You can put your number fields into a popup box and when the user finishes entering their numbers and hits ok then it does the totaling.

just some thoughts,

raphael

8

Subject: RE: How to calculate this simple total amount?

Hi Raphael,Thanks a lot for your thoughts,

But I just do not want these extra steps to do this simple calculation. as this is the very simple and common way on any programming language, there should be some ways to achieve this.

Does anybody have any other ideas to do this?

Thanks a lot for any help,