Google Apps script - IN operator for minutes
I try to run a sequential code. First update should happen every 15 minutes, the second one always 3 minutes after the first one.
The code below runs every minute.
However, it never works in Google Apps Script. Any idea how to fix it?
I only came up with writing out the in clause to == and or. It does not look straight.
function update_per_1_min() {
var d = new Date();
var m = d.getMinutes();
var m = 16
if(m in [1.0,16.0,31.0,46.0]){
update_0()
} else if (m in [4,19,34,49]) {
update_1()
}
}
javascript google-apps-script
asked Nov 19 '18 at 10:39
IljaIlja
18811
add a comment |
I try to run a sequential code. First update should happen every 15 minutes, the second one always 3 minutes after the first one.
The code below runs every minute.
However, it never works in Google Apps Script. Any idea how to fix it?
I only came up with writing out the in clause to == and or. It does not look straight.
function update_per_1_min() {
var d = new Date();
var m = d.getMinutes();
var m = 16
if(m in [1.0,16.0,31.0,46.0]){
update_0()
} else if (m in [4,19,34,49]) {
update_1()
}
}
javascript google-apps-script
asked Nov 19 '18 at 10:39
IljaIlja
18811
add a comment |
I try to run a sequential code. First update should happen every 15 minutes, the second one always 3 minutes after the first one.
The code below runs every minute.
However, it never works in Google Apps Script. Any idea how to fix it?
I only came up with writing out the in clause to == and or. It does not look straight.
function update_per_1_min() {
var d = new Date();
var m = d.getMinutes();
var m = 16
if(m in [1.0,16.0,31.0,46.0]){
update_0()
} else if (m in [4,19,34,49]) {
update_1()
}
}
javascript google-apps-script
asked Nov 19 '18 at 10:39
IljaIlja
18811
I try to run a sequential code. First update should happen every 15 minutes, the second one always 3 minutes after the first one.
The code below runs every minute.
However, it never works in Google Apps Script. Any idea how to fix it?
I only came up with writing out the in clause to == and or. It does not look straight.
function update_per_1_min() {
var d = new Date();
var m = d.getMinutes();
var m = 16
if(m in [1.0,16.0,31.0,46.0]){
update_0()
} else if (m in [4,19,34,49]) {
update_1()
}
}
javascript google-apps-script
javascript google-apps-script
asked Nov 19 '18 at 10:39
IljaIlja
18811
asked Nov 19 '18 at 10:39
IljaIlja
18811
asked Nov 19 '18 at 10:39
IljaIlja
18811
asked Nov 19 '18 at 10:39
IljaIlja
18811
asked Nov 19 '18 at 10:39
IljaIlja
18811
18811
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
in checks whether the expression is a property of the object. Arrays have properties like 0 for the first index, 1 for the second index, etc:
const arr = ['foo', 'bar'];
console.log('foo' in arr);
console.log('0' in arr);Properties are not the same thing as values, of course. It looks like you're trying to check whether the value is contained in the array, in which case you could use .includes (if you were able to use ES6), or indexOf for GAS:
function update_per_1_min() {
var d = new Date();
var m = d.getMinutes();
if([1,16,31,46].indexOf(m) !== -1){
update_0()
} else if ([4,19,34,49].indexOf(m) !== -1) {
update_1()
}
}
(note that trailing zeros after the . in numbers is meaningless - feel free to leave those out entirely)
answered Nov 19 '18 at 10:43
CertainPerformanceCertainPerformance
80.1k143865
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53372834%2fgoogle-apps-script-in-operator-for-minutes%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
in checks whether the expression is a property of the object. Arrays have properties like 0 for the first index, 1 for the second index, etc:
const arr = ['foo', 'bar'];
console.log('foo' in arr);
console.log('0' in arr);Properties are not the same thing as values, of course. It looks like you're trying to check whether the value is contained in the array, in which case you could use .includes (if you were able to use ES6), or indexOf for GAS:
function update_per_1_min() {
var d = new Date();
var m = d.getMinutes();
if([1,16,31,46].indexOf(m) !== -1){
update_0()
} else if ([4,19,34,49].indexOf(m) !== -1) {
update_1()
}
}
(note that trailing zeros after the . in numbers is meaningless - feel free to leave those out entirely)
answered Nov 19 '18 at 10:43
CertainPerformanceCertainPerformance
80.1k143865
add a comment |
in checks whether the expression is a property of the object. Arrays have properties like 0 for the first index, 1 for the second index, etc:
const arr = ['foo', 'bar'];
console.log('foo' in arr);
console.log('0' in arr);Properties are not the same thing as values, of course. It looks like you're trying to check whether the value is contained in the array, in which case you could use .includes (if you were able to use ES6), or indexOf for GAS:
function update_per_1_min() {
var d = new Date();
var m = d.getMinutes();
if([1,16,31,46].indexOf(m) !== -1){
update_0()
} else if ([4,19,34,49].indexOf(m) !== -1) {
update_1()
}
}
(note that trailing zeros after the . in numbers is meaningless - feel free to leave those out entirely)
answered Nov 19 '18 at 10:43
CertainPerformanceCertainPerformance
80.1k143865
add a comment |
in checks whether the expression is a property of the object. Arrays have properties like 0 for the first index, 1 for the second index, etc:
const arr = ['foo', 'bar'];
console.log('foo' in arr);
console.log('0' in arr);Properties are not the same thing as values, of course. It looks like you're trying to check whether the value is contained in the array, in which case you could use .includes (if you were able to use ES6), or indexOf for GAS:
function update_per_1_min() {
var d = new Date();
var m = d.getMinutes();
if([1,16,31,46].indexOf(m) !== -1){
update_0()
} else if ([4,19,34,49].indexOf(m) !== -1) {
update_1()
}
}
(note that trailing zeros after the . in numbers is meaningless - feel free to leave those out entirely)
answered Nov 19 '18 at 10:43
CertainPerformanceCertainPerformance
80.1k143865
in checks whether the expression is a property of the object. Arrays have properties like 0 for the first index, 1 for the second index, etc:
const arr = ['foo', 'bar'];
console.log('foo' in arr);
console.log('0' in arr);Properties are not the same thing as values, of course. It looks like you're trying to check whether the value is contained in the array, in which case you could use .includes (if you were able to use ES6), or indexOf for GAS:
function update_per_1_min() {
var d = new Date();
var m = d.getMinutes();
if([1,16,31,46].indexOf(m) !== -1){
update_0()
} else if ([4,19,34,49].indexOf(m) !== -1) {
update_1()
}
}
(note that trailing zeros after the . in numbers is meaningless - feel free to leave those out entirely)
const arr = ['foo', 'bar'];
console.log('foo' in arr);
console.log('0' in arr);const arr = ['foo', 'bar'];
console.log('foo' in arr);
console.log('0' in arr);answered Nov 19 '18 at 10:43
CertainPerformanceCertainPerformance
80.1k143865
answered Nov 19 '18 at 10:43
CertainPerformanceCertainPerformance
80.1k143865
answered Nov 19 '18 at 10:43
CertainPerformanceCertainPerformance
80.1k143865
answered Nov 19 '18 at 10:43
CertainPerformanceCertainPerformance
80.1k143865
80.1k143865
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53372834%2fgoogle-apps-script-in-operator-for-minutes%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
