Field calculations

[Vaughn Clement]

Hi All

You would think that I should have done it much like your examples, but
there are wrong ways and right ways and without any examples I was getting
nowhere. I will use your approach and see if it works.

Thank you for taking the time to help me...

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


On Wed, Sep 11, 2013 at 11:10 AM, Jim MacConnell <jmac at consensustech.com>wrote:

> 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
>
>
> _______________________________________________
> 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
>