Google Sheets using image URL instead of the Image name when uploading file
-
Hello everyone!
I’ve set up an automatic video template for my company using Templater, Google forms and google sheets. I love the plugin so far but when someone uploads an image in Google forms the Image is not shown with a file name instead it shows a link. The image also downloads to a folder locally on my computer connecter to Templater. So my questions are:- Is there a way to get around this?
- Is Google forms the best program to use with templater or is there any other good third party programs that works better?
Im pretty new to Templater so if anyone has any tips, I would be eternally grateful!
/Elias
-
@eliasnilsson19 How are you locally accessing the files uploaded to the Google Form? Are they being synced back to your computer via Google Drive (File Stream or Backup and Sync)? You would need to build a formula in your Sheet that transposes and concatenates a local file path based on the original file name of the file being uploaded-- the generated URLs for Google Drive are not absolute links, so Templater will fail to download them correctly (Templater can download URLs that are absolute links to the files, ending with a file extension). I’m not certain whether it is possible to get just the filename of the uploaded file via Google Forms, but if it is, that is how you would have to approach it. Outside of that, you’d have to look at a different form builder that can handle the requirement of uploading the file and pushing the absolute URL back into your Sheet. I know that it is possible to do with JotForm, if configured correctly.