common+HTML+for+saved+aearch

http://clouderpadvisor.com/common-html-codes-format-netsuite-saved-searches/


February 28th, 2014 | Posted by [|Monica Smith] in [|About Cloud ERP] | [|NetSuite] | [|Tips and Tricks]     in Share 1 [|NetSuite] allows users to manipulate the output of Saved Searches. Basic HTML codes can be added to a NetSuite saved search to format the output results & control the format of the column headers. The following examples show the HTML code, formula and desired output. While the Highlight tab in the Saved Search is great for highlighting entire rows, the following HTML code/formulas allow individual cell manipulation. Each formula can be cut, copied and pasted in the formula line on the results tab or in the custom label or summary label field. All quotes, commas, <>, etc. are necessary to the formula working properly. Replace the {field} with the appropriate field in the saved search. To locate the appropriate field, open the field list and choose from the list and/or join records. HTML Color names can be used (ex: red, blue, aqua, black, green). For more information, perform a Google search on //HTML Color Names.// HTML Entity codes can be used to display printable characters (ex: ?, !)     <span style="background-color: rgba(255,255,255,0);">** To obtain the image source: <span style="background-color: rgba(255,255,255,0);">‘<img src=”/core/media/media.nl?id=1607&c=TSTDRV1138881&h=d160b12028a99887ac10″>’ <span style="background-color: rgba(255,255,255,0);"> <span style="background-color: rgba(255,255,255,0);">**NOTE:** Exporting the results of a saved search with HTML coding will export the exact HTML code. See below to remove HTML coding from an exported file in Excel. <span style="background-color: rgba(255,255,255,0);">Remove HTML coding from an exported saved search in Excel. <span style="background-color: rgba(255,255,255,0);">To get around this issue, you can create a Macro in Excel to strip the HTML tags from the Excel file. <span style="background-color: rgba(255,255,255,0);">1. Open up the VBE with Alt+F11 and locate your workbook in the top left Project Explorer window. <span style="background-color: rgba(255,255,255,0);">2. Right-click on your workbook and choose Insert > Module. <span style="background-color: rgba(255,255,255,0);">3. Paste the code in to the code module that will open (see below) <span style="background-color: rgba(255,255,255,0);">4. Go back to Excel, select the cells you want to edit (those with HTML tags) <span style="background-color: rgba(255,255,255,0);">5. Developer > Macros > Run > Remove Tags or Activate the macro with Tools > Macro > Macros <span style="background-color: rgba(255,255,255,0);">6. This is a very slow process. <span style="background-color: rgba(255,255,255,0);">7. Verify the results in excel <span style="background-color: rgba(255,255,255,0);"> This is the code for the Macro:
 * 1) <span style="background-color: rgba(255,255,255,0);">Upload the image in Documents > Files > Images > New
 * 2) <span style="background-color: rgba(255,255,255,0);">Save the image
 * 3) <span style="background-color: rgba(255,255,255,0);">From the saved image, copy the URL beginning at /core/media and paste into the formula string. The url generated by the saved image file will be different than the one seen here:
 * <span style="background-color: rgba(255,255,255,0);">Sub RemoveTags
 * <span style="background-color: rgba(255,255,255,0);">Dim r As Range
 * <span style="background-color: rgba(255,255,255,0);">Selection.NumberFormat = “@” ‘set cells to text numberformat
 * <span style="background-color: rgba(255,255,255,0);">With CreateObject(“vbscript.regexp”)
 * <span style="background-color: rgba(255,255,255,0);">.Pattern = “\<.*?\>”
 * <span style="background-color: rgba(255,255,255,0);">.Global = True
 * <span style="background-color: rgba(255,255,255,0);">For Each r In Selection
 * <span style="background-color: rgba(255,255,255,0);">r.Value = Replace(.Replace(r.Value, “”),” “,” “)
 * <span style="background-color: rgba(255,255,255,0);">Next r
 * <span style="background-color: rgba(255,255,255,0);">End With
 * <span style="background-color: rgba(255,255,255,0);">End Sub

<span style="background-color: rgba(255,255,255,0);">If you have questions with how to add HTML code to your Saved Searches or would like [|support for your NetSuite solution], contact our professionals at erp@mcgladrey.com or via phone at <span class="baec5a81-e4d6-4674-97f3-e9220f0136c1" style="background-color: rgba(255,255,255,0);">855.437.7202  <span style="background-color: rgba(255,255,255,0);">. <span style="background-color: rgba(255,255,255,0);">By: Monica Smith – [|Iowa NetSuite Solution Provider] <span style="background-color: rgba(255,255,255,0); display: block; text-align: justify; vertical-align: bottom;"> <span style="background-color: rgba(255,255,255,0); display: block; vertical-align: baseline;"> <span style="background-color: rgba(255,255,255,0); display: block; text-align: left; vertical-align: bottom;"> <span style="background-color: rgba(255,255,255,0); display: block; text-align: center; vertical-align: baseline;"> in Share <span class="IN-right" style="background-color: rgba(255,255,255,0); text-align: start; vertical-align: baseline;">1 ===<span style="background-color: rgba(255,255,255,0);">Related Posts: === <span style="background-color: rgba(255,255,255,0);">
 * 1) <span style="background-color: rgba(255,255,255,0); text-decoration: none;">[|NetSuite Saved Searches — Part 1: Data extraction]
 * 2) <span style="background-color: rgba(255,255,255,0); text-decoration: none;">[|NetSuite sensible saved searches – Part 3: Highlighting and filters]
 * 3) <span style="background-color: rgba(255,255,255,0); text-decoration: none;">[|NetSuite sensible saved searches — Part 2: Grouping and summarizing]
 * 4) <span style="background-color: rgba(255,255,255,0); text-decoration: none;">[|Custom Fields with Values Derived from Saved Search Results]

<span style="background-color: rgba(255,255,255,0);">[|Add to Shortcuts], [|Cloud ERP Software], [|HTML codes], [|Iowa NetSuite Solution Provider], [|NetSuite], [|Saved Searches] <span style="background-color: rgba(255,255,255,0);">You can follow any responses to this entry through the [|RSS 2.0] You can skip to the end and leave a response. Pinging is currently not allowed.

<span style="background-color: rgba(255,255,255,0);">Leave a Reply
<span style="background-color: rgba(255,255,255,0);">Your email address will not be published. Required fields are marked <span style="background-color: rgba(255,255,255,0);">Name <span style="background-color: rgba(255,255,255,0);"> <span style="background-color: rgba(255,255,255,0);">Email <span style="background-color: rgba(255,255,255,0);"> <span style="background-color: rgba(255,255,255,0);">Website <span style="background-color: rgba(255,255,255,0);"> <span style="background-color: rgba(255,255,255,0);">Comment <span style="background-color: rgba(255,255,255,0);"> <span style="background-color: rgba(255,255,255,0);">You may use these HTML tags and attributes:  <b>   <i> <span style="background-color: rgba(255,255,255,0);"> <span style="background-color: rgba(255,255,255,0);"> <span style="background-color: rgba(255,255,255,0);">Notify me of follow-up comments by email. <span style="background-color: rgba(255,255,255,0);"> <span style="background-color: rgba(255,255,255,0);">Notify me of new posts <span style="background-color: #ffffff; color: #888888; font-family: Arial,Helvetica,sans-serif; font-size: 12px;">by email.