Forum Table Generator

[SwiftSmoky 8,445]

It's very simple, it's a Google Spreadsheet that generates code for posting tables in the forum. The titles in the spreadsheet explain pretty much everything so you can figure it out by yourself, but if you still don't understand something you can find the explanation in this topic :)

 

Link: https://docs.google.com/spreadsheets/d/1ecxqkWsXmgxGPlbthxLmfyKg8qhgO-Ip8Ifx3fZsSgI/edit?usp=sharing

 

Forun tables look like this:

 

 

Parkour Survival 2017 contest winners:

 

Team name

Members

Traceur Enthusiasts@BlazingShot, @Krutik_love, @iMoneyMaker, , GTT@I.Destiny, @Marekos1111, @Kenzy, @Bugatti, @sterre933Team Dogs@Mission, @i.Alfi, @V.I.P.15, @Bubo, @notakneeeThe Flying Parkourists Veterans@Nikk, @jox99, @Hate, @Torben_BoS, @skeletorXVIIIVayreniner, @Rom, , @Erik, @UnderstandThe Milky Juniors @Ghost_Animators, @Ghost_Animator_XP, @emrakul, @shresthkhandelwal, @rishabhhauntThe Dutch Flyers@Flyer, @I.Legend.I, , @Virtuoos, @Mr.SkiIIZz

 

 

 

Important: if you are working on a long term or secret project, better copy the whole thing to your own private spreadsheet, otherwise other people might try to use the table generator before you're done and will replace your stuff with theirs.

 

---

 

The table's content

 

Everything you see below the purple row (including the purple row itself) is the text that will be in the table on forum. The purple row is for column titles that will appear in the forum table too, the only special thing about the titles row is that it allows simple text only - special features like prefix/suffix and @-links don't work on this row.

 

 

Display settings

 

These YES/NO cells are to choose which rows and columns you want to include in the table and what you want to stay out of it.

Make sure you don't include empty rows and columns in the table, they will take space even if there is no text in them.

 

 

Posting the table in the forum

 

There is a yellow cell on the top left of the spreadsheet, copy the code from it and paste it in the forum. It will look like just text while you're editing your post but once you post it, it will become a table.

 

 

Prefix and suffix

 

On top of the table there is a "prefix" row and a "suffix" row, they give you the option to add text to the beginning (prefix) and the end (suffix) of every cell in a specific column. For example, if you want a column with nicknames of players to be displayed like "@SwiftSmoky" instead of just "SwiftSmoky", you need to use the [member=nickname] code. So you need to add "[member=" prefix in the nicknames column, and a ]" suffix.

 

 

@-links

 

You can use @-links to automatically include text from a different cell in the same row. Write "@X" with the letter of the linked column instead if "X", and in the final table the @-link will be replaced with the text from the linked cell, including it's prefix and suffix.

@-links work in prefix and suffix too, but for now they ignore the prefix and suffix of their target cell, I'll fix it later.

 

Example

 

 

 

 

The resulting table:

 

Nickname	Parkour club
SwiftSmoky	Fight & Flight
Nikk	The Flying Parkourists
Mr.L0NELY	Never Give Up

 

---

 

Explanation: 

 

The text "@E" in the prefix of column D is like a link to column E. The prefix is added to every row in column D, resulting in text like this:

 

Fight & Flight[/url]

 

Then the @-link (@E) gets replaced with the text in the linked column (E) resulting in a full BB code for a text with the club name linking to the forum topic if this club:

 

Fight & Flight[/url]

 

Note: column E is set to not be included in the table, this doesn't affect @-links. If it was included in the table you would get both the club names with the link, and a column with the links alone.

 

 

 

Technical note (in case you're trying to do soething coplicated with @-links)

 

 

This may be complicated for some people, but if you don't plan to do anything very complicated with @-links you don't need to learn this.

 

The order @-links are converted is as follows:

 

It starts at the most left cell, then going to the right. So if you have the following text:

column C	column D
Hello @D!	Hello @C!

 

First thing that will happen is the left column's @-link will be converted:

column C	column D
Hello Hello @C!!	Hello @C!

 

Then the next column to the right will be converted:

column C	column D
Hello Hello @C!!	Hello Hello Hello @C!!!

 

 

The order in which @-links are converted within a cell is fron high to low (@P is first, @C is last).

 

So in this case:

C	D	E
C: @E	Hello	E: @D

 

The resulting table will look like this:

C	D	E
C: E: @D	Hello	E: Hello

 

Because @D wasn't in this cell until it was copied to it in the conversion of @E, which comes after the conversion of @D.

 

 

[eSport 486]

Cool :o

Didn't know that, Still people on forum who are smarter than me.

JK everyone is probs

Edited January 3, 2018 by eSport

[Maf 32,305]

Great job!  :o

[Stratosphere 2,234]

Thanks for this awesome tool Swift!  :o

[SwiftSmoky 8,445]

Thanks for this awesome tool Swift!  :o

No problem, I already was using it before and figured some other players might need it as well so I made it public. and now I see people already used it, so good thing I posted it ^_^

[splitterpoint 10,986]

Thanks!

 

I had no idea how to even pull of a code-based table on the forum.

This makes it much easier, will definitely keep an eye on this if I ever start new topics.

[Prince_Of_Railgun290 320]

Lol I can't understand anything

[SwiftSmoky 8,445]

• Posted a better screenshot, makes things a little clearer.

Added row and column count.

[Guest]

Lol I can't understand anything

You're not alone...

[SwiftSmoky 8,445]

New feature

 

You can now use @X links to automatically include text from a different cell in the same row.

The main use of this feature is for making links automatically, as in this example:

 

 

 

The resulting table:

 

Nickname	Parkour club
SwiftSmoky	Fight & Flight
Nikk	The Flying Parkourists
Mr.L0NELY	Never Give Up

 

---

 

Explanation: 

 

The text "@E" in the prefix of column D is like a link to column E. The prefix is added to every row in column D, resulting in text like this:

 

Fight & Flight[/url]

 

Then the @-link (@E) gets replaced with the text in the linked column (E) resulting in a full BB code for a text with the club name linking to the forum topic if this club:

 

Fight & Flight[/url]

 

Note: column E is set to not be included in the table, this doesn't affect @-links. If it was included in the table you would get both the club names with the link, and a column with the links alone.

[SiLEnCeR.T0 143]

I do t really get how this works?

[SwiftSmoky 8,445]

I'll post a full guide later

[SiLEnCeR.T0 143]

Oh ok can you tell me the rough idea?

[Heles 9,220]

Wow

thats a cool idea
I never knew u could do that 

[SiLEnCeR.T0 143]

I mean like what does it do ,like what does the table do?

[SwiftSmoky 8,445]

I mean like what does it do ,like what does the table do?

Not much, it's just a table, to make organised and neat lists, for example look at these topics:

• Index of Parkourists
• "Parkour Survival" Contest - Winners announced!

[SiLEnCeR.T0 143]

Ohhh i get it thx :)

[SwiftSmoky 8,445]

Posted a complete guide on how to use the table generator :)

[govenier 1,202]

U are full of surprises :D

[sre123 595]

This is just great, swift! Thanks a lot! :) ))

[Ralphas 56]

Woow. Well done! 

[rishabhhaunt 1,629]

I like being mentioned  :ph34r:  :ph34r:  :ph34r:

[kaisdf 3,320]

It's very simple, it's a Google Spreadsheet that generates code for posting tables in the forum. The titles in the spreadsheet explain pretty much everything so you can figure it out by yourself, but if you still don't understand something you can find the explanation in this topic :)

 

Link: https://docs.google.com/spreadsheets/d/1ecxqkWsXmgxGPlbthxLmfyKg8qhgO-Ip8Ifx3fZsSgI/edit?usp=sharing

 

 

Forun tables look like this:

 

 

Parkour Survival 2017 contest winners:

 

Team name

Members

Traceur Enthusiasts@BlazingShot, @Krutik_love, @iMoneyMaker, , GTT@I.Destiny, @Marekos1111, @Kenzy, @Bugatti, @sterre933Team Dogs@Mission, @i.Alfi, @V.I.P.15, @Bubo, @notakneeeThe Flying Parkourists Veterans@Nikk, @jox99, @Hate, @Torben_BoS, @skeletorXVIIIVayreniner, @Rom, , @Erik, @UnderstandThe Milky Juniors @Ghost_Animators, @Ghost_Animator_XP, @emrakul, @shresthkhandelwal, @rishabhhauntThe Dutch Flyers@Flyer, @I.Legend.I, , @Virtuoos, @Mr.SkiIIZz

 

 

 

Important: if you are working on a long term or secret project, better copy the whole thing to your own private spreadsheet, otherwise other people might try to use the table generator before you're done and will replace your stuff with theirs.

 

---

 

The table's content

 

Everything you see below the purple row (including the purple row itself) is the text that will be in the table on forum. The purple row is for column titles that will appear in the forum table too, the only special thing about the titles row is that it allows simple text only - special features like prefix/suffix and @-links don't work on this row.

 

 

Display settings

 

These YES/NO cells are to choose which rows and columns you want to include in the table and what you want to stay out of it.

Make sure you don't include empty rows and columns in the table, they will take space even if there is no text in them.

 

 

Posting the table in the forum

 

There is a yellow cell on the top left of the spreadsheet, copy the code from it and paste it in the forum. It will look like just text while you're editing your post but once you post it, it will become a table.

 

 

Prefix and suffix

 

On top of the table there is a "prefix" row and a "suffix" row, they give you the option to add text to the beginning (prefix) and the end (suffix) of every cell in a specific column. For example, if you want a column with nicknames of players to be displayed like "@SwiftSmoky" instead of just "SwiftSmoky", you need to use the [member=nickname] code. So you need to add "[member=" prefix in the nicknames column, and a ]" suffix.

 

 

@-links

 

You can use @-links to automatically include text from a different cell in the same row. Write "@X" with the letter of the linked column instead if "X", and in the final table the @-link will be replaced with the text from the linked cell, including it's prefix and suffix.

@-links work in prefix and suffix too, but for now they ignore the prefix and suffix of their target cell, I'll fix it later.

 

Example

 

 

 

 

The resulting table:

 

Nickname	Parkour club
SwiftSmoky	Fight & Flight
Nikk	The Flying Parkourists
Mr.L0NELY	Never Give Up

 

---

 

Explanation: 

 

The text "@E" in the prefix of column D is like a link to column E. The prefix is added to every row in column D, resulting in text like this:

 

Fight & Flight[/url]

 

Then the @-link (@E) gets replaced with the text in the linked column (E) resulting in a full BB code for a text with the club name linking to the forum topic if this club:

 

Fight & Flight[/url]

 

Note: column E is set to not be included in the table, this doesn't affect @-links. If it was included in the table you would get both the club names with the link, and a column with the links alone.

 

 

 

Technical note (in case you're trying to do soething coplicated with @-links)

 

 

This may be complicated for some people, but if you don't plan to do anything very complicated with @-links you don't need to learn this.

 

The order @-links are converted is as follows:

 

It starts at the most left cell, then going to the right. So if you have the following text:

column C	column D
Hello @D!	Hello @C!

 

First thing that will happen is the left column's @-link will be converted:

column C	column D
Hello Hello @C!!	Hello @C!

 

Then the next column to the right will be converted:

column C	column D
Hello Hello @C!!	Hello Hello Hello @C!!!

 

 

The order in which @-links are converted within a cell is fron high to low (@P is first, @C is last).

 

So in this case:

C	D	E
C: @E	Hello	E: @D

 

The resulting table will look like this:

C	D	E
C: E: @D	Hello	E: Hello

 

Because @D wasn't in this cell until it was copied to it in the conversion of @E, which comes after the conversion of @D.

 

 

 

 

Since you changed it so view only, I can no longer edit it, and copy + pasta'ing doesn't seem to work  :unsure: 

[SwiftSmoky 8,445]

Since you changed it so view only, I can no longer edit it, and copy + pasta'ing doesn't seem to work  :unsure:

oh sorry, didn't notice that I changed it to view only, changed it back so you can edit now

[Person_Random 4,991]

Thank you so much!  Needed to make a T-chart for a guide!