Forum Discussion

RubyKapil2's avatar
RubyKapil2
Qrew Captain
7 years ago

Link to OneDrive Folder

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?
App builders
Formulas and functions
Quickbase Automations
  • RubyKapil2's avatar
    RubyKapil2
    Qrew Captain
    7 years ago
    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.