google apps script - Updating a field based on contents on another tab -
I have created a spreadsheet with several tabs. The column 'id' and 'name' in my 'source' tab 1 have 'id' in my 'target' tab 2. I am trying to iterate through rows in my Target tab and read the value of the ID and then search my source tab. Id. When I get the ID, I want to capture the value in the 'Name' field and I want to add it to a cell on the same line of ID of my Target tab. I have a difficult time getting rid of the logic through an array and I'm getting the value in an array of the contents of the target tab or the target tab. In the Targets tab, there can be more than one instance of an ID, and I have to update them all. Any suggestions will be welcome! Here's a suggestion: / * Tell us source name With array (column A) & amp; The ID (column B) array is the 'source' and the target array in which the ID array is the 'target', you get it with something like * / var source = Spreadsheet...