LPearlstine Posted October 29, 2022 Posted October 29, 2022 When I send a form to a spreadsheet on Google Drive, can I specify a folder to put the spreadsheet in? I tried including a path in the filename (e.g., "Forms/thisform", but it just created a file in the top MyDrive with that name (including the slash in the name). I tried both forward and back slashes. The back slash caused an error. Thanks
Solution creedon Posted October 29, 2022 Solution Posted October 29, 2022 While I suspect it is technically possible via Google's API to do what you want, I suspect SS choose not to add that level of complexity to the form Storage options. I don't have a solution but it may be possible to write some scripts Google side to take the lines that are coming into the top level document and move them into another spreadsheet that is in a folder. You of course end up having two forms but if your goal is to use folders for organizational purposes, then this potential technique would get you there. Find my contributions useful? Please like, upvote, mark my answer as the best ( solution ), and see my profile. Thanks for your support! I am a Squarespace ( and other technological things ) consultant open for new projects.
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment