{"id":2030,"date":"2022-05-31T14:58:47","date_gmt":"2022-05-31T18:58:47","guid":{"rendered":"https:\/\/cloudraysolutions.com\/?p=386"},"modified":"2022-05-31T14:58:47","modified_gmt":"2022-05-31T18:58:47","slug":"how-i-built-that-files-download-quick-link","status":"publish","type":"post","link":"https:\/\/cloudraysolutions.com\/how-i-built-that-files-download-quick-link\/","title":{"rendered":"How I Built That: Files Download Quick Link"},"content":{"rendered":"<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><a href=\"https:\/\/cloudraysolutions.com\/wp-content\/uploads\/2022\/05\/image-5-1.png\"><img decoding=\"async\" src=\"https:\/\/cloudraysolutions.com\/wp-content\/uploads\/2022\/05\/image-5-1.png?w=959\" alt=\"\" class=\"wp-image-402\" \/><\/a><\/figure><\/div>\n\n\n<p><\/p>\n\n\n\n<p>A recent system review with a client revealed a tedious and repetitive task.<\/p>\n\n\n\n<p>The client&#8217;s org contains Files related to a Custom Object we will call &#8220;ObjectX&#8221;. These Files are XML format and therefore cannot be previewed directly in Salesforce. To view the File, a User needs to access Navigate to Files Related List&gt;Click on the File Name&gt;Select to Download the File&gt;Save the File&gt;Open File&#8230;.5 steps to accomplish 1 task!<\/p>\n\n\n\n<p>And so we began to think, how can we facilitate this process? The first solution that came to mind was to create a URL hack which would be a quick link on the ObjectX record to access the File. This would already save Users a step.  Since there would only be 1 File per record, I didn&#8217;t need to worry about handling multiple Files. <\/p>\n\n\n\n<p>I determined that we would need to use DLRS to help pull File data directly into the ObjectX record.  Typically when using DLRS, the Rollup record directly references the Parent and Child Object. However, Files do not behave like your standard record with a direct relationship to the Object it is located on. A quick Google search led me to <a rel=\"noreferrer noopener\" href=\"https:\/\/github.com\/SFDO-Community\/declarative-lookup-rollup-summaries\/issues\/433#issuecomment-369085447\" target=\"_blank\">this thread<\/a> where a contributor explained how to reference Files. Rather than directly referencing the ContentDocument (File) Object, I referenced the ContactDocumentLink which is the liaison between Files and the Record it is related to.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><a href=\"https:\/\/cloudraysolutions.com\/wp-content\/uploads\/2022\/05\/image.png\"><img decoding=\"async\" src=\"https:\/\/cloudraysolutions.com\/wp-content\/uploads\/2022\/05\/image.png?w=1024\" alt=\"\" class=\"wp-image-393\" \/><\/a><\/figure><\/div>\n\n\n<p><\/p>\n\n\n\n<p>Once I did that, DLRS populated the File Id to a custom field &#8220;File__c&#8221; on the ObjectX record. Then, I did a little sleuthing (isn&#8217;t Salesforce all about detective work?!) and discovered that when I clicked the &#8220;Download&#8221; button on a File, a new browser tab opened containing a download URL.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><a href=\"https:\/\/cloudraysolutions.com\/wp-content\/uploads\/2022\/05\/image-1-1.png\"><img decoding=\"async\" src=\"https:\/\/cloudraysolutions.com\/wp-content\/uploads\/2022\/05\/image-1-1.png?w=986\" alt=\"\" class=\"wp-image-395\" \/><\/a><\/figure><\/div>\n\n\n<p><\/p>\n\n\n\n<p>I copied the URL  to a Formula Text Field, replacing the Id with the &#8220;File_c&#8221; field on the ObjectX record (which contains the File Id). <\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><a href=\"https:\/\/cloudraysolutions.com\/wp-content\/uploads\/2022\/05\/image-3.png\"><img decoding=\"async\" src=\"https:\/\/cloudraysolutions.com\/wp-content\/uploads\/2022\/05\/image-3.png?w=537\" alt=\"\" class=\"wp-image-399\" \/><\/a><\/figure><\/div>\n\n\n<p>I then used this field to create another Formula Text field which returned a URL. I did this in a 2 step process because the Hyperlink formula could not contain a record field.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><a href=\"https:\/\/cloudraysolutions.com\/wp-content\/uploads\/2022\/05\/image-4.png\"><img decoding=\"async\" src=\"https:\/\/cloudraysolutions.com\/wp-content\/uploads\/2022\/05\/image-4.png?w=512\" alt=\"\" class=\"wp-image-401\" \/><\/a><\/figure><\/div>\n\n\n<p><\/p>\n\n\n\n<p>And voila! Directly from the ObjectX record, a user can click on the File URL link and immediately save the file. A 5 step process automated to 2 steps!<\/p>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>A recent system review with a client revealed a tedious and repetitive task. The client&#8217;s org contains Files related to a Custom Object we will call &#8220;ObjectX&#8221;. These Files are XML format and therefore cannot be previewed directly in Salesforce. To view the File, a User needs to access Navigate to Files Related List&gt;Click on [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":true,"template":"","format":"standard","meta":{"inline_featured_image":false,"footnotes":""},"categories":[32,30,26,36],"tags":[6],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How I Built That: Files Download Quick Link - cloudraysolutions.com<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/cloudraysolutions.com\/how-i-built-that-files-download-quick-link\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How I Built That: Files Download Quick Link - cloudraysolutions.com\" \/>\n<meta property=\"og:description\" content=\"A recent system review with a client revealed a tedious and repetitive task. The client&#8217;s org contains Files related to a Custom Object we will call &#8220;ObjectX&#8221;. These Files are XML format and therefore cannot be previewed directly in Salesforce. To view the File, a User needs to access Navigate to Files Related List&gt;Click on [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/cloudraysolutions.com\/how-i-built-that-files-download-quick-link\/\" \/>\n<meta property=\"og:site_name\" content=\"cloudraysolutions.com\" \/>\n<meta property=\"article:published_time\" content=\"2022-05-31T18:58:47+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/cloudraysolutions.com\/wp-content\/uploads\/2022\/05\/image-5-1.png?w=959\" \/>\n<meta name=\"author\" content=\"Rachel Natik\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Rachel Natik\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/cloudraysolutions.com\/how-i-built-that-files-download-quick-link\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/cloudraysolutions.com\/how-i-built-that-files-download-quick-link\/\"},\"author\":{\"name\":\"Rachel Natik\",\"@id\":\"https:\/\/cloudraysolutions.com\/#\/schema\/person\/3f7af52e917e04584cc84c589cf54b0e\"},\"headline\":\"How I Built That: Files Download Quick Link\",\"datePublished\":\"2022-05-31T18:58:47+00:00\",\"dateModified\":\"2022-05-31T18:58:47+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/cloudraysolutions.com\/how-i-built-that-files-download-quick-link\/\"},\"wordCount\":380,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/cloudraysolutions.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/cloudraysolutions.com\/how-i-built-that-files-download-quick-link\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/cloudraysolutions.com\/wp-content\/uploads\/2022\/05\/image-5-1.png?w=959\",\"keywords\":[\"Salesforce\"],\"articleSection\":[\"Automation\",\"Consulting\",\"Lightning\",\"Technology\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/cloudraysolutions.com\/how-i-built-that-files-download-quick-link\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/cloudraysolutions.com\/how-i-built-that-files-download-quick-link\/\",\"url\":\"https:\/\/cloudraysolutions.com\/how-i-built-that-files-download-quick-link\/\",\"name\":\"How I Built That: Files Download Quick Link - cloudraysolutions.com\",\"isPartOf\":{\"@id\":\"https:\/\/cloudraysolutions.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/cloudraysolutions.com\/how-i-built-that-files-download-quick-link\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/cloudraysolutions.com\/how-i-built-that-files-download-quick-link\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/cloudraysolutions.com\/wp-content\/uploads\/2022\/05\/image-5-1.png?w=959\",\"datePublished\":\"2022-05-31T18:58:47+00:00\",\"dateModified\":\"2022-05-31T18:58:47+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/cloudraysolutions.com\/how-i-built-that-files-download-quick-link\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/cloudraysolutions.com\/how-i-built-that-files-download-quick-link\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/cloudraysolutions.com\/how-i-built-that-files-download-quick-link\/#primaryimage\",\"url\":\"https:\/\/cloudraysolutions.com\/wp-content\/uploads\/2022\/05\/image-5-1.png\",\"contentUrl\":\"https:\/\/cloudraysolutions.com\/wp-content\/uploads\/2022\/05\/image-5-1.png\",\"width\":959,\"height\":166},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/cloudraysolutions.com\/how-i-built-that-files-download-quick-link\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/cloudraysolutions.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How I Built That: Files Download Quick Link\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/cloudraysolutions.com\/#website\",\"url\":\"https:\/\/cloudraysolutions.com\/\",\"name\":\"cloudraysolutions.com\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/cloudraysolutions.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/cloudraysolutions.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/cloudraysolutions.com\/#organization\",\"name\":\"cloudraysolutions.com\",\"url\":\"https:\/\/cloudraysolutions.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/cloudraysolutions.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/cloudraysolutions.com\/wp-content\/uploads\/2023\/01\/cloudray-solutions-logo.png\",\"contentUrl\":\"https:\/\/cloudraysolutions.com\/wp-content\/uploads\/2023\/01\/cloudray-solutions-logo.png\",\"width\":346,\"height\":147,\"caption\":\"cloudraysolutions.com\"},\"image\":{\"@id\":\"https:\/\/cloudraysolutions.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/cloudraysolutions.com\/#\/schema\/person\/3f7af52e917e04584cc84c589cf54b0e\",\"name\":\"Rachel Natik\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/cloudraysolutions.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/a557df15a34a0b827f7c6e94df4687d0?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/a557df15a34a0b827f7c6e94df4687d0?s=96&d=mm&r=g\",\"caption\":\"Rachel Natik\"},\"sameAs\":[\"http:\/\/cloudraysolutions.com\"],\"url\":\"https:\/\/cloudraysolutions.com\/author\/rachel\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How I Built That: Files Download Quick Link - cloudraysolutions.com","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/cloudraysolutions.com\/how-i-built-that-files-download-quick-link\/","og_locale":"en_US","og_type":"article","og_title":"How I Built That: Files Download Quick Link - cloudraysolutions.com","og_description":"A recent system review with a client revealed a tedious and repetitive task. The client&#8217;s org contains Files related to a Custom Object we will call &#8220;ObjectX&#8221;. These Files are XML format and therefore cannot be previewed directly in Salesforce. To view the File, a User needs to access Navigate to Files Related List&gt;Click on [&hellip;]","og_url":"https:\/\/cloudraysolutions.com\/how-i-built-that-files-download-quick-link\/","og_site_name":"cloudraysolutions.com","article_published_time":"2022-05-31T18:58:47+00:00","og_image":[{"url":"https:\/\/cloudraysolutions.com\/wp-content\/uploads\/2022\/05\/image-5-1.png?w=959"}],"author":"Rachel Natik","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Rachel Natik","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/cloudraysolutions.com\/how-i-built-that-files-download-quick-link\/#article","isPartOf":{"@id":"https:\/\/cloudraysolutions.com\/how-i-built-that-files-download-quick-link\/"},"author":{"name":"Rachel Natik","@id":"https:\/\/cloudraysolutions.com\/#\/schema\/person\/3f7af52e917e04584cc84c589cf54b0e"},"headline":"How I Built That: Files Download Quick Link","datePublished":"2022-05-31T18:58:47+00:00","dateModified":"2022-05-31T18:58:47+00:00","mainEntityOfPage":{"@id":"https:\/\/cloudraysolutions.com\/how-i-built-that-files-download-quick-link\/"},"wordCount":380,"commentCount":0,"publisher":{"@id":"https:\/\/cloudraysolutions.com\/#organization"},"image":{"@id":"https:\/\/cloudraysolutions.com\/how-i-built-that-files-download-quick-link\/#primaryimage"},"thumbnailUrl":"https:\/\/cloudraysolutions.com\/wp-content\/uploads\/2022\/05\/image-5-1.png?w=959","keywords":["Salesforce"],"articleSection":["Automation","Consulting","Lightning","Technology"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/cloudraysolutions.com\/how-i-built-that-files-download-quick-link\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/cloudraysolutions.com\/how-i-built-that-files-download-quick-link\/","url":"https:\/\/cloudraysolutions.com\/how-i-built-that-files-download-quick-link\/","name":"How I Built That: Files Download Quick Link - cloudraysolutions.com","isPartOf":{"@id":"https:\/\/cloudraysolutions.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/cloudraysolutions.com\/how-i-built-that-files-download-quick-link\/#primaryimage"},"image":{"@id":"https:\/\/cloudraysolutions.com\/how-i-built-that-files-download-quick-link\/#primaryimage"},"thumbnailUrl":"https:\/\/cloudraysolutions.com\/wp-content\/uploads\/2022\/05\/image-5-1.png?w=959","datePublished":"2022-05-31T18:58:47+00:00","dateModified":"2022-05-31T18:58:47+00:00","breadcrumb":{"@id":"https:\/\/cloudraysolutions.com\/how-i-built-that-files-download-quick-link\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/cloudraysolutions.com\/how-i-built-that-files-download-quick-link\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/cloudraysolutions.com\/how-i-built-that-files-download-quick-link\/#primaryimage","url":"https:\/\/cloudraysolutions.com\/wp-content\/uploads\/2022\/05\/image-5-1.png","contentUrl":"https:\/\/cloudraysolutions.com\/wp-content\/uploads\/2022\/05\/image-5-1.png","width":959,"height":166},{"@type":"BreadcrumbList","@id":"https:\/\/cloudraysolutions.com\/how-i-built-that-files-download-quick-link\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/cloudraysolutions.com\/"},{"@type":"ListItem","position":2,"name":"How I Built That: Files Download Quick Link"}]},{"@type":"WebSite","@id":"https:\/\/cloudraysolutions.com\/#website","url":"https:\/\/cloudraysolutions.com\/","name":"cloudraysolutions.com","description":"","publisher":{"@id":"https:\/\/cloudraysolutions.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/cloudraysolutions.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/cloudraysolutions.com\/#organization","name":"cloudraysolutions.com","url":"https:\/\/cloudraysolutions.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/cloudraysolutions.com\/#\/schema\/logo\/image\/","url":"https:\/\/cloudraysolutions.com\/wp-content\/uploads\/2023\/01\/cloudray-solutions-logo.png","contentUrl":"https:\/\/cloudraysolutions.com\/wp-content\/uploads\/2023\/01\/cloudray-solutions-logo.png","width":346,"height":147,"caption":"cloudraysolutions.com"},"image":{"@id":"https:\/\/cloudraysolutions.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/cloudraysolutions.com\/#\/schema\/person\/3f7af52e917e04584cc84c589cf54b0e","name":"Rachel Natik","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/cloudraysolutions.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/a557df15a34a0b827f7c6e94df4687d0?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/a557df15a34a0b827f7c6e94df4687d0?s=96&d=mm&r=g","caption":"Rachel Natik"},"sameAs":["http:\/\/cloudraysolutions.com"],"url":"https:\/\/cloudraysolutions.com\/author\/rachel\/"}]}},"_links":{"self":[{"href":"https:\/\/cloudraysolutions.com\/wp-json\/wp\/v2\/posts\/2030"}],"collection":[{"href":"https:\/\/cloudraysolutions.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/cloudraysolutions.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/cloudraysolutions.com\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/cloudraysolutions.com\/wp-json\/wp\/v2\/comments?post=2030"}],"version-history":[{"count":0,"href":"https:\/\/cloudraysolutions.com\/wp-json\/wp\/v2\/posts\/2030\/revisions"}],"wp:attachment":[{"href":"https:\/\/cloudraysolutions.com\/wp-json\/wp\/v2\/media?parent=2030"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/cloudraysolutions.com\/wp-json\/wp\/v2\/categories?post=2030"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/cloudraysolutions.com\/wp-json\/wp\/v2\/tags?post=2030"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}