contributorpw
2020-11-28 12:00:32
Check the totalPrice value before.
It seems you're not converting prompt strings to number.
The best way for this it's to get values from the user. The code below check OK user response and a valid value.
function userAction() {
const ui = SpreadsheetApp.getUi();
var prompt = ui.prompt('Price :');
var responseText = prompt.getResponseText();
if (prompt.getSelectedButton() !== ui.Button.OK || !isNumeric(responseText)) {
ui.alert('Nothing');
return;
}
var totalPrice = +responseText;
var price1 = (totalPrice / 100) * 40;
var price2 = (totalPrice / 100) * 60;
console.log(price2);
}
function isNumeric(str) {
if (typeof str != 'string') return false;
return !isNaN(str) && !isNaN(parseFloat(str));
}
热门帖子
热门github
6
Many thanks works fine with this code. I have just replaced this line var ui = DocumentApp.getUi (); because I'm using GDocs and not GSheets. thansk again ;-)