"The value returned from Apps Script has a type that cannot be used by the add-ons platform"

425 views
Skip to first unread message

M. Barrett

unread,
Nov 21, 2021, 1:14:48 PM11/21/21
to Google Apps Script Community
Runtime error occurs when trying to return a numerical value (see below): 

var textInput = CardService.newTextInput()
.setFieldName("enteredDays")
.setTitle("Enter number of days to add.")
.setHint("Days")
.setOnChangeAction(CardService.newAction()
.setFunctionName("handleDaysChange"));

function handleDaysChange(e) {
entDays = e.commonEventObject.formInputs.enteredDays.stringInputs.value[0]
entDays = entDays * 86400000 // One day in milliseconds
if (isNaN(entDays)) {
console.log(entDays + " is not a number")
}else{
console.log(entDays + " is a number")
}
return entDays

isNaN(entDays) confirms entDays value is a number

Any help would be appreciated. Thanks

Clark Lind

unread,
Nov 22, 2021, 8:23:55 AM11/22/21
to Google Apps Script Community
I'm not well-versed to that level of the event object, and I know javascript usually interprets string input as numbers if they appear to be a number. 
I don't know if this will make a difference or not, but see if forcing it as a number helps:
entDays = e.commonEventObject.formInputs.enteredDays.stringInputs.value[0]
entDays = Number(entDays)
entDays = entDays * 86400000 // One day in milliseconds


Reply all
Reply to author
Forward
Message has been deleted
0 new messages