I'm new to app script and I was just wondering if there was a way to input a cell value into an alert.
I tried
var ui=SpreadsheetApp.getUi()
var winScreeen = ui.alert('Win:',sr.getRange('U5').getValue())
function myalert() {
const ss = SpreadsheetApp.getActive();
SpreadsheetApp.getUi().alert(`win:${ss.getRange("Sheet0!A2").getValue()}`);
}
Instead of
var winScreeen = ui.alert('Win:',sr.getRange('U5').getValue())
use
var winScreeen = ui.alert('Win:' + sr.getRange('U5').getValue())
The above used + to concatenate two values.