Jump to content
  • 0

Calculate The Value Of A Field


getajobnowbiz
 Share

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

 

 

Link to comment
Share on other sites

5 answers to this question

Recommended Posts

  • 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. :)

Link to comment
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

Link to comment
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 :)

Link to comment
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,

Adam

Link to comment
Share on other sites

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.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
 Share

×
×
  • Create New...