Page 1 of 1

New forum functionality! embedded google spreadsheets

PostPosted: Sun Mar 13, 2016 12:42 am
Author: avliswebadmin
I'm happy to announce that we've added the ability to embed google doc spreadsheets into forum posts. A few great uses could be inventory tracking a pmerchant for a guild, general ledgers, price lists... or anything spreadsheets are really better at I imagine. Depending on your browser cache and the forum cache, the embedded spreadsheet will stay fairly up to date automatically. (Note, you cannot edit the spreadsheet in a forum post)

To embed a spreadsheet you will need to do the following:

First, in your google spreadsheet that you wish to embed, go to the File menu and select Publish to the Internet. In the Publish window, select the publish button. You should be given a link that will look like the following:

https://docs.google.com/spreadsheets/d/1yOLnTu8KZk9hU9uLndA4-MJm2hJDqBadDbB9-7NDPv8/pubhtml

You will need to copy the id from that url which is the string of characters after the /d/ and before the /pubhtml.. in the example above it is: 1yOLnTu8KZk9hU9uLndA4-MJm2hJDqBadDbB9-7NDPv8

Put this id between the following bbcode tags in your forum posting [gs][/gs]

Here's an example:

Re: New forum functionality! embedded google spreadsheets

PostPosted: Sun Mar 13, 2016 12:55 am
Author: Nighthawk4
Great! :up:

See the Reunion Weekend Schedule as an example :wink:

Re: New forum functionality! embedded google spreadsheets

PostPosted: Sun Mar 13, 2016 4:00 am
Author: Seka
I love it! Have used it in several threads lately. One thing to be aware of: changes you make in a spreadsheet won't immediately be reflected on the forum - it often takes a few minutes for them to be visible. I don't know if that's due to caching or what, but just be patient and they will show up, usually within 5 minutes.