BB Code Enhancements - BBCode - Embed Google Documents Collection (BB Code)

Embed Various Google Docs

Live Demo: Here

Google Docs is a free service by Google. Google Docs are a professional collection of "Office" applications like a Word Processor, Spreadsheet, Presentation Designer, and Drawing tool. Google Docs is a serious alternative to the very expensive Microsoft Office. Documents are stored online, can be shared among users, and in the case of this BB Code they can be embedded in other web pages.

There are several BB Codes in this collection, Google Doc (Document), Google Spreadsheet and Google Presentation. Google Drawings can be embedded using the standard [img] tags but I will give an example here anyway.

You may get a warning message saying the {param}s aren't enclosed in quotes. You can hit "continue" to ignore this error. As you can see in the code there are eventually double-quotes.

When working on any Google Document in the top right of the window will be a "Share" button with drop-down arrow. Click on this arrow and choose "Publish to Web" or "Publish / Embed" and you will be given code to link to and/or embed the document. You will be given a URL such as:
https://docs.google.com/document/pub?id=1bhtK-AhiXqfWK5bGJcULvEO3zMahcFgnJEsT1YvYsuc

What you need is the document ID which is the long string of characters after "id=" or "key=" and before the ampersand (&) if present, in this case your id is:
1bhtK-AhiXqfWK5bGJcULvEO3zMahcFgnJEsT1YvYsuc

In all cases you put the ID between the appropriate tag for the type of document.

Google Document (Word Processor Document)
[gd]1bhtK-AhiXqfWK5bGJcULvEO3zMahcFgnJEsT1YvYsuc[/gd]

Google Spreadsheet
[gs]0AmOHO6Cm8vvAdFR2b0dMMnVwMUE0MlpXYnowWnowWWc[/gs]

Google Presentation
[gp]dcjktv94_1fcpptwqc[/gp]

Google Drawing
No special BB Code is needed to embed a drawing because it's rendered as any other image. Just put the URL given between IMG tags...
[IMG]https://docs.google.com/drawings/pub?id=1C1arwoUzUyzxnzk9yD7ysx6vyMfcDuDXXzQTqnngh2 c&w=640&h=480[/IMG]

To add one or more of these BB Codes follow any of the below instructions:

Add a New BB Code

Title: Google Document
BB Code Tag Name: gd
Replacement:

<div align="center"><iframe src="https://docs.google.com/document/pub?id={param}&amp;embedded=true&gid=0&output=html&widget=true" width="95%" height="500">IFRAME Not Available. <a href="https://{option}.google.com/document/pub?id={param}">Direct Link to Google Document</a>.</iframe></div>

Example:[gd]1bhtK-AhiXqfWK5bGJcULvEO3zMahcFgnJEsT1YvYsuc[/gd]
Description: Embed a Google Document.
Use Option: No
Button Image: (optional)
Remove Tag If Empty: Yes
All Disable Options: Yes

------

Add a New BB Code

Title: Google Spreadsheet
BB Code Tag Name: gs
Replacement:

<div align="center"><iframe width='95%' height='500' frameborder='0' src='https://spreadsheets.google.com/pub?key={param}&hl=en&single=true&gid=0&output=html&widget=true'>IFRAME Not Available. <a href="https://spreadsheets.google.com/pub?key={param}&hl=en&single=true&gid=0&output=html">Direct Link to Spreadsheet.</a></iframe></div>

Example: [gs]0AmOHO6Cm8vvAdFR2b0dMMnVwMUE0MlpXYnowWnowWWc[/gs]
Description: Embed a Google Spreadsheet.
Use Option: No
Button Image: (optional)
Remove Tag If Empty: Yes
All Disable Options: Yes

------

Add a New BB Code

Title: Google Presentation
BB Code Tag Name: gp
Replacement:

<div align="center"><iframe src="https://docs.google.com/present/embed?id={param}" frameborder="0" width="700" height="559">IFRAME Not Available. <a href="https://docs.google.com/present/view?id={param}">Direct Link to Presentation.</a></iframe></div>

Example:[gp]dcjktv94_1fcpptwqc[/gp]
Description: Embed a Google Presentation.
Use Option: No
Button Image: (optional)
Remove Tag If Empty: Yes
All Disable Options: Yes

------

In any of the above codes you can edit the height and width attributes to suit your needs.

------

------------------------------------------------------

Please "Mark as Installed" if you use this.
Donations always appreciated. :up:
Nominate MOTM if you LOVE it!

Check My Profile for other BB Code enhancements. They work on all versions.

Download the .txt file for a copy of the Install instructions.

Screenshots Attached:

[FReeSTER]

Originally Posted by BirdOPrey5

If the sample works on your forum th BBCode is entered correctly.

Your problem is you need to "Publish" your document in Google Docs- instructions were in the link in my previous post.

The dash (-) in the param doesn't matter.

Thank you very much, it worked thanks for your time Joe as always

[sweetpotato]

Thank you for the nice mod. The SpreadSheet work well for single sheet but for multisheets I have to strip out

&single=true

in your code.
May I suggest that you use full link and put double quotes for the security purpose like this

<div align="center"><iframe width="95%" height="500" frameborder="0" src="{param}">IFRAME Not Available. <a href="{param}">Direct Link to Spreadsheet.</a></iframe></div>

[BirdOPrey5]

Thanks for the info on the multi-sheet.

However your second suggestion is a HUGE security risk. Anyone could use the code to open an IFRAME of an arbitrary website.

My original implementation is safe- the warning VB gives can be ignored- VB itself doesn't have a great way of scanning for the {param} between quotes.

[beduino]

I will use in my boards
Thank you joe

[grc]

Does this still work? The GD shared link no longer has id= in it and I'm getting a "not found" message when the id section of the link is used with the tags.

[BirdOPrey5]

it still works...

http://www.qapla.com/mods/showthread...readsheet-test

Instead of the id you take the long string before /edit:

Example:

https://docs.google.com/document/d/1bhtK-AhiXqfWK5bGJcULvEO3zMahcFgnJEsT1YvYsuc/edit

Take the code in red and pot it between:

[gd]1bhtK-AhiXqfWK5bGJcULvEO3zMahcFgnJEsT1YvYsuc[/gd]

[grc]

Originally Posted by BirdOPrey5

it still works...

http://www.qapla.com/mods/showthread...readsheet-test

Instead of the id you take the long string before /edit:

Example:

https://docs.google.com/document/d/1bhtK-AhiXqfWK5bGJcULvEO3zMahcFgnJEsT1YvYsuc/edit

Take the code in red and pot it between:

[gd]1bhtK-AhiXqfWK5bGJcULvEO3zMahcFgnJEsT1YvYsuc[/gd]

Thanks. I hadn't gone to File/Publish to the Web -- missed that step.

[JabirA]

Does it work in 4.1.12?

[BirdOPrey5]

BBCodes work in all VB versions.

[JabirA]

Originally Posted by BirdOPrey5

Thanks for the info on the multi-sheet.

However your second suggestion is a HUGE security risk. Anyone could use the code to open an IFRAME of an arbitrary website.

My original implementation is safe- the warning VB gives can be ignored- VB itself doesn't have a great way of scanning for the {param} between quotes.

I have this problem too.
Do you have a safer suggestion?