6/12: PLEASE READ: Spreadsheet information

Discussion in 'Lantus / Levemir / Biosimilars' started by Cyn and Cosmo, Jun 12, 2010.

Thread Status:
Not open for further replies.
  1. Cyn and Cosmo

    Cyn and Cosmo Member

    Joined:
    Dec 28, 2009
    Hello everyone!

    Please check the link to your spreadsheet. If you put your cursor over the link to your spreadsheet (but don't click!), the address should show at the VERY VERY bottom left of your browser window.

    If you see "pub" in the link, you can stop reading.

    If you see "ccc" in the link, please follow the directions below.

    1) Log into google docs and your spreadsheet
    2) Click on "share" button on the upper right side of your spreadsheet
    3) Choose "publish as a web page"
    4) make sure the box for "automatically republish when changes are made" is CHECKED.
    5) grab the URL that is generated for you there. It should have "pub" in the address, NOT ccc.

    5) Copy it (ctrl + c or command + c)
    6) come back to FDMB, and put it in your signature line.

    If you'd like for it to show as text link (like mine below)
    1) paste the URL where I have "paste your URL here"
    2) Replace "name of your SS here" with whatever you want to call the Spreadsheet
    3) copy the entire code and paste it into your signature.

    Code:
    [url=paste the URL here]Name of your Spreadsheet here[/url]

    Why am I asking you to do this? The 'ccc' URL links take up space in other people's google documents list. So, if I click on a SS link that says "ccc" that SS is automatically listed in my google docs list. Not a huge deal, but if you are someone who uses google documents a lot, having over 100 spreadsheets taking up space is not optimal.

    Please take the time to follow the directions above. If you need additional assistance, you can either PM me, or post in the TECH forum for help.
     
  2. Ronnie & Luna

    Ronnie & Luna Well-Known Member

    Joined:
    Dec 28, 2009
    BUMP!


    oooohh I wonder if this is why SS's are taking forever to close, I have to click 3x's for a SS to close


    thanks for posting Cyn! Will check it out!
     
  3. Roni and Moonie

    Roni and Moonie Well-Known Member

    Joined:
    Dec 28, 2009
    CYN!! You were the one who got my SS up & running a long time ago--Just want to say Thanks!!
    BUMP!
     
  4. Lisa and Do Lou (GA)

    Lisa and Do Lou (GA) Well-Known Member

    Joined:
    Jan 10, 2010
  5. Linda and Crash (GA)

    Linda and Crash (GA) Member

    Joined:
    Jan 5, 2010
  6. squeem3

    squeem3 Well-Known Member

    Joined:
    Dec 28, 2009
    Bump :smile:
     
  7. Ele & Blackie (GA)

    Ele & Blackie (GA) Well-Known Member

    Joined:
    Dec 28, 2009
    Help, please. I made the changes, but now when you click on Blackie's Spreadsheet I get a google error. What did I do wrong?
     
  8. Ele & Blackie (GA)

    Ele & Blackie (GA) Well-Known Member

    Joined:
    Dec 28, 2009
    Thanks Cyn. I got it working. It was just my stupid typing.
     
  9. Ronnie & Luna

    Ronnie & Luna Well-Known Member

    Joined:
    Dec 28, 2009
  10. Ronnie & Luna

    Ronnie & Luna Well-Known Member

    Joined:
    Dec 28, 2009
    looks like I goofed, I got an error when I tried to fix it.

    CYNNNNNN!!!! :D
     
  11. Ronnie & Luna

    Ronnie & Luna Well-Known Member

    Joined:
    Dec 28, 2009
    I did it I did it! did I do it Cyn? Is it right now? :D
     
  12. Cyn and Cosmo

    Cyn and Cosmo Member

    Joined:
    Dec 28, 2009

    WOO HOO!!

    GO RONNIE!!!
     
  13. heidi and doodles

    heidi and doodles Member

    Joined:
    May 10, 2010
    bump...phew I'm good to go.
     
  14. jan and Hep and sara (GA)

    jan and Hep and sara (GA) Well-Known Member

    Joined:
    Dec 28, 2009
    That explains why I had SuperMax's profile in my google docs. I had clicked on it once to read. It's gone now. But I did think that was awful strange. :smile:

    Thanks and BTW just last night I finally on my own got a ss put into my signiture. Somebody else had done it for me before. So thanks for the stickie, it worked out great!
     
  15. squeem3

    squeem3 Well-Known Member

    Joined:
    Dec 28, 2009
  16. Lydia & Sid & Jake(GA)

    Lydia & Sid & Jake(GA) Well-Known Member

    Joined:
    Feb 16, 2010
    Thank you for the instructions.
     
  17. squeem3

    squeem3 Well-Known Member

    Joined:
    Dec 28, 2009
  18. Sienne and Gabby (GA)

    Sienne and Gabby (GA) Senior Member Moderator

    Joined:
    Dec 28, 2009
  19. squeem3

    squeem3 Well-Known Member

    Joined:
    Dec 28, 2009
    Bumping for all the newbies.
     
  20. Ronnie & Luna

    Ronnie & Luna Well-Known Member

    Joined:
    Dec 28, 2009
  21. Sienne and Gabby (GA)

    Sienne and Gabby (GA) Senior Member Moderator

    Joined:
    Dec 28, 2009
  22. Kathy and Kitty

    Kathy and Kitty Well-Known Member

    Joined:
    Dec 29, 2009
    Bump. And if anyone needs me to change your URL in the LL master spreadsheet, respond here or PM me, and I'll take care of it!
     
  23. Ronnie & Luna

    Ronnie & Luna Well-Known Member

    Joined:
    Dec 28, 2009
  24. Lydia--(Rosie & Basil) GA

    Lydia--(Rosie & Basil) GA Well-Known Member

    Joined:
    Dec 28, 2009
  25. squeem3

    squeem3 Well-Known Member

    Joined:
    Dec 28, 2009
    Bumping up for newbies.
     
  26. Lydia--(Rosie & Basil) GA

    Lydia--(Rosie & Basil) GA Well-Known Member

    Joined:
    Dec 28, 2009
  27. Lisa dvm

    Lisa dvm Member

    Joined:
    Dec 28, 2009
    Minor detail here but...I did as stated above and clicked on the "share" BUTTON....but no "publish as a web page" showed up.

    What really needs to be done is to click on the "share" ARROW next to the button.

    Cyn, thanks again for posting the directions. They have been a HUGE help for me and my clients!!!
     
  28. squeem3

    squeem3 Well-Known Member

    Joined:
    Dec 28, 2009
  29. Jill & Alex (GA)

    Jill & Alex (GA) Senior Member Moderator

    Joined:
    Dec 28, 2009
  30. julie & punkin (ga)

    julie & punkin (ga) Well-Known Member

    Joined:
    Feb 17, 2011
    i can see that punkin's ss shows the "ccc" in the link, but when i go to his spreadsheet there is nothing in the upper right hand corner to change, ie, there is no "share" to even be able to change it to publish. i've tried logging out of FDMB and logging in to the spreadsheet first, but it still shows as ccc.

    i also look in the google docs instructions on how to change your sharing, but there's no share button anymore for me to be able to do that.

    help?

    which, btw, i'm still on vacation with intermittent internet, so i wouldn't be able to respond soon to directions. thanks for the help.
     
  31. squeem3

    squeem3 Well-Known Member

    Joined:
    Dec 28, 2009
    Being logged onto FDMB has no effect (or at least shouldn't) on your SS in Google. You can log into your SS by clicking on the Sign In button at the very top right corner of the SS.

    Or, try logging directly into Google in a new browser window or tab: http://docs.google.com From your list of documents, open your SS. The Share tab will be in the top right corner near your logged in name. Click on the little arrow on the Share tab to get the box with the Publish as web page option.

    Try a different web browser if the one you typicalyl use doesn't work. Sometimes Google is finicky about web browsers.
     
  32. Mike&Buddy

    Mike&Buddy Well-Known Member

    Joined:
    Jan 23, 2011
    Um, mine has a "cc", not "CCC".... :?:
     
  33. squeem3

    squeem3 Well-Known Member

    Joined:
    Dec 28, 2009
    The link in your signature is http://tiny.cc/oisjy which redirects to the
    correctly published SS at https://spreadsheets.google.com/pub...NkdEFmM1dmNl95d2FBNmtwalVnN3kwaGc&output=html Your signature link is fine :thumbup It's fine to use a web site such as Tinyurl.com to shorten a loooong link :smile:

    You just don't want the actual SS link to contain ccc in it. Example: spreadsheets.google.com/ccc....

    A correct SS link will contain pub in it. Example: spreadsheets.google.com/pub......
     
  34. Christie & Willie (GA)

    Christie & Willie (GA) Well-Known Member

    Joined:
    Dec 8, 2010
  35. squeem3

    squeem3 Well-Known Member

    Joined:
    Dec 28, 2009
  36. squeem3

    squeem3 Well-Known Member

    Joined:
    Dec 28, 2009
    Bump up for newbies.
     
  37. julie & punkin (ga)

    julie & punkin (ga) Well-Known Member

    Joined:
    Feb 17, 2011
    apparently it's not just an issue with windows 7 - someone posted that they had trouble with other operating systems as well. i haven't gotten an answer yet from the google help desk about it.
     
  38. squeem3

    squeem3 Well-Known Member

    Joined:
    Dec 28, 2009
  39. Teresa and Poopy

    Teresa and Poopy Well-Known Member

    Joined:
    Dec 17, 2011
    I am usually great using anything on the computer, but trying to get a url with pub in it is proving futile. I don't have the option. When I click on Share, it gives me the option of: keeping it private, to list folks to have access, or to give link for access. Grrrrrrr
     
  40. The "publish to the web" option is no longer from the "share" button. Googledocs changed their site...

    In order to publish, click on the "file" menu. You'll see the option there.
    Carl
     
  41. Ann & Tess GA

    Ann & Tess GA Well-Known Member

    Joined:
    Jan 7, 2010
    Thanks for the new info Carl. Maybe this thread should be locked and a new one started w/ the changed instructions. It' would be frustrating for new member to follow the old ones only to see the change at the bottom!
     
  42. julie & punkin (ga)

    julie & punkin (ga) Well-Known Member

    Joined:
    Feb 17, 2011
    i would add that i have been unable to get mine changed to pub - i use a netbook and google chrome, and only have installed a windows starter pack on it. i tried to use other computers that had the whole works, tried to use other browsers, and didn't succeed. apparently there have been problems with windows-based software and this.

    so someone else made me a new spreadsheet for punkin and transferred the ownership to me.
     
  43. Teresa and Poopy

    Teresa and Poopy Well-Known Member

    Joined:
    Dec 17, 2011
    Woot! Woot! Thank you so much for the information. It worked! :D
     
  44. I think Squeem3 posted the updated instructions on the Tech Forum a couple weeks ago. This will work until the next time google docs decides to change things!

    Carl
     
  45. squeem3

    squeem3 Well-Known Member

    Joined:
    Dec 28, 2009
    Current instructions as of 12/27/2011 to get a SS template and how to correctly publish for sharing with others is here -----> http://felinediabetes.com/FDMB/viewtopic.php?f=6&t=50130&p=586250#p586250

    All other instructions (the original SS instruction sticky at the top of Tech, instructions at the top of this thread, old threads on Health, etc) are out of date and no longer work because of changes Google has made to their Documents.
     
  46. april925

    april925 Well-Known Member

    Joined:
    Jun 20, 2011
    Mine says pub, but I still have other ss in my documents list. Can you just delete them?
     
  47. Randa & Mookie

    Randa & Mookie Well-Known Member

    Joined:
    Nov 28, 2011
  48. Sienne and Gabby (GA)

    Sienne and Gabby (GA) Senior Member Moderator

    Joined:
    Dec 28, 2009
    PLEASE DO NOT BUMP

    PLEASE DON'T KEEP BUMPING THIS THREAD.

    The info from June 2010 is not reflective of the links we give new members. We give them the one the Squeem3 provided.



    Edited to add: I'm closing this thread so it will no longer be bumped to the top. The info is out dated.
    Please post SS related questions and problems in the Tech Forum.
    Thank you!
     
Thread Status:
Not open for further replies.

Share This Page