Using Sharepoint for file storage within Quickbase

  • 0
  • 1
  • Question
  • Updated 2 months ago
  • In Progress
Hello I currently have a Sharepoint site that my team leverages for file storage.  I was thinking I wanted to build a Quickbase app that would serve as our tracker...but I didn't want to store some of our more sensitive data on Quickbase servers and instead host in our work Sharepoint site (IT controlled).  Is there a way to link out to a sharepoint for documents in Quickbase?
Photo of Andrew

Andrew

  • 70 Points

Posted 2 months ago

  • 0
  • 1
Photo of Evan Martinez

Evan Martinez, Community Manager

  • 12,648 Points 10k badge 2x thumb
Hi Andrew,

One option is to use a URL type field to hold the URL of the Sharepoint link and then that way the documents would still be hosted in Sharepoint but anyone with sharepoint permissions can click on that link and be taken to the document. They would just need to copy over the URL of the sharepoint doc over into the URL type field. I hope that information is helpful. 
Photo of Cantan Group

Cantan Group

  • 112 Points 100 badge 2x thumb
Hi Andrew, can you try something like: https://{server}/{site}/.../{Folder}/[Record ID#] as a Formula - URL field?

My team has built custom QB connectors for similar external file storage.  This includes using a formula link to store to a directory based on the record ID.  The only thing I'm not sure about is if Sharepoint will handle the directory gracefully if it doesn't exist.

Please feel free to reach out if you need help with developing a custom connector.  Cheers, Imran

Cantan Group | Quick Base Dev
(416) 727-0407 | admin@cantangroup.com