I have a spreadsheet with three columns and lots of rows.
Column A has a numerical ID Column B is empty Column C is empty
I 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.