• 0

# Calculate The Value Of A Field

## Question

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

## Recommended Posts

• 0

Hello Sam.

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

Aurora

##### Share on other sites

• 0

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.

##### Share on other sites

• 0

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

##### Share on other sites

• 0

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

##### Share on other sites

• 0

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,

## Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

×   Pasted as rich text.   Paste as plain text instead

Only 75 emoji are allowed.