FIRENSIA/Sortable Table

I have been struggling with four things:

1. Build tables without going crazy
2. Edit tables without going crazy
3. Make sortable tables without going crazy
4. Make an Excel template where I can paste in normal shop data and autobuild a table quickly

That's why I am experimenting on this page. Please overlook the mess if you are peeking in here, thanks.

Example 1, Basic Sortable Table

You can play with this table! Click the little arrow in the heading cells a few times to see how it works to sort each row backwards and forwards.

{| class="wikitable sortable" style=width: "95%";
!Number
!Item
!Price
!Weight
!Enchant
!Notes
|-
| A || a grey dagger || 30 || 2 pounds || 9x (+45) || OHE weapon
|-
| B || a blue cudgel || 20 || 5 pounds || 8x (+40) || OHB weapon
|-
| C || a pink discus || 10 || 4 pounds || 7x (+35) || Thrown weapon
|-
| D || a teal cestus || 40 || 3 pounds || 6x (+30) || UCS weapon
|-
|}


The above wiki markup text makes the below Sortable Table:


Number

Item

Price

Weight

Enchant

Notes


A
a grey dagger
30
2 pounds
9x (+45)
OHE weapon


B
a blue cudgel
20
5 pounds
8x (+40)
OHB weapon


C
a pink discus
10
4 pounds
7x (+35)
Thrown weapon


D
a teal cestus
40
3 pounds
6x (+30)
UCS weapon

Example 2, Letters and Numbers

{| class="wikitable sortable" style=width: "95%";
!A Column
!B Column
!C Column
!D Column
!E Column
!F Column
|-
| A1 || B1 || C1 || D1 || E1 || F1 
|-
| A2 || B2 || C2 || D2 || E2 || F2 
|-
| A3 || B3 || C3 || D3 || E3 || F3 
|-
| A4 || B4 || C4 || D4 || E4 || F4 
|-
|}


The above wiki markup text makes the below Sortable Table:


A Column

B Column

C Column

D Column

E Column

F Column


A1
B1
C1
D1
E1
F1


A2
B2
C2
D2
E2
F2


A3
B3
C3
D3
E3
F3


A4
B4
C4
D4
E4
F4

Example 3, Blanks

{| class="wikitable sortable" style=width: "95%";
!Number
!Item
!Price
!Weight
!Enchant
!Notes
|-
|A||________||________||________||________||________
|-
|B||________||________||________||________||________
|-
|C||________||________||________||________||________
|-
|D||________||________||________||________||________
|-
|}


The above wiki markup text makes the below Sortable Table:


Number

Item

Price

Weight

Enchant

Notes


A
________
________
________
________
________


B
________
________
________
________
________


C
________
________
________
________
________


D
________
________
________
________
________

Horizontal Row Markup, Numbered

The markup here is horizontally structured, making it easier to fill in the blanks "now" I think.

{| class="wikitable sortable" style=width: "95%";
!Number
!Item
!Price
!Weight
!Enchant
!Notes
|-
|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||________||________||________||________||________
|-
|}

Vertical Row Markup, Numbered

The markup here is vertically structured, making it easier to edit "later" I think.

{| class="wikitable sortable" style=width: "95%";
!Number
!Item
!Price
!Weight
!Enchant
!Notes
|-
|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
|________
|________
|________
|________
|________
|-
|}

Mindless Table Banter

Just so I don't forget why I originally made this page:

I'm hoping to figure out how to make sortable tables without going crazy. What I've learned so far is that the main thing that makes a sortable table is its beginning line and also making any row heading start with an exclamation point ("!") if you want that particular row to be sortable.

I am also trying to figure out how to make it easier to build normal town shop tables using Excel to fill in a template with the info, which would reduce my build time in a huge way. This page is where I'm experimenting with sortable table building, as part of that effort.

In edit mode, the blanks in my tables above are double-clickable to highlight the blank, to efficiently paste new info, which works fine if my Excel idea does not work. Two ways to make the same table are listed above, one with row information listed horizontally, which helps me visualize the table structure better and not make mistakes when pasting info, and the other with row information listed vertically, which as Siggurd pointed out, makes going back to edit the table a bit easier. I filled in the numbers 1 through 60 because no shop I ever saw has more than 60 items in one room. So the blank templates will allow me at least to not have to fill in the item numbers over and over and over.

My table quandary is how to fill in a table without my half-brain making bad mistakes, while still leaving the table more easily editable by other people. So while the horizontal row editing is easier for me, the vertical row editing seems to be easier for other people. I don't know if there's a "right" and "wrong" way to do table markup really, because both ways work. But I would like to learn to build tables that other people will be happier editing later. Once I am better at building tables in general, I hope to ask the question on Discord if I haven't yet found a wiki help page that specifies a preferable way to do tables.

If you're still reading this, you have got some awesome patience. Treat yourself to a nice cup of tea or coffee or water or milk and enjoy it.