I am new to Google sheets and scripting. I've seen samples of scripts here that allows recording of the current user's email when they make an amendment in a sheet.
Is there a way for me to click a button and record my email address in a specific cell?
The use-case is a simple approve button where the email address of the user that clicked the button will appear in a cell next to the button. Editing will be restricted to the organisation's domain so every user should have a G Suite account.