Forum Discussion

CarolMcconnell's avatar
CarolMcconnell
Qrew Officer
2 months ago
Solved

Sharepoint url links for emails open in outlook instead of the sharepoint

I move file attachments to sharepoint and then grab the url link and add that to the record. When the attachment is a outlook message, it opens in the outlook instead of the sharepoint.

Is there a way around this?

other
  • Denin's avatar
    Denin
    2 months ago

    At the end of the URL, you need this:

    ?csf=1&web=1

    So:

    https://COMPANYNAMEo365.sharepoint.com/sites/SITENAME/Shared%20Documents/DOCUMENTNAME.MSG?csf=1&web=1

    You could make a new formula field and concatenate your existing URL field to include that part at the end, then you have separate view and download URL fields. Otherwise, will have to edit your Pipeline or whatever other process you have for getting the URL to include it.

6 Replies

  • CarolMcconnell's avatar
    CarolMcconnell
    Qrew Officer
    2 months ago

    It's the actual sharepoint url of the document. 

     

    https://COMPANYNAMEo365.sharepoint.com/sites/SITENAME/Shared%20Documents/DOCUMENTNAME.MSG

    • Denin's avatar
      Denin
      Qrew Captain
      2 months ago

      At the end of the URL, you need this:

      ?csf=1&web=1

      So:

      https://COMPANYNAMEo365.sharepoint.com/sites/SITENAME/Shared%20Documents/DOCUMENTNAME.MSG?csf=1&web=1

      You could make a new formula field and concatenate your existing URL field to include that part at the end, then you have separate view and download URL fields. Otherwise, will have to edit your Pipeline or whatever other process you have for getting the URL to include it.

  • Denin's avatar
    Denin
    Qrew Captain
    2 months ago

    This seems more like a SharePoint question than Quickbase, you might get better replies in Microsoft forum. That said, I think the issue is the limited file types that can be opened in SharePoint plus if you have a program in Windows set to open emails and outlook items, then by default it will open them in that program.

    Maybe a workaround would be to convert the message to PDF or another format that can be opened in SharePoint. More info: Opening .msg files from sharepoint natively in Outlook | Microsoft Community Hub

    • CarolMcconnell's avatar
      CarolMcconnell
      Qrew Officer
      2 months ago

      Well, I think it has something to do with QuickBase because if you go to the sharepoint and open it, it opens in sharepoint and not outlook desktop.

      • Denin's avatar
        Denin
        Qrew Captain
        2 months ago

        What does the link to the SharePoint file look like in Quickbase?