List Generator Expressions

NUMBERLIST(0,10) = {0,1,2,3,4,5,6,7,8,9,10}

DATELIST(TODAY() , TODAY()+7) = {2/3/21 , 2/4/21,… , 2/10/21}

ALPHALIST(“a” , “d”) = {“a” , “b” , “c” , “d”}

DECIMALLIST(0,0.5,0.1) = {0,0.1,0.2,0.3,0.4,0.5}

Curious about your use case? I assume its for dropdowns which is what I would use it for.

Just seemed like it’d be useful, so I posted. But you’re correct, dropdown options is what led to me think about it. I was writing things like this today for suggested values :

image

image
I know the feeling and the struggle of stuff like that. Got a table of nothing but every day between 2017 to end of 2021

4 Likes

You just stole a vote from another feature request. I don’t know which one yet… I’ll be back with my vote!

3 Likes

that should be worth 2 votes.

3 Likes

This could really help speed up time when you need to create a list of things.

I’ll admit… limited use cases that I can see; but in the few times where I had to generate a list similar to something like this, having a simple function where I could provide a range and it would fill in the middle of that range - sure would have been nice.

1 Like

excel and google sheet has similar function SEQUENCE.
https://support.google.com/docs/answer/9368244?hl=en

It is ideal if the same function can be used in AppSheet too,
although the first argument is redundant.

SEQUENCE(1, length, start, step )

SEQUENCE(1, 11, 0, 1) = {0,1,2,3,4,5,6,7,8,9,10}
SEQUENCE(1, 2, today(), 7) = {2/3/21 , 2/4/21}
CHAR(SEQUENCE(1, 4, 97, 1))= {“a” , “b” , “c” , “d”}
SEQUENCE(1, 6, 0, 0.1) = {0,0.1,0.2,0.3,0.4,0.5}

Note: function char also to be implemented.

1 Like