Hi AppSheet Community,
I have a list of IDs that look like this that I want to increment automatically:
So technically it is a “text” type. Is casting allowed in AppSheet so I can split the numbers by hyphen and increment the numbers every time I reach past the letter C?
Thanks
Solved! Go to Solution.
Untested:
concatenate(
(
number(index(split(any(sort(My Table[ID], true)), "-"), 1))
+ switch(
index(split(any(sort(My Table[ID], true)), "-"), 2),
"4c", 1,
0
)
),
"-",
switch(
index(split(any(sort(My Table[ID], true)), "-"), 2),
"1a", "1b",
"1b", "1c",
"1c", "2a",
"2a", "2b",
"2b", "2c",
"2c", "3a",
"3a", "3b",
"3b", "3c",
"3c", "4a",
"4a", "4b",
"4b", "4c",
"4c", "1a",
""
)
)
User | Count |
---|---|
40 | |
36 | |
32 | |
23 | |
16 |