Protect Powerpoint presentation on google drive

[YasserKhalil]

Hello everyone
I was watching a video about how to protect PPT on google drive through creating a form ...
After applying the steps and creating the form as described in the video

I take the link of the power point file and put it in a new tab but the form doesn't appear. The access to the file was allowed directly
How can I show the form that protect the ppt file?

Here's the link if any one has an idea

 

[YasserKhalil]

I have tried and clicked "Send" button on Forms google doc and copy the link of the Form itself not the file and everything is ok

I have created a form now with Username and Password (Both required) ..

Also I have a spreadsheet named "Credentials" and I have put usernames and their passwords

How can I edit the form so as to be able to check for the username and password based on "Credentials" file?

 

[Chihiro]

I don't think you can, at least not when I was working with Google docs about 1.5 years ago. You'd do it on the sheet, and activate script editor. But things could have changed.

You'd initialize the script upon form submission.

function Initialize() {
  var triggers = ScriptApp.getProjectTriggers();
  for(var i in triggers) {
    ScriptApp.deleteTrigger(triggers[i]);
  }

  ScriptApp.newTrigger("SendGoogleForm")
  .forSpreadsheet(SpreadsheetApp.getActiveSpreadsheet())
  .onFormSubmit()
  .create();

}

Then will need another function to find match within the sheet. You'd have better luck asking in Google Forum for that part.

 

[YasserKhalil]

Thanks a lot Mr. Chihiro for reply
Can you give me more details please? what is the missing function do I have to search for? How can I search google(what are the keywords?) so as to be able to find suitable solution if possible

 

[Chihiro]

There's no ready made one. Just like VBA UDF, you need to build your own.

Not tested, but see example in link below.

http://webapps.stackexchange.com/qu...rch-a-sheet-for-string-and-return-value-of-ne

 

[YasserKhalil]

Thanks a lot for reply again
I have no experience at all in this field. Is there any forums specialist in that kind of problems?
Thanks a lot for help

 

[Chihiro]

Ask/Post your question in appropriate forum in StackOverflow or in Google communities.