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
3 Likes
Generate a list of consecutive numbers , between two numbers Questions
It’s possible with a relatively small number of numbers within a limited range: ( TOP( list-of-possible-numbers, last-number ) - TOP( list-of-possible-numbers, (first-number - 1) ) ) Using your example values: ( TOP( LIST(1, 2, 3, 4, 5, 6, 7, 8, 9), 7 ) - TOP( LIST(1, 2, 3, 4, 5, 6, 7, 8, 9), (4 - 1) ) ) Note that list-of-possible-values must be in order and contain no duplicate values.
[Generate a list of consecutive numbers , between two numbers](https://community.appsheet.com/t/generate-a-list-of-consecutive-numbers-between-two-numbers/56984/4) Questions
That’s a great approach for a larger list of numbers! SORT( SELECT( All Numbers[Number], AND( ([Number] >= first-number), ([Number] <= last-number) ) ) )
3 Likes
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?
1minManager:
I’m pesuming appsheet doesn’t have a function for creating such a list?
Correct: there is no such function.
2 Likes
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
3 Likes
What about your (and others) FAQs Tips?
[FAQ: Add a number of rows](https://community.appsheet.com/t/faq-add-a-number-of-rows/30503) Tips & Tricks ?
Add an arbitrary number of rows to a table based on a column value of type Number. Try the sample app! For this example, the table from which the row-addition process will be initiated is called Control Table. The table to which new rows will be added is called Target Table. Use your own names as you see fit. Note that they could even be the same table. Control Table must allow updates; Target Table must allow adds. Control Table must have at least two columns for this process: Finish Count (…
[Manupulating Array value (List in Appsheet) using LOOP actions](https://community.appsheet.com/t/manupulating-array-value-list-in-appsheet-using-loop-actions/39515) Tips & Tricks ?
Being inspired by @steve s LOOP actions tips and tricks, to add arbitrary number of childs records, I came up with ideas to manupilate values in array, which means list values in Appsheet. User select and/or add values to Enumlist type fields then convert those values as we want. In this simplified sample app, we select and/or values to enumlist, which represents the name. Then we add the string (text) at the end of each listed values to generate the converted list values. In oth…
[FAQ: add a set of rows](https://community.appsheet.com/t/faq-add-a-set-of-rows/30846) Tips & Tricks ?
When a row is added to a table, add a set of rows to another table. Try the sample app! This example uses three tables: Master Table: when a new row is added here, all rows from Source Table will be copied to Target Table and linked back to the new Master Table row. This table must allow adds. Source Table, from which all rows will be copied to Target Table. Target Table, to which all rows from Source Table will be copied. This table must allow adds. Action 1: Copy Source Table row…
With some variations