Making a CUSTOM List

AppSheet AppSheet Q&A
,
1

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

is that doable?

2

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