Thank you Ashton! Great stuff! I loved your work in Google Cloud. I know working in Google Cloud can sometimes be very complicated so your explanations are very helpful. Did you personally read any book online or watch any videos to get familiar with Google Cloud?

@ashtonfei

6 ай бұрын

I fully agree with you about the GCP. I am too far away from that, for this specific example, I learnt it from my personal experience with publishing some add-ons to the workspace market. I made some mistakes during that process, Google team gave some feedbacks and advices, and I had to read their document a little bit more carefully especially for me as a non-native English speaker.

Hi Ashton, thank you for the great lesson. Never thought of automatically copying scripts with GAS before. Can you explain a little more of the use cases or benefits of this approach instead of including the code as a library? Thank you!

@ashtonfei

6 ай бұрын

The use case I can see is to deploy the same codes to multiple files without make the project as an add-on. Library is a good idea, but I think we still need to maintain the some code for each file separately if we use it. For example: If I have an onOpen function to create the menu in a library called ATB. In the spreadsheet apps script project, by adding the library, the onOpen function is prefixed by ATB.onOpen, and I will need to define the onOpen function in the project with onOpen = () => ATB.onOpen(); And for each function in the menu, we may need to do the same here. Example, if there is a function in the library to complete a task A. We may need to define this function const completeTaskA = () => ATB.completeTaskA();