Forum Discussion
Hey Miguel, as Chayce mentioned, one technique is to leverage Quickbase's Google Drive Pipelines Channel to create the Drive Folder and then write the Folder ID back to your Quickbase app once it's been created. I've set this up in the past where we create a new record in a QB "Links" table which relates back a parent record (e.g. Project). This allows us to create a nested directory structure, where one Drive Folder may have subfolders too.
When creating the Drive folder record, I also append the QB Record ID to the Folder name to help with searching via Drive. And in Quickbase you may use a Formula URL to construct a link to Google Drive folder by basically concatenating the base path to Google Drive with the stored Links ID. That way users can click a button on a QB Form or Report to easily get to the right location in Google Drive.
Also, users can upload files directly to Google Drive, which is different than what you're asking, but it may be an alternative to consider. There are pros and cons to consider, especially with data validation.
------------------------------
Brian Seymour
------------------------------