topic Re: Associated sheet response from form access denied in Peer-Peer Topics

Associated sheet response from form access denied

alexgrutza — Tue, 09 Apr 2024 13:23:54 GMT

I was working with someone that was having several Google issues it seemed all at one time (such as 2k+ emails being "read" and apparently deleted not by the user), but this issue is only related to Google Forms.

The user has a Google Form in a Shared Drive that her and a student have access to (Manager and Editor rights where applicable). The Form was new, and so there was no Sheet attached to it.

At some point (we're unsure when), the Sheet was created (and the owner is the student) and responses were gathered (39 responses via the Form response page), but the Sheet only has 29 responses captured. As far as the Faculty is aware no records were deleted from the Sheet.

Here's where it gets weird. The "View in Sheets" link within the Form, when clicked, prompts a "Request Access" page. There is the response Sheet within the same Shared Drive location (as expected), but when you open that file it only has the 29 responses (not the 39 the Form recorded) and the Faculty has access to the Sheet.

TL;DR: Faculty and student have access to a Shared Drive where a Form is located (along with the response Sheet tied to the Form). The Faculty cannot open the Sheet via the "View in Sheet" link within the Form, but can open the Sheet from within the Shared Drive location. The Form recorded 39 responses, but the Sheet only has 29 responses recorded.

The primary question is: any ideas why the Faculty doesn't have access to "View in Sheets" link within the Form page but can click on the Sheet within the Shared Drive itself (albeit missing data)?

Re: Associated sheet response from form access denied

Kim_Nilsson — Tue, 09 Apr 2024 14:20:23 GMT

The file in the Shared Drive is probably not the sheet linked inside the Form.

You should easily see that the FileID is different when you reach the Request Access page.

A Sheets file can be unlinked from a Form. Then any access rights can be set on the file.

Yes, it is strange that a Form you have edit access to will not let you access the linked Sheets file, but I know why.

The Sheets originally linked to the Form has been moved outside of the Shared Drive.

Thereby losing all shared access assigned to the Forms file.

I just verified that's exactly what happens.

Re: Associated sheet response from form access denied

alexgrutza — Tue, 09 Apr 2024 15:02:08 GMT

It's still a little confusing. Wouldn't every file (Form, associated Sheet/response) have it's own unique FileID? Or you're saying the file "request access" is FileID-1234 and the Sheet with responses in the same location as the form is FileID-987? I guess I did not make note of the FileID of the two separate sheets (request access and the one residing in the shared drive).

I would say that without knowing what the Faculty/Student did, I too believe the original file was moved, then a new Sheet was recreated and linked to the form for responses, but cannot confirm that is what happened.

Re: Associated sheet response from form access denied

Kim_Nilsson — Tue, 09 Apr 2024 15:17:03 GMT

You should be able to see those actions in the Drive Audit Log.