Then I want to take any number entered into the remaining six fields ( some fields might not be entered into) and subtract that from the balance if there is something entered into them...that works great!
So you can get the running total that you want? let me know if this is not the case.
A button can run a script to clear all the fields in the current record:
Set field [ YourTable::TransferedDays ; "" ]
Set field [ YourTable::sickT ; "" ]
Set field [ YourTable::sickE ; "" ]
Set field [ YourTable::LapseE ; "" ]
Set field [ YourTable::PersonalT ; "" ]
Set field [ YourTable::Absent ; "" ]
Set field [ YourTable::Jury ; "" ]
Note: When Setting up Set Field, there are two Specify buttons that must be clicked. To get Set Field [Table::Field ; Expression], add set field to your script and click the first button (specify target field). Select Table::Field from the list of fields. Do not click the specify button next to the repetition box. Click OK to close this dialog box. Now click the lower specify button (calculated result) and create the expression to the right of the semicolon (;). Do not try to type in the semicolon.
No i cannot get a running total, Scratch this part - that works great!
Define a calculation field cBal as
TransferedDays- sickT - sickE - LapseE - PersonalT - Absent - Jury
Define a running total summary field to compute the total of cBal
This is an adaptation of the method used here: https://dl.dropboxusercontent.com/u/78737945/AccountingLedger.fmp12
I have been trying to implement what you posted above, I have having problems with the sBalance holding the value after committing the record.
I am going to attach my file, it is probably messed up now since I was try to incorporate the example that you linked.
Basically what I am shooting for is having a user record that has multiple entries for each record created for that user show up in the portal below. I like that gSelectAccount dropdown and it would be nice to be able to select users to view and enter sick or personal leave etc..
I want to enter in any Transferred Days and have that add to a running balance, all the while creating a individual record to keep a running list of modifications (the portal) but keep the running balance in the balance_total field to keep up with the overall balance. So if the user has 230 Transferred days entered in when they are hired, and then they take a sick day (1) the new running balance is 229, if they have something in the sick earned field then it would add to the running balance.
Sorry for the mess as I am new to FileMaker and learn a lot by trying!