Google Spread Sheets-Help Needed - Insight Central: Honda Insight Forum
 
Go Back   Insight Central: Honda Insight Forum > Off Topic Section > Honda Insight Lounge

Insightcentral.net is the premier Honda Insight Forum on the internet. Registered Users do not see the above ads.
Reply
 
LinkBack Thread Tools
Old 07-29-2017, 04:39 PM   #1 (permalink)
Moderator
 
Join Date: May 2009
Location: Richmond VA
Posts: 6,501
Default Google Spread Sheets-Help Needed

As the owner of the Insight Registry, a google spreadsheet, I have been trying to open the sheet so that anyone with the link could edit it themselves. By doing so, I hope to achieve some updating of the sheet.

BIG PROBLEM. I have set the access as seen here:

https://www.insightcentral.net/forums...-registry.html

I have also set the sharing options to "anyone with link can edit."

It still doesn't work for non owners????

Anyone know how to get this thing open???
__________________
2000 MT Citrus(DogBite); 2000 MT Citrus LTO Conversion; 2001 MT(Aeromodded Hypermiler - 134.4MPG); 2006 MT
jime is offline   Reply With Quote Quick reply to this message
Sponsored Links
Advertisement
 
Old 07-29-2017, 06:14 PM   #2 (permalink)
Senior Member
 
Willie Williford's Avatar
 
Join Date: Mar 2003
Location: Campo, Ca.
Posts: 9,451
Default

Do not have a citrus, and it allowed me in.

Willie
__________________
01 MT "Little Red Rocket"
The first "TURBOCHARGED" Hybrid, Insight G1-(01/2003)@65K miles. RIP 334K
MaxIMA Battery (Serial #2), on 8/25/12 @ 301,000 miles
Another MaxIMA Battery, on 6/25/17 @ 399,252 miles
Use: 438,000 mi. @ 58.2 LMPG.



To view links or images in signatures your post count must be 2 or greater. You currently have 0 posts.


To view links or images in signatures your post count must be 2 or greater. You currently have 0 posts.


To view links or images in signatures your post count must be 2 or greater. You currently have 0 posts.
Willie Williford is offline   Reply With Quote Quick reply to this message
Old 07-29-2017, 06:47 PM   #3 (permalink)
Moderator
 
Join Date: May 2009
Location: Richmond VA
Posts: 6,501
Default

Quote:
Originally Posted by Willie Williford View Post
Do not have a citrus, and it allowed me in.

Willie
From feedback I get, it lets everyone in but it doesn't allow a citrus owner to edit or enter their information.

I can't test it myself since I am owner of the spread sheet.
__________________
2000 MT Citrus(DogBite); 2000 MT Citrus LTO Conversion; 2001 MT(Aeromodded Hypermiler - 134.4MPG); 2006 MT
jime is offline   Reply With Quote Quick reply to this message
Sponsored Links
Advertisement
 
Old 07-29-2017, 07:03 PM   #4 (permalink)
Hypermiler
 
Mountain driver's Avatar
 
Join Date: Jun 2012
Location: Central PA
Posts: 3,649
Garage
Default

Tried it again. I can open and read it, but cannot enter data.

My dinosaur abilities are no help with a solution.
__________________
...Bob
'01 cvt, Red , 222k,
To view links or images in signatures your post count must be 2 or greater. You currently have 0 posts.
, IMAC&C
'01 mt, Silver, 222k,
To view links or images in signatures your post count must be 2 or greater. You currently have 0 posts.
, MIMA, currently "
To view links or images in signatures your post count must be 2 or greater. You currently have 0 posts.
"
'00 Citrus,, 184k,
To view links or images in signatures your post count must be 2 or greater. You currently have 0 posts.
, MIMA,
To view links or images in signatures your post count must be 2 or greater. You currently have 0 posts.

'01 mt, Oxy Blue, 218k

Go Navy, or don't go
To view links or images in signatures your post count must be 2 or greater. You currently have 0 posts.
Mountain driver is offline   Reply With Quote Quick reply to this message
Old 07-29-2017, 10:00 PM   #5 (permalink)
Senior Member
 
Join Date: Oct 2011
Location: Sunnyvale, CA
Posts: 157
Default

I took a look, and it seems like you have two sheets in the document. Sheet 1, which has all the relevant info, is locked and not editable by the public. Sheet 2, which is empty, appears to be editable by anyone. I think when you were trying to set the document to public, that 2nd sheet was made, and that was set to public.
dsteele713 is offline   Reply With Quote Quick reply to this message
Old 07-30-2017, 11:08 AM   #6 (permalink)
Moderator
 
Join Date: May 2009
Location: Richmond VA
Posts: 6,501
Default

Quote:
Originally Posted by dsteele713 View Post
I took a look, and it seems like you have two sheets in the document. Sheet 1, which has all the relevant info, is locked and not editable by the public. Sheet 2, which is empty, appears to be editable by anyone. I think when you were trying to set the document to public, that 2nd sheet was made, and that was set to public.
I rummaged through the deep guts of the "permissions" structure and it looks like you are right. Sheet 1 was protected, while sheet 2 was open. I now "think" I have changed the permissions for sheet 1. Please give it another try.

Or any citrus owner who wants to update their VIN with last four digits
__________________
2000 MT Citrus(DogBite); 2000 MT Citrus LTO Conversion; 2001 MT(Aeromodded Hypermiler - 134.4MPG); 2006 MT

Last edited by jime; 07-30-2017 at 11:14 AM.
jime is offline   Reply With Quote Quick reply to this message
Old 07-30-2017, 12:48 PM   #7 (permalink)
Senior Member
 
AbCaRed00's Avatar
 
Join Date: Mar 2011
Location: 🇨🇦
Posts: 1,558
Default

The cell data entry appears to be working ok with a quick 'test' entry [and subsequent deletion] at bottom of column.
AbCaRed00 is offline   Reply With Quote Quick reply to this message
Old 07-30-2017, 01:44 PM   #8 (permalink)
Moderator
 
Join Date: May 2009
Location: Richmond VA
Posts: 6,501
Default

YES. It is working correctly now
__________________
2000 MT Citrus(DogBite); 2000 MT Citrus LTO Conversion; 2001 MT(Aeromodded Hypermiler - 134.4MPG); 2006 MT
jime is offline   Reply With Quote Quick reply to this message
Sponsored Links
Advertisement
 
Reply

Quick Reply
Message:
Options

Register Now

In order to be able to post messages on the Insight Central: Honda Insight Forum forums, you must first register.
Please enter your desired user name, your email address and other required details in the form below.
User Name:
Password
Please enter a password for your user account. Note that passwords are case-sensitive.
Password:
Confirm Password:
Email Address
Please enter a valid email address for yourself.
Email Address:
Location (Required)
Where you live
Insurance
Please select your insurance company (Optional)

Log-in


Thread Tools

Posting Rules
You may post new threads
You may post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Powered by vBadvanced CMPS v3.2.3

All times are GMT -4. The time now is 05:02 PM.



Powered by vBulletin® Copyright ©2000 - 2019, vBulletin Solutions, Inc.
User Alert System provided by Advanced User Tagging (Pro) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
vBulletin Security provided by vBSecurity v2.2.2 (Pro) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.