Hello everyone
I want to generate a series of numbers starting based on user input, ignoring zeroes
Let me give you an example
User says starting number should be: 42568, and he wants 12 numbers in series.
Output should be like this:
42998
42999
43111
42112
42113
42114
42115
42116
42117
42118
42119
42121
As you can see it should ignore numbers with zero in them.
My next step is to create rows with these numbers as one of the columns. I should mention these numbers wont get used as Key.
I would be grateful if you help me figure this out.
Thanks a lot
This reminds me of the Mensa testโฆ
I donโt think it can be done practically in Appsheet. For the reason that if the start number is 40,000 youโre requirement means that it would have to ignore the first thousand numbers. Two issues I see
1 = Appsheet isnโt very capable of building long lists using the formula available. The above example shows the list will need to be over 1000 items long. Longer if the start number is 400,000 or bigger
2 = Youโd need a recurring check on each item in the list to see if it cotains a zero. Appsheet doesnโt really do looping formulas very well
My gut-feel would be to say to try and get someone to do this in Google Script
Yeah I thought something like this. But its not going to work if itโs :
LIST(42998,42999,43000,43001... ,99999,100000,100001)
Iโm pesuming appsheet doesnโt have a function for creating such a list?
Correct: there is no such function.
Suppose only โpracticalโ why to do a huge list might be to have a SQL table of all the numbers and do the formual against that. But SQL is not something I know well
What about your (and others) FAQs Tips?
With some variations
User | Count |
---|---|
43 | |
30 | |
26 | |
14 | |
14 |