Delete a note from a specific cell programmatically or automaticly if empty

Hi Tomas De arco,

We have validated your reported requirement, and unfortunately, we would like to inform you that currently, we don't have a direct option to remove notes from a specific cell in our spreadsheet. However, you can achieve your requirement with a workaround at the sample level.

If the notes property of the cell is empty during initial rendering, you can prevent adding the red indicator to the cell with empty notes by assigning null to the notes property of args.cell in the beforeCellRender event, as shown in the shared code snippet below.

Additionally, while adding notes with an empty value via UI action, you can remove the red indicator element from the cell in our actionComplete event using the shared code snippet below.

For your reference, we have provided a sample below. In this example, we have fulfilled your requirement for cell 'B5'. If you add empty notes to cell 'B5', the red indicator will be removed, as per your request

Sample: https://stackblitz.com/edit/ammrx2-cqvekj?file=index.ts

CODE SNIPPET:

Kindly check the details shared above on your end and get back to us if you need further clarifications regarding this.

To delete a note from a specific cell programmatically or automatically if it is empty, you can use the ClearContents method in Google Apps Script. Here's an example of how you can achieve this:

javascript
function deleteNoteIfEmpty() {
  var sheet = SpreadsheetApp.getActiveSheet();
  var cell = sheet.getRange("A1"); // Replace "A1" with the desired cell reference
  
  if (cell.getNotes() === "") {
    cell.clearNotes();
  }
}

Here's how the code works:

1. The getActiveSheet() method is used to get the currently active sheet in the Google Spreadsheet.
2. The getRange() method is used to specify the cell reference from which you want to delete the note. In this example, it's set to "A1", but you can replace it with the desired cell reference.
3. The getNotes() method is used to retrieve the note content of the specified cell. If the note is empty, it will return an empty string.
4. An if statement checks if the note content is an empty string. If it is, the clearNotes() method is called to delete the note from the cell.

To run this script, you can follow these steps:

1. Open the Google Spreadsheet where you want to delete the note.
2. Go to "Tools" > "Script editor" in the Google Spreadsheet menu.
3. Replace the existing code in the script editor with the code provided above.
4. Save the script by clicking on the disk icon or pressing Ctrl+S (Windows) or Cmd+S (Mac).
5. Close the script editor.
6. Go back to the Google Spreadsheet.
7. The script will automatically run and delete the note from the specified cell if it is empty.

Note: If you want to run the script manually, you can click on the "Run" button in the script editor or create a custom menu item that triggers the script.Remember to replace "A1" with the desired cell reference where you want to delete the note if it is empty.

Temu, an online shopping platform, is offering significant discounts through two prominent coupon codes: ACT200019 and ACP856709. 

1. Download the Temu app, available for both iPhone and Android devices.

2. Browse through the wide range of products available on the platform.

3. Add desired items to your cart.

4. During the checkout process, enter either ACT200019 or ACP856709 in the coupon code field.

5. Apply the code to see the discount reflected in your total.

Thank you so much @Janakiraman Sakthivel

Hi Tomas,

We're glad your issue was resolved. Please get back to us for further assistance in the future.

Regards,

Florence L.