# Experimental Code - return an array of numbers between two values
**URL:** https://community.glideapps.com/t/experimental-code-return-an-array-of-numbers-between-two-values/32035
**Category:** Ask for Help
**Created:** [September 20, 2021, 8:57am UTC](https://community.glideapps.com/t/experimental-code-return-an-array-of-numbers-between-two-values/32035 "2021-09-20T08:57:19Z")
**Posts on this page:** 8
**Page:** 1
### Author:  [@benmitchell](https://community.glideapps.com/u/benmitchell)
#### Post date: [September 20, 2021, 8:57am UTC](https://community.glideapps.com/t/experimental-code-return-an-array-of-numbers-between-two-values/32035/1 "2021-09-20T08:57:19Z")
Hi I’m looking for help to use the xc column to get an array of the range of numbers between two numbers e.g. Value 1: 6 to Value 2:11
Which would return:
6, 7, 8, 9, 10, 11
Any help much appreciated!
---
### Author:  [@Manu.n](https://community.glideapps.com/u/Manu.n)
#### Post date: [September 20, 2021, 9:16am UTC](https://community.glideapps.com/t/experimental-code-return-an-array-of-numbers-between-two-values/32035/2 "2021-09-20T09:16:56Z")
Hello,
have you already done a few things or you want a ready-made solution
---
### Author:  [@benmitchell](https://community.glideapps.com/u/benmitchell)
#### Post date: [September 20, 2021, 9:21am UTC](https://community.glideapps.com/t/experimental-code-return-an-array-of-numbers-between-two-values/32035/3 "2021-09-20T09:21:48Z")
I’ve had a go with the below code but not really getting anywhere.
```auto
const range = (start, end) => {
const length = end - start;
return Array.from({ length }, (_, i) => start + i);
```
---
### Author:  [@Manu.n](https://community.glideapps.com/u/Manu.n)
#### Post date: [September 20, 2021, 9:24am UTC](https://community.glideapps.com/t/experimental-code-return-an-array-of-numbers-between-two-values/32035/4 "2021-09-20T09:24:30Z")
oh it’s too complicated for me !!!
I did something old-fashioned:
```auto
FILE function.js
window.function = function (num1, num2) {
if (num1 === undefined) return;
if (num2 === undefined) return;
num1 = num1.value ?? 0;
num2 = num2.value ?? 0;
let ret = [];
let x = num1;
let y = num2;
if (y < x)
{
x = num2;
y = num1;
}
for (let i = x; i <= y; i++) {
ret.push(i);
}
return ret;
}
FILE glide.json :
{
"kind": "column",
"name": "Date1to2",
"description": "Date 1 to 2",
"author": "Manu",
"params": [
{
"name": "num1",
"displayName": "Number 1",
"type": "number"
},
{
"name": "num2",
"displayName": "Number 2",
"type": "number"
}
],
"result": {
"type": { "kind": "array", "items": "number" }
}
}
```
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [September 20, 2021, 9:36am UTC](https://community.glideapps.com/t/experimental-code-return-an-array-of-numbers-between-two-values/32035/5 "2021-09-20T09:36:47Z")
Slightly less verbose…
```auto
function make_array() {
var start = 3;
var end = 10;
var arr = [];
while (start <= end) {
arr.push(start);
start++;
}
console.log(arr);
}
```
```auto
[3, 4, 5, 6, 7, 8, 9, 10]
```
---
### Author:  [@benmitchell](https://community.glideapps.com/u/benmitchell)
#### Post date: [September 20, 2021, 9:38am UTC](https://community.glideapps.com/t/experimental-code-return-an-array-of-numbers-between-two-values/32035/6 "2021-09-20T09:38:40Z")
Thanks!
---
### Author:  [@gvalero](https://community.glideapps.com/u/gvalero)
#### Post date: [September 20, 2021, 12:49pm UTC](https://community.glideapps.com/t/experimental-code-return-an-array-of-numbers-between-two-values/32035/7 "2021-09-20T12:49:18Z")
> [@Darren\_Murphy](#):
>
> ```auto
> function make_array() {
> var start = 3;
> var end = 10;
> var arr = [];
> while (start <= end) {
> arr.push(start);
> start++;
> }
> console.log(arr);
> }
>
> ```
I had put some parameters 🤓
```auto
function make_array(start,end) {
var arr = [];
while (start <= end) {
arr.push(start);
start++;
}
return arr;
}
return make_array(3,10)
```
Saludos!
---
### Author:  [@NoCodeAndy](https://community.glideapps.com/u/NoCodeAndy)
#### Post date: [January 17, 2024, 4:50pm UTC](https://community.glideapps.com/t/experimental-code-return-an-array-of-numbers-between-two-values/32035/8 "2024-01-17T16:50:28Z")