Wednesday, September 26, 2018

Create Multiple Hyperlinks in a Saved Search Column to View, Edit, Print and Grab a Support Case


Image

Solution:

1. Navigate to Reports> Saved Searches> All Saved Searches > Edit a case saved search.
2. Choose Formula (Text) under Results subtab's field column,
3. Copy the sample HTML code below under Formula column, :
'<font size="1">'||{title}||'<br><a name="View" id="View"href="'||'https://system.netsuite.com/app/crm/support/supportcase.nl?id='||{internalid}||'"target="_blank">View</a> <a name="Edit" id="Edit"href="'||'https://system.netsuite.com/app/crm/support/supportcase.nl?id='||{internalid}||'&e=T"target="_blank">Edit</a> <a name="Print" id="Print"href="'||'https://system.netsuite.com/app/crm/support/supportcase.nl?id='||{internalid}||'&print=T"target="_blank">Print</a> <a name="Grab" id="Grab"href="'||'https://system.netsuite.com/app/crm/support/supportcase.nl?id='||{internalid}||'&grab=T&e=T"target="_blank">Grab</a>'
4. Type a label under 'Custom Label' column. (E.g. View l Edit l Print l Grab)
5. Hit Add or Done.
6. Hit Save.
7. View the saved search results.

Note: A single character can cause the result to display ERROR: Invalid Expression. Take note of the beginning and ending single quote (') and how '||{field_ids}||' are formatted. The URLs used here are standard from Netsuite when you create, edit, grab and print a support case. 




No comments:

Post a Comment