The Spreadsheet and Google Docs

Status
Not open for further replies.

achrisvet

Member
Hi! I'm a veterinarian trying to use the spreadsheet to monitor my diabetic patients. I have one cat well regulated, and I'm about to start another.

This is a tech question on using Google docs. I used Dr. Lisa's instructions that I sent to the first client and she successfully made a spreadsheet and sent me a link. I don't see how to save the document to Google docs. What I've been doing is gong back to her first email with the link. Isn't there a way to save it to Google docs? If I'm going to have several cats going at once, I want to make it simple to look at all the spreadsheets, and also make it possible to monitor them from my smartphone when I'm away from the computer.

And did I hear right that Google docs has changed the method of sharing the spreadsheets?

Thanks.
 
They can share with you using the share button on the right hand side at the top. Using the url on that section puts their spreadsheet in your google docs list. Once they send you the url and choose Share with Anyone who has the link, it should work.

The other option is to use the Publish to the Web choice under File on the left hand side under the title. If they use that method to share, you can view it if you have the link but it won't be in your goggle docs list.
 
Hi
I've sent a PM to one of our most skilled googledocs folks, who hopefully will drop by soon to help you out.
Are you using the same template that we use, or is this a SS you've created yourself?

Carl in SC
 
The other option is to use the Publish to the Web choice under File on the left hand side under the title. If they use that method to share, you can view it if you have the link but it won't be in your goggle docs list.

That might be my problem. These are the instructions I had:

B. Publishing your SS

1) Click on the ARROW next to the word SHARE in the upper right corner. (See picture below.)

3) Click on PUBLISH AS WEBPAGE.



4) Click the box that says AUTOMATICALLY RE-PUBLISH WHEN CHANGES ARE MADE. (See picture below.)

5) Copy the http link generated for you in the box at the bottom. (See picture below.) (To copy, click and drag to highlight the code and then either right click COPY or use control + c or command + c to copy the link from the second circled part in the picture.)
 
Google Docs has changed.... again

To Publish a document, follow these instructions:

Click on File in the document toolbar and then choose Publish to the Web.

Make sure that there is a check mark next to Automatically republish when changes are made.

Click on the Start Publishing button.

If a box saying "Are you sure you want to publish this document?"appears, click on OK.

Copy the link in the Document link box.

Paste the link into your signature.
 
So it sounds like I should have people choose Share and send it to the special email address I set up for this instead of Publish to the web, is that right? If they do that, will changes automatically show up when they enter data?

I'm OK with the medical part, but the tech part is confusing to me.
 
So you want to have a client's SS in your list of Google Docs, not just be able to view it?

You want you clients to use the Share option then.

Click on the blue Share button at the top right corner of the document. OR, click on File in the document toolbar and then choose Share.

In the box that appears, have your clients put your email address in the Add people box.

Right under that box in teeny tiny kind of grayed out print it says Editors will be allowed to add people and change the permissions. Your clients need to click on the little Change link next to that sentence.

In the Sharing Settings box that appears, your clients need to select the second option, Only the owner can change the permissions. That is for security reasons.

Then click on Save.

Your client's SS should appear in your list of Documents shortly. Not sure if you will get an email confirming this or not.
 
squeem3 said:
So you want to have a client's SS in your list of Google Docs, not just be able to view it?

You want you clients to use the Share option then.

Click on the blue Share button at the top right corner of the document. OR, click on File in the document toolbar and then choose Share.

In the box that appears, have your clients put your email address in the Add people box.

Right under that box in teeny tiny kind of grayed out print it says Editors will be allowed to add people and change the permissions. Your clients need to click on the little Change link next to that sentence.

In the Sharing Settings box that appears, your clients need to select the second option, Only the owner can change the permissions. That is for security reasons.

Then click on Save.

Your client's SS should appear in your list of Documents shortly. Not sure if you will get an email confirming this or not.


Thanks so much. I have saved your instructions and will write up new directions for my clients. I hope Google doesn't keep changing things!
 
achrisvet said:
Thanks so much. I have saved your instructions and will write up new directions for my clients. I hope Google doesn't keep changing things!

I had a thought... if you have multiple clients who will be sharing their SS with you, it would be helpful if the clients could put their cat's name and the name of the insulin in the title of the SS. Like "George's blood glucose numbers on Lantus insulin". That way when you look at your list of documents you can easily see who each SS belongs to and what insulin is being used instead of just the default "TEMPLATE_ 12_12 insulin spreadsheet".

To edit the name of a SS, your clients can go to their list of Google Documents, put a check mark nex to their SS, click on the More button at the top of the list of documents, and then choose Rename. Enter the new name of the SS and click on OK.

I hope Google doesn't make anymore changes ohmygod_smile
 
Status
Not open for further replies.
Back
Top