Not sure the terminology of making a list of martial arts belts in appsheet
Our belt order is :
White -> Blue/White -> Blue -> Red / White -> Red -> Orange/White -> Orange -> Yellow/White -> Yellow -> Green/White -> Green -> Purple/White -> Purple -> Brown/White -> Brown -> Black/White -> Black 1st Dan -> Black 2nd Dan -> Black 3rd Dan -> Black 4th Dan and so on
To make things easier when doing gradings im looking if it is possible to [Belt] + 1 or something like that so [Belt] (Red) + 1 = [Belt](Orange/White)
is that doable?
Hello @TKSLuke, you can create a table called "belts" with columns id, belt, and a number for ordering the belts, or even a reference to the next belt, so then you can dereference/lookup the next belt.
If you're not feeling like making a new table, an ugly switch expression will do as well, something like this:
SWITCH([Belt],
"White","Blue/White",
"Blue/White",Blue",
. . . .
)
And so on
User | Count |
---|---|
43 | |
26 | |
24 | |
14 | |
12 |