This is a topic in Tips & Tricks

Inline Spreadsheet

 
Avatar Andrew Crow 115 posts

I thought this was a neat trick.

This is an inline Google Doc Spreadsheet. It’s displayed with an iFrame. Nothing exciting, but it allows for editing by the client (assuming you give them the ability to edit the spreadsheet online). And is automatically updated. So, instead of doing the Textile table formatting (which looks fine, but is uneditable by anyone who’s not an Admin), this allows for possibly more interactive collaboration.

Here’s the code I used in the Basecamp Message:

<IFRAME width=450 frameborder=0 SRC="http://spreadsheets.google.com/yourspreadsheethere">Text for non-iFrame browsers</IFRAME>
 
Avatar slapshotw 235 posts

That is a great idea, thanks Andrew.

 
Avatar Benjamin Jen... 250 posts

Very sweet idea. I hadn’t even thought of doing something like that. Would certainly help with some of the basic spreadsheets that I’ve tried to put in my internal projects for quick data tracking.

My only question since I haven’t used Google Docs yet, is does the other user need to have a Google account, or is there a way to make ANY user active for edits? Thank you.

 
Avatar Andrew Crow 115 posts

It would be helpful if the other user(s) had Google accounts, but I suppose you could set up a Googe account for that project only, or, rather, for that client. That way, there is a shared log in.

 
Avatar RobertM 3 posts

I did a similar arrangement with Google Calendar.

Works great.

Set it up dedicated calendars and posted the iFrame and link, to project overview via the settings menu,. Via the iCal link, milestones get posted to the calendar. The calendar events are clickable right on the BC overview page.

Just wish we could have calendaring on a tab.

Bob.

 
Avatar Benjamin Jen... 250 posts

Good to know, Andrew. Thank you.

And great tip on the Google Calendar, RobertM.

 
Avatar Ron Crook 1 post

I love this idea Andrew! I pasted in the iframe code you provided as well as the URL for my Google spreadsheet. I see the frame of where the sheet should be but no data is populated in the frame. Any advice for a non-coder? Many thanks!

 
Avatar Tate 4 posts

I second Ron’s request!

This is an awesome advance. I would really, REALLY love to have a google calendar on my overview page or a doc, but sadly have no programing skills. Can anybody simplify (spell out for us dummies) the process we need to go through to make this happen!

 
Avatar richallum 681 posts

I get the whole page from Google showing in the frame – any ideas how I can fix this?

 
Avatar Andrew Crow 115 posts

Sorry, I left out one step.

You need to click the Publish tab in the upper right hand corner of your Google Spreadsheet. This will give you a URL that you then use in in the iFrame code.

Tate, I’ve also done this with Google Calendar a long while back. I will search the old Basecamp forums to find the example. Please hold.

 
Avatar Andrew Crow 115 posts

Here’s the link:

http://basecamphq.com/forum-archive/viewtopic.php?id=1937

 
Avatar Tate 4 posts

Thanks so much Andrew. After a little fooling around this worked great. I also finally caught what you were saying in the first part of this thread (I didn’t realize you could put code in the body of an actual message) and that is cool as well! I really appreciate these tips.

 
Avatar mabrams 3 posts

Hey Andrew – been playing around with this, but the one big issue is having to publish spreadsheets so search engines can crawl them. Do you have any ideas as to how to use a Google Spreadsheet, Zoho, or an alternative where only select people on Basecamp can see it and edit it?

 
Avatar tobystokes 1 post

Can anyone name a browser that supports basecamp, but not iframes?

 
Avatar cooldept 16 posts

i think that browser is IE, not sure what version…
Anybody has a better idea where the iframes work inside basecamp and where they doesn’t?

 
Avatar DaveCraige 56 posts

ok wow. just added my calendar as well. this is awesome. I love this (somewhat unsupported) integration with google services.

truth be told, one of the reasons I took an extra year to sign up for basecamp was because I was using google for everyting. If this integration was supported and advertised more I woulda been a paying member way sooner

 
Avatar Benjamin Jen... 250 posts

Well, welcome to the fold, and you’ll start figuring things out as well.

 
Avatar Mart 2 posts

Is there any way to make the Iframe bigger(higher). The few rows visible makes it unusefull for me. Thanks in advance.

 
Avatar Mart 2 posts

Sry figured it out myself just added a height parameter to the code

 
Avatar robwal 20 posts

I’ve been doing this with Zoho Documents and Sheets. Though I am able to edit the document directly in the iFrame, the edits do not show up in the underlying object (and there is no “save” button). I can edit by clicking on the Zoho logo, which opens a tab with the document.

Are people saying that you can edit and save Google docs directly in the iFrame? Anyone else using Zoho with Basecamp?

Signup or login to post a reply.