Google Apps Script learn how to create a script to get data from your Google Sheet cells. Get the Course : Google Apps Script Complete Course New IDE 100+ Examples course example www.udemy.com/... Source Code : github.com/lsv...
Hi Laurence. More power to youu and your channel for its great content. Im hoping to get your help. Im new with coding. What i want is to search on an active sheet with value, let say A1 with unique ids. And this unique ids also being added to Main Sheet. When user is on the active search to have a function that can search the value in an active sheet A1(unique ids) and if it matches in the Main Sheet it should set value of a time stamp corresponding to that unique ids row.
Is this from a UI menu button, you can select the active sheet with the getActiveSheet() function searchIt(){ const sheet = SpreadsheetApp.getActiveSheet() const findString = "test" const textFinder = sheet.createTextFinder(findString) const cell = textFinder.findNext(); const row = cell.getRow(); const col = cell.getColumn(); Logger.log(`Found at row ${row} col ${col}`) }
Appreciate it Laurence. Is it possible to run it with for loops? Once it finds the matching value from active sheet to my main sheet it will assign a timestamp to corresponding row. Example on my active sheet(Sheet1) once it finds the exact value lets say "test" in A1(Sheet1) to my main sheet(Main) it will update the corresponding column on Main with a timestamp lets say in B1. Example: Main(Main Sheet) A1 Value - "test" Since it matches to Sheet1 A1 value, B1 cell on main sheet should have a timestamp in it. Sheet1(Active Sheet) A1 - "test"
I have one tab of g sheet that has the G sheet file IDs I want to import data to. However the data I want to import (copy and paste) is a different array.. And the data I want to import for each file id is the row below the one used previously I've set up both Google tab ranges as arrays. But what sort of for loop would be needed to move down a sheet row for every file id... Seems like a for I=0, I++ sort of for loop is needed?
@@LaurenceSvekisCourses thanks. But it's more like. I want to copy the first row of data in sheet (array) foreach file ID (element) and paste in the sheet of that file ID But I am having trouble getting the target row to copy to be incremented by 1 row down to keep up with the file ID foreach loop. If that doesn't make sense I'm sure it's my fault. Either way appreciate you taking time to respond earlier.
Maybe I see what u mean. Make the whole range of cells I want to copy for every file. But each sheet row of range is it's own array. At that point I need some sorta counter
Hello Laurence Svekis, I have a google sheet having two sheet, one is admission form and other is database, in Admission form I have a search button in addition to other buttons, but I have a problem with search button that it search one record the oldest record, but i need when I click search button everytime it must display a new duplicate record available in database.. may you help me in this regard, I can send you that sheet.