I am developing a spreadsheet where a user clicks a link in the sheet to call a deployed web app as described here Trigger Script in Spreadsheet in Similar Fashion to a Link
This works well although I need to somehow identify the row of the calling cell that the user clicked the link. So if the
=HYPERLINK("https://script.google.com/macros/s/ ... /exec"¶ms())
Is in cell E1, I need the functions called to know the calling row is "1". I tried GetActiveCell within the params function and I keep getting a range error. I also tried passing the row directly to the params() function through the calling hyperlink and it did not receive the value [I tried as (1) and ("1")]. Is there a way to pass a value to the params function?
=HYPERLINK("https://script.google.com/macros/s/ ... /exec"¶ms(1))
Can anyone offer any help / suggestions? It would be greatly appreciated!