Nibesh Khadkakcl.hashnode.net·Aug 8, 2022How to Write Google Apps Script Code Locally In Your Favorite IDE?Take apps script ID from your project and set up a local Dev Environment with Clasp. Install Clasp I'll be using Linux for this project but if you're using windows then omit the sudo command, to install the clasp package. sudo npm install -g @google/...Discuss·576 readsGoogle Apps Scripts & App Sheetsetup
Terence Robertsterence.hashnode.net·Aug 23, 2022Lessons learned from a failed interviewA little background A few years ago, I worked in the fulfillment center for a startup. Our day-to-day primary consisted of: Count the morning vehicle inventory Add/Shift around inventory between cars Verify the drivers had their checkout tools Rece...Discuss·28 reads4articles4weeks
Surinder Bhomrasurinderbhomra.hashnode.net·Jun 28, 2022Google Sheets: Copying Specific Cells To Another Sheet Using Google Apps ScriptWhenever there is a need to restructure an Excel spreadsheet to an acceptable form to be used for a SaaS platform or custom application, my first inclination is to build something in C# to get the spreadsheet into a form I require. This week I felt a...Discuss·54 readsgoogle apps script
Nibesh Khadkakcl.hashnode.net·Apr 25, 2023How to see how many words you have on google docs with Google Apps Script?Are you tired of manually counting the number of words in your Google Docs while working on your blog or article? Well, fret not, as I have got you covered with a simple yet effective solution. In this tutorial series on Apps Script, I will walk you ...DiscussGoogle Apps Scripts & App Sheetgoogle apps script
Nibesh Khadkakcl.hashnode.net·Apr 24, 2023How to Insert Multiple Rows in Google Sheets with Apps Script?Hello and welcome to our blog series on automating Google Sheets with Apps Script. In this tutorial, we will guide you on how to insert multiple rows in Google Sheets using a simple script. We'll explore how to use UiApp to create a custom user inter...DiscussGoogle Apps Scripts & App Sheetgoogle sheets
Nibesh Khadkakcl.hashnode.net·Mar 17, 2023Removing Duplicates in Google Sheets: A Guide for Non-codersUgh.., I have so many duplicate rows in my spreadsheet. Well so do many other people. With the script in this article, you can introduce a menu button that lets you delete duplicate rows in your spreadsheet. This blog is the second part of the blog I...Discuss·57 readsGoogle Apps Scripts & App Sheetgoogle apps script
Nibesh Khadkakcl.hashnode.net·Mar 12, 2023Using Apps Script to Count Checkboxes in Google SheetsYou have checkboxes in your spreadsheet, you’ll like to count them easily. Well, this script I’ll provide will help you with exactly that. Non-coders can easily follow instructions and add this script to their projects. Namaste! This is Nibesh Khadka...Discuss·49 readsGoogle Apps Scripts & App Sheetgoogle apps script
Nibesh Khadkakcl.hashnode.net·Mar 1, 2023How to Highlight Duplicate Rows in Google Sheets?You use sheets a lot and sometimes have difficulty identifying duplicate rows. Then after this blog, you’ll be equipped with a script that’ll highlight duplicate rows in your sheet. Namaste! This is Nibesh Khadka. I am a freelancer that develops scri...Discuss·57 readsGoogle Apps Scripts & App Sheetgoogle apps script
Anjanesh Lekshminarayanananjanesh.hashnode.net·Feb 26, 2023Creating a Dynamic Dropdown List in Google SpreadSheets via ScriptGoto sheets.google.com - I saved this spreasheet as Temp. Now click on the Extensions > App Script in the top-level menu as shown here : Now, you'll see an editor like this below : Now enter this code as is : function onOpen() { dynamic_dropdow...Discuss·127 readsgoogle apps script
Nibesh Khadkakcl.hashnode.net·Feb 22, 2023How To Find and Delete Duplicate Files in Google Drive?You might be running an organization where files are created automatically or by other employees/collaborators. Have you been troubled by google’s feature that allows files with the same name? Then this blog is for you. You’ll get a script to delete ...Discuss·47 readsGoogle Apps Scripts & App Sheetgoogle apps script
Nibesh Khadkakcl.hashnode.net·Jan 26, 2023How to Find the Last Non-Empty Row in A Column With Google Apps Script?Intro I am writing this short blog to share a solution to a problem that has been bugging me for a while, which is to find the last row in a column accurately. Problem Usually, when you use google apps script and want to find the last non-empty row w...Discuss·1.0K readsGoogle Apps Scripts & App Sheetgoogle apps script
Nibesh Khadkakcl.hashnode.net·Aug 23, 2022Managing Google Drive with Google Apps ScriptIntro Let's extend Google Drive with Apps Script to create a simple add-on, use CardService for the UI, where we'll select a few spreadsheets and pass them to the next card with navigation. You can find my other blogs on Google Apps Scripts right her...Discuss·972 readsGoogle Apps Scripts & App Sheetapps script
Terence Robertsterence.hashnode.net·Aug 23, 2022Lessons learned from a failed interviewA little background A few years ago, I worked in the fulfillment center for a startup. Our day-to-day primary consisted of: Count the morning vehicle inventory Add/Shift around inventory between cars Verify the drivers had their checkout tools Rece...Discuss·28 reads4articles4weeks
