How To Automatically Log User Who Approved a Transaction Record

Question

Hello, I have a simple "Submit for Approval" and "Approved by Manager" process on a form in my "Transactions" table (see attached image.)

I'd like to record the user who sent the transaction for approval and also the manager who approved it. The user who is editing the form would be the one who's info we would record. IE - If "User A" is editing the form and clicks "Send for Manager Approval" we would want to capture "User A's" information in the User field. Same for manager.

This would also help to better direct email notifications to the appropriate parties.

Is there a way to have Quick Base grab this info when the form is saved?

Thanks for your help!

------------------------------
Josh Collins
------------------------------

MarkShnierYou · Answer

Try a form ruleWhen the record is savedand the Submit checkbox is checkedand the Submit  checkbox has changedChange the [Submitted by user field] to the current user.------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

Sign up

Login to the community