Link to OneDrive Folder

  • 0
  • 1
  • Question
  • Updated 1 month ago
  • In Progress
I have records with unique Object ID in Quickbase table.
On OneDrive web folder, I have folders which have the Object ID in the name of the folder.
I have over 3500 of these folders on OneDrive.
Is there any way I can tell Quickbase to go to OneDrive and find the folder that contains the Object ID in its folder name and create a URL link to that OneDrive folder?
Photo of Ruby Kapil

Ruby Kapil

  • 816 Points 500 badge 2x thumb

Posted 1 month ago

  • 0
  • 1
Photo of Ruby Kapil

Ruby Kapil

  • 816 Points 500 badge 2x thumb
I've built a Formula URL that concatenates the URL to the OneDrive and the Object ID. This works. Just wondering if there is a faster way where Qbase searches and builds this. I have 40 folders that I would need to build that URL formula for -- example Green -1, Green-2, Pink-1, Pink-2 etc. With each color folder having 100 folders within each.