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