Google-sheets – How to insert more than 10,000 images in Google Sheets

The answer would appear to be: You can't. (At least right now.)

From Google Support, regarding the Android app:

The Drive app doesn’t currently support viewing and editing comments in Google spreadsheets or Google presentations.

Google Support, iOS app:

The Drive app doesn’t currently support viewing and editing comments in Google spreadsheets or Google presentations.

Collaborate on documents in a mobile browser doesn't mention comments at all. However, from my experimenting, it doesn't look like comments are available there either. (Which makes sense; the mobile browser version is a limited subset of functionality.)

I found that this works. Change the form submit button of the html file to: <input onclick="formSubmit();go();" type="button" name="mysubmit" id="mysubmit" value="Add Row"/>

In the html file, add this:

<div id="div">waiting...</div>
<script>
function callback(whatToWrite) {
document.getElementById("div").innerHTML=whatToWrite;
}
function go() {
  google.script.run.withSuccessHandler(callback).writeSomething();
}
</script>

In code.gs, add this:

function writeSomething() {
    var ss = SpreadsheetApp.openById("SHEETIDHERE").getSheetByName("DATA")
  var lastRow = ss.getLastRow();
  var range = ss.getRange(lastRow, 1, 1, 2);
  var Names = range.getValues();
  return Names;
}

These changes have the desired result of updating a div with the newest last row each time a new row is inserted. This makes a nice way of showing users that their form submission is successful, and the form remains open to receive more data.

I worked this out with the answer found here: how to use google.script.run as if it was a function. I will update my example Sheet, in case this will be helpful to someone else.

UPDATE: If you are editing existing rows, then you need to move the call of the go() function to inside the formsubmit function. so that the newly updated row is shown in the confirmation div, and not just the last row.:

function formSubmit() {
            google.script.run.getSireDamfromAutocomplete(document.forms[0]);
            go();
            }