The following code from a web application works perfectly when running in the code editor but it fails when launching from the link I get on implementation. It returns TypeError: Cannot read properties of null (reading 'getColumn'). So the problematic line is line 4: var col = ws.createTextFinder(fldName).findNext().getColumn();

I was given this script that deletes all duplicates from Sheets 1, 2 & 3 as they come into Sheet4. I need to adjust it so it does not delete duplicates if, when the Job Number comes into ColA Sheet4, it reassigns it from MO123456 to MO123456^1 in Col B. Anything over or equal to ^2 should be treated a a duplicate that needs deleted from Sheets 1, 2 & 3.

I was given this script that deletes all duplicates from Sheets 1, 2 & 3 as they come into Sheet4. I need to adjust it so it does not delete duplicates if, when the Job Number comes into ColA Sheet4, it reassigns it from MO123456 to MO123456^1 in Col B. Anything over or equal to ^2 should be treated a a duplicate that needs deleted from Sheets 1, 2 & 3.

I was given this script that deletes all duplicates from Sheets 1, 2 & 3 as they come into Sheet4. I need to adjust it so it does not delete duplicates if, when the Job Number comes into ColA Sheet4, it reassigns it from MO123456 to MO123456^1 in Col B. Anything over or equal to ^2 should be treated a a duplicate that needs deleted from Sheets 1, 2 & 3.

How can I adjust this script so that job numbers marked as MO123456^1 are not submitted for deletion from Sheets 1, 2 & 3. Need only job numbers with an increment of 2 or higher that are deleted from Sheets 1, 2 ,3.

I have a multi-sheet spreadsheet that contains job numbers in column A of sheets 1, 2, 3, & 4
When a duplicate number comes into Sheet4 Col A, a formula copies the number to Col B adding a ^ {vers number}. So MO123456 in Col A becomes MO123456^1 in Col B (which increments for each additional duplicate of that number).

So, I have this script from CoinMarketCap to lookup crypto prices. I want to modify this script where I can apply it to a cell and then drag and drop it down the column to read the ticker symbol in another cell column. I am a complete noob at App Scripts.

I’ve used the following script to automatically sort entries in a Google Sheet but it only works for me. When another user, with whom I’ve shared the Google Sheet, edits the sheet the sorting is not triggered. They’ve not been asked/prompted to grant authority to run the script using their account. I’m not sure what I need to change to make it work and/or prompt the user to grant authority. Grateful for advice. Thanks.

I am using Google Apps script, which is not bounded to a Google sheet. The target is the following:

When declaring a variable in a Google Apps script, when would I use let vs. const vs var, as in the following?