I want to be convert a list of Enumlist of text into Enumlist of numbers.
Eg. (Jan, Feb, Mar, April) into (1, 2, 3, 4) etc.
However, i want it automated so once you create the Enumlist it will fill a field with the same list but in a form of numbers following the index list of the Enumlist.
The number list must count whenever there is a comma(,) in the list.
@
Give it a shoot:
SPLIT(LEFT("1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100",
(COUNT([Original EnumList])*2)-1), ", ")
Unfortunately, since AppSheet does not have a loop formula, you must limit the number of possible selections. In this case, I limited it to 100, so it will only work up to 100 EnumList entries.
However, it is possible to make a loop action, but the action would take some time to calculate, not an instant response.
Take a look at:
I'd recommend created a month table, with at least 2 columns: month and month_number. Then you can set your enumlist to be a ref to this table, and you can list-dereference the numbers out.
https://help.appsheet.com/en/articles/4575708-list-dereference
User | Count |
---|---|
41 | |
30 | |
29 | |
16 | |
14 |