Sheets Write value on the corresponding line

MIT App Inventor Help
1

Okay, let's see if I can explain.

I need to write a value on the line corresponding to the search for a value
For example, I looked for a value in column E, found this value in E13, I need to write a value in F13, how could I do it?

2

This is not an AppInventor question (unless you are using the Spreadsheet component?), ask on Stackoverflow or check your email for my response to your query from my website.

3
4
5

Through some blocks, using the worksheet ID, I was able to search and return a value in a listview component. I need to write a value in the line corresponding to the search for this value.
For example, I looked for a value in column E, I found this value in E13 inside the listview, I need to write a value in F13, how could I do it?

6

blocks
blocks1104×264 27.3 KB

7 
function doGet(e) {
  var ss = SpreadsheetApp.getActive();
  var sh = ss.getSheetByName('Sheet1');
  var textFinder = ss.createTextFinder(e.parameter.searchTerm).matchEntireCell(true);
  var res = textFinder.findNext();
  if (res) {
  sh.getRange('F' + res.getRow()).setValue(e.parameter.fValue);
  return ContentService.createTextOutput('Match found and row amended');
  } else {
  return ContentService.createTextOutput('No Match found');
  }
}
8

Does this block belong to any extension?

9

No, it's AI2's own Spreadsheet component.