Answers to your questions:
1. I think you have them mixed up.
Account Name is the currently user who is logged into the file. This is what you log into Filemaker with.
User Name is the name of the computer.
What you want is the Account Name.
2. Create another text field, double click it and choose "Modification: Account Name"
Every time the record is modified, it will enter the account name of the user who modified it.
You can also create date/time/timestamp fields, etc that will enter date when modified.
1. I had them backwards. It is set for AccountName, but it is entering the User Name off the computer. It should be entering Admin as that is what I am logged in as. In the CreatedBy and ModifiedBy fields, it correctly enters AccountName (Admin), but those are set in the field attributes. For the ApprovedBy field it's set by a script on the button, which is:
Insert Current User Name [Select; Activity::ApprovedBy]
Insert Current Date [Select; Activity::ApprovalDate]
2. I already have that set up, and it works fine. What I'm trying to do is let the Manager approve the record but not enter the manager's account name unless the manager modifiesany other field in the record besides triggering the Approval script.
Insert Current User Name is: ... inserting the UserName
Set Field [Activity::ApprovedBy; Get ( AccountName )] will insert: what do you guess?
That did it! Now, that script works perfectly.
Now if I can just figure out the second part -- how to have that script run and NOT change the ModifiedBy/ModifiedDate fields unless the manager actually modifies any other fields.
You can use Evaluate
Turn off the modification information.
Make it an calculated value,
And then, for example in the modifierUser field, use:
Evaluate("Get(AccountName)"; [fieldToActivateIt; fieldToActivateIt; fieldToActivateIt; fieldToActivateIt; fieldToActivateIt])
OK -- gotta go and read up about Evaluate function. Never used that before.