Calculate The Value Of A Field

[getajobnowbiz]

Hi fellows,

 

I am building an app about membership.

 

When members register they get 0 points in default. And they can pay or accomplish some missions to get points. So the members can use points to post something on my website.

 

It is very easy to understand. 

 

I built a form to update the value, however, it is easy to miscalculated if I do it everytime manually.

 

Are there better ways to do this calculation?

 

It is just addition or deduction, just simple calculation.

 

Sam

 

 

[Aurora]

Hello Sam.

 

What type of calculation would you like to have? What is your scenario for it?

 

Aurora

[getajobnowbiz]

Hello Sam.

 

What type of calculation would you like to have? What is your scenario for it?

 

Aurora

 

Hello Sam.

 

What type of calculation would you like to have? What is your scenario for it?

 

Aurora

Hi Aurora

 

Easy to understand. Just addition or deduction.

 

For example, new member Mr. A has 0 marks in default.

 

He can buy 10 marks by paying us, so Mr. A has 10 marks now. (0 + 10)

 

And he can do something by using the marks. For example, he uses 5 marks for that. so Mr.A has 5 marks now. (10 - 5)

 

And we have to do this day by day for recording these transactions and update the current marks they have.

[Aurora]

Hi Sam, 

 

When a User buys marks, do you add it to the table?  Say to " Bought marks" field? 

 

The same with Spent marks? How do you know how many marks he spent? 

 

You could create an Update Form and use Calculation Field with formula [@field:Bought_Marks]-[@field:Spent_Marks]. 

 

You could also create Left_Marks Field, and pass value of the Calculation Field to this field in the table. 

 

Aurora

[getajobnowbiz]

Hi Sam, 

 

When a User buys marks, do you add it to the table?  Say to " Bought marks" field? 

 

The same with Spent marks? How do you know how many marks he spent? 

 

You could create an Update Form and use Calculation Field with formula [@field:Bought_Marks]-[@field:Spent_Marks]. 

 

You could also create Left_Marks Field, and pass value of the Calculation Field to this field in the table. 

 

Aurora

Good Idea

 

Aurora! 

 

You inspired me

[Mada560132]

Hello Aurora,

 

I am very new to it but feel as though i have come up against an issue in this area.

I am creating an app which inputs purchase orders and refers to an inventory table for the details (ie price per item etc).

Some time in the future the price of the item might change (say 6 months) but we do not want the value of the old orders to change when reporting is done etc (ie showing all purchases by a customer over the last 12 months).

 

How do I handle this ?

 

Regards,

Adam