Creating a log sheet for Google Sheets using App script

68 views
Skip to first unread message

Michael Thunes

unread,
Sep 12, 2023, 9:15:23 AM9/12/23
to Google Apps Script Community
Hi All,

I have been trying to wrap my head around how to create a log sheet for a parts tracking workbook but I think I have gone the wrong direction.

My goal is to record the entire row from my parts tracker sheet when the status is changed or the part name is updated (this will probably expand to other columns later) and save that log in a new spreadsheet. I also want to know the time that the change was completed as well as the email of the person who make the change.

Although I have done a fair amount of research I do not have enough of an understanding of Apps Script to get anything remotely close to what I need.

Below are two sheets (one is a sample parts tracker, the other a sample log sheet)

In the parts tracker there will be multiple sheets that I want to look over and track changes from (I have them labeled as Sheet1 and Sheet2 but in reality there are more sheets with varied names) all sheets from the workbook will need to be tracked and logged.

As a sample I have manually inputted what the log would look like coming from Sheet1 row 3.

Any and all help is appreciated

Daniel Paes

unread,
Sep 28, 2023, 7:25:11 AM9/28/23
to google-apps-sc...@googlegroups.com
Hi, has anyone helped you yet? If not, have you tried researching the spreadsheet events? in the documentation about spreadsheet events would help you deal with what you need to know the time something was changed and who changed it. There are several important methods and it is possible that some will help you with your project. I will leave the link to the excerpt of the events that I think will help you. here, if you still need help, let me know!

--
You received this message because you are subscribed to the Google Groups "Google Apps Script Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-script-c...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/f4bfc972-887b-40b2-b794-e893d226c481n%40googlegroups.com.


--
Reply all
Reply to author
Forward
0 new messages