I have a spreadsheet with three columns and lots of rows.Column A has a numerical IDColumn B is emptyColumn C is emptyI want to have a button in each row in column C. When pressed, it should take the information in column A of the same row and do some processing on it and output the result in column B.The processing will make use of outside servers to do some data fetching, hence I cannot do this on sheet load because of data overload. (actually I tried first, but it takes ages, times out etc with many rows).So I want to have it load that information adhoc, on the press of a button on the same line.I have looked around and it seems that the only way to make buttons is to make a drawing of a button and then tie that button to a script. The problem with this approach is that the buttons aren't tied to a a cell so I can't get the current row number where the button is, to do processing on only that row.Any fix?
Button in column C in each row
google spreadsheets