function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Dave The RaveDave The Rave 

URL formula field with custom field data included

Orders are not stored in SF, there is a link to an external website with the order number is required to view orders.

How can I create a formula field to show a clickable URL and use data from field OrderID__c as part of the URL. So see below [ORDER ID] needs to be replaced by OrderID__c (text field) from SF object Orders_c. The new field I am creating is called LinkToOrder__c

https://admin.it.testwebsite.com/adminpanel/index.php?controller=AdminOrders&id_order=[ORDER ID]&vieworder.

Can anyone help? thanks Dave