Google Sheets, writing array to sheet via script

I’ve a sheet which I’m using arrays in the script (to save on time) I have no problems writing a 2d Array to my sheets, however for some reason I can’t get a 1D array to write properly This is a screenshot in debug mode of my array. It’s just a list of prices (500… Read More Google Sheets, writing array to sheet via script

How add action button to google-doc?

I want to add button or another widget with click action to my Google Document with Apps Scripts; How will i can do it? function addButton() { var body = DocumentApp.getActiveDocument().getBody(); // code for add button to body. } >Solution : Create a menu function onOpen() { menu(); } function menu() { DocumentApp.getUi().createMenu(‘MyMenu’) .addItem(‘Function Descript’,… Read More How add action button to google-doc?

visual studio delete project from workspace and create index

when I add my folder in visual studio workspace, it create me new file(index.code-workspace)and when I delete it then my folder >Solution : Creating a workspace in Visual Studio Code Editor creates a JSON file named *.code-workspace. This JSON file is used to automatically restore all workspace settings in case you create a multi-root workspace.… Read More visual studio delete project from workspace and create index