Field calculations

[Jim MacConnell]

Ooooo. One I can help with.

Simplest approach: 
Put a script similar to this in a button:    
put field "Field 1" + field "Field 2" into field "Field 3
or
put field "Loan Percentage" * field "Loan Amount" into field "Interest"

A little cooler:
Set the script of "Field 1" and "Field 2" to the following and then when an
entry is changed it will automatically update
on closeField
    put field "Field 1" + field "Field 2" into field "Field 3"
end closeField

More generally create a script to do all the math and call it from the
fields. That way everything will always be current.

Jim


-----Original Message-----
From: Vaughn Clement [mailto:vclement at gmail.com] 
Sent: Wednesday, September 11, 2013 10:26 AM
To: How to use LiveCode
Subject: Field calculations

Hi All

After entirely to many hours of research trying to get a reference location
for scripting simple field calculations, and also testing scripts I need
some veteran help.

I am a database developer so I am new to LiveCode. I used the dictionary
trying to do the following but the Hypertalk script approach is not clear.

I simply want to take one field and use a math operator to say add two
fields together and put the result into a third field.

Example: Loan amount + loan fees = Sum amount of loan

I might want to add 3 fields together and then subtract a different field
from the sum of the 3 fields.

Or take a loan percentage * the Loan amount to get the amount of interest

Thank you

Vaughn Clement

Apps by Vaughn Clement (Support)
*http://www.appsbyvaughnclement.com/tools/home-page/*
Skype: vaughn.clement
https://secure.join.me/appsbyvclement
FaceTime: vclement at gmail.com
LogMeIn also avaialble
Call on "ooVoo" at address:  vaughnclement or 9282549062
Ph. 928-254-9062
Cloud Hosting Registration Web Site:
https://my.oditech.com/cart.php?a=add&pid=41
_______________________________________________
use-livecode mailing list
use-livecode at lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode