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: vclem...@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 <j...@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:vclem...@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: vclem...@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@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@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@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode