Creating a list with consecutive numbers

Hi @michael291 

Both options would work, but the Code step will save Tasks.

Hi @michael291!

Here’s a bit of a hack-y way to do it but it works :) Not sure how any times you have to add to that value but you can use Google Sheets like this:

Then you will get each of those values in the output of this step:

This is mostly because I’m not that great with code, so I find ways around it 😛 

@nicksimard Thanks, but I thought there would be a solution without Google Sheet (i.e. doing a Spreadsheet-style formula etc.). 

@Troy Tessalone I had that before. But I needed 9 single steps to get 10 consecutive numbers (based on the first number). I.e. 9 (is the base) and the following numbers 10, 11, 12 etc. So I thought there would be a solution with Python or a Spreadsheet-style formula to save a few steps within the Zap. 

Hi @Troy Tessalone you are great!!! I owe you three beer for that. Absolutely perfect!!

That’s even better what I was looking for. I have added your JavaScript code snippet below for other people who are interested in it… 

Here’s the code snippet of the JavaScript… 

var INPUT = parseInt(inputData.INPUT); // sets variable value as a number
var INCREMENT = parseInt(inputData.INCREMENT); // sets variable value as a number
var BASE = parseInt(inputData.BASE); // sets variable value as a number
var COUNT = parseInt(inputData.COUNT); // sets variable value as a number
var RESULT = []; // defines an empty array

while (BASE <= COUNT) // sets conditions for loop to execute while condition is true
{
INPUT = INPUT + INCREMENT; // increments value each time
RESULT.push(INPUT); // adds new value to array
BASE = BASE + INCREMENT; // increments value each time
}

RESULT = RESULT.join(); // converts array to comma separated string
output = [{RESULT}]; // returns specified variables