Set a Default Folder for Documents

Set a Default Folder for Documents



  3. --The following script will place all documents that are directly in a root folder inside of a subfolder.
  4. UPDATE
  5. __M_Documents_Digital_Files
  6. SET
  7. --Change this to be whatever subfolder we want it to be.
  8. Final_FolderName = '\Unfiled\'
  9. WHERE
  10. Final_FolderName = '\'


    • Related Articles

    • Promoting Document Versions into Documents

      --The following playbook is a TEMPLATE that you can use to promote all document versions into actual documents. --When a document has a category, append the folder with the document category ID. UPDATE __M_Documents_Digital_Files SET --Prepend the ...

    • Moving Documents into Matters that are Nested under Calendar Entries

      --The following script moves documents that are nested under Calendar Entries to be nested under Matters instead. UPDATE __M_Documents_Digital_Files SET Final_Folder_RelativePath = '\Calendar Attachments\', Final_Parent_Type = ...

    • Moving Documents into Matters that are Nested under Communications

      --The following script moves documents that are nested under Communications to be nested under Matters instead. UPDATE __M_Documents_Digital_Files SET Final_Folder_RelativePath = '\Emails\', Final_Parent_Type = Relationships.Final_RelatedTo_Type, ...

    • Moving Documents into Matters that are Nested under Tasks

      --The following script moves documents that are nested under Tasks to be nested under Matters instead. UPDATE __M_Documents_Digital_Files SET Final_Folder_RelativePath = '\Task Attachments\', Final_Parent_Type = Relationships.Final_RelatedTo_Type, ...

    • Moving Documents into Matters that are Nested under Invoices

      --The following script moves documents that are nested under Invoices to be nested under Matters instead. UPDATE __M_Documents_Digital_Files SET Final_Folder_RelativePath = '\Invoices\', Final_Parent_Type = Relationships.Final_RelatedTo_Type, ...