2

Trying to automate find and replace function on form submission within sheets.
Principal/Teacher submits a photo through a Google Form and I want to change from the file link to a search to link within the Google Sheet. Currently have to manually do this and would like to automate the process.

Here are the find and replace codes currently using find

https://drive.google.com/open?id=

and replacing with

https://drive.google.com/uc?export=view&id=
1
  • Welcome. Please remember that as per site guidelines when an answer addresses your question, accept it and even upvote it so others can benefit as well. Commented Jan 15, 2021 at 17:57

1 Answer 1

1

You would need to use a formula with the SUBSTITUTE function

=SUBSTITUTE(D8,"https://drive.google.com/open?id=", 
               "https://drive.google.com/uc?export=view&id=")

enter image description here

1
  • That would work, I am just wanting to have it automatically change when a form is submitted. Is this even possible? Commented Jan 26, 2021 at 21:52

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.