1. Prepare the URL Link in Your Database Tables:<\/strong><\/p>\n\n\n\n Ensure that your database tables contain the necessary URL links that you want to use as hyperlinks.<\/p>\n\n\n Fig. 1.Database Tables<\/strong><\/p>\n\n\n\n 2. Create a Data Model:<\/strong><\/p>\n\n\n\n Open the \u201cData Models and Views\u201d tab.<\/p>\n\n\n\n Right-click and select \u201cNew Data Model\u201d to create a new data model.<\/p>\n\n\n\n In the Data Model Designer, set up the \u201cFormat\u201d field<\/p>\n\n\n\n Under the \u201cCategories\u201d section, select \u201cHyperlink.\u201d<\/span><\/p>\n\n\n\n Click \u201cOK.\u201d<\/p>\n\n\n Fig. 2. Set Hyperlink<\/strong><\/p>\n\n\n\n 3. Save the Data Model:<\/strong><\/p>\n\n\n\n In the upper left-hand corner, click \u201cFile\u201d and select \u201cSave Data Model.<\/p>\n\n\n\n 4. Create a New View:<\/strong><\/p>\n\n\n\n Go back to the \u201cData Models and Views\u201d tab.<\/p>\n\n\n\n Create a new view based on the data model where you set up the \u201cFormat\u201d field.<\/p>\n\n\n\n Choose the \u201cWorksheet\u201d option.<\/p>\n\n\n\n 5. Add Hyperlink (URL) Fields:<\/strong><\/p>\n\n\n\n In the worksheet grid, add the relevant hyperlink fields.<\/p>\n\n\n\n When users click the link, a new window will open to display the URL in a browser.<\/p>\n\n\n\n Fig. 3. Add Hyperlink<\/strong><\/p>\n\n\n\n In this blog post, we explored the process of creating hyperlinks from a database in Sage Enterprise Intelligence (SEI). By following these steps, you can enhance your reports and dashboards with clickable links to external resources.<\/p>\n\n\n\n <\/p>\n","protected":false},"excerpt":{"rendered":" In this tutorial, we\u2019ll walk through the step-by-step process of creating a hyperlink from a database in Sage Enterprise Intelligence (SEI). Steps: 1. Prepare the URL Link in Your Database Tables: Ensure that your database tables contain the necessary URL links that you want to use as hyperlinks. Fig. 1.Database Tables 2. Create a Data\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2,4,5,3162,6,13,8,10,2796,11,1,12],"tags":[4251,4252,1762,1822,2871,1943,1947,3624],"class_list":["post-29515","post","type-post","status-publish","format-standard","hentry","category-configuration","category-faq","category-features","category-greytrix","category-installation","category-integration","category-sage-erp-x3","category-standard","category-technical","category-tips","category-uncategorized","category-sage-x3-upgrade","tag-add-hyperlink-in-sei","tag-add-url-in-sei","tag-sage-enterprise-management","tag-sage-x3","tag-sage-x3-functional-blogs","tag-sage-x3-technical-blog","tag-sage-x3-technical-issues","tag-sei"],"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/29515","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/comments?post=29515"}],"version-history":[{"count":2,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/29515\/revisions"}],"predecessor-version":[{"id":29520,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/29515\/revisions\/29520"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/media?parent=29515"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/categories?post=29515"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/tags?post=29515"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}![\"\"](\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2024\/07\/Fig.-1.Database-Tables.png\")
<\/figure><\/div>\n\n\n![\"\"](\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2024\/07\/Fig.-2.-Set-Hyperlink.png\")
<\/figure><\/div>\n\n\n![\"\"](\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2024\/07\/Fig.-3.-Add-Hyperlink-1024x485.png\")
<\/figure>\n\n\n\n