Making a CUSTOM List

[TKSLuke]

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?

[Rafael_ANEIC-PY]

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