List Generator Expressions

[Marc_Dillon]

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}

[Austin]

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

[Marc_Dillon]

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 :

[Austin]

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

[GreenFlux]

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

[Marc_Dillon]

that should be worth 2 votes.

[MultiTech]

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.

[yoshi]

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.

[Gustavo_Eduardo]

Excelente propuesta, ojalá se resuelva pronto ya que es muy útil, incluso con esto podríamos realizar algo similar a WORKDAY pero para cualquier combinación de días. 

[KingsGuava]

This would be really helpful when using a Start/End expression in automation! 

If I wanted to create a record for every day between two dates, it is impossible to do it programmatically and I have to set an arbitrary limit based on the number of IFS statements I'm willing to write 😞

[Jonathon]

Start/End expressions only work against reference rows. So, in this case, you would still need a table of dates to iterate against.

[KingsGuava]

Oh you're right! I hope they take that into consideration when they review this feature