Welcome back to SuiteTip, your ultimate guide to unlocking NetSuite's full potential! In this edition, we'll explore the power of Formula HTML fields and how they can transform your Saved Searches with conditional formatting. Get ready to take your reporting skills to the next level!
Enhance Your Saved Searches with Formula HTML Fields
NetSuite's Saved Searches offer a Formula field option called Formula (HTML), which allow you to apply HTML codes to your search results. This powerful tool enables you to create dynamic reports that adapt to your data, making it easier to analyze and present information.
How to Use Formula HTML Fields:
- Navigate to Lists > Search > Saved Searches.
- Create a new Saved Search or edit an existing one.
- In the Criteria tab, define the search conditions.
- Go to the Results tab, and select the 'Formula (HTML)' in the field list.
- Here, you can add a formula using HTML to format the data. For example, you can change the text color based on a value of a field.
- Save your search, and run it to see the formatted results.
Sample Scenario:
Problem: You want to create an Item Saved Search that would show the Quantity On Hand as Blue, while the Quantity Back Ordered as Red.
Solution: Use a Formula (HTML) field to display the information.
Formulas:
- '<p style="color:Blue;">'||{quantityonhand}||'</p>'
- '<p style="color:Red;">'||{quantitybackordered}||'</p>'
Sample Result:
Important Note: If you export the results as CSV, Excel or PDF, the result will show the HTML formula. It will not keep the formatting.
Formula HTML fields in NetSuite's Saved Searches offer a dynamic way to format search results. By using HTML, you can create visually appealing reports that adapt to your data. This feature is particularly useful for highlighting important information and making data-driven decisions.
---
Stay tuned for our next SuiteTip, where we’ll explore more tips and best practices for navigating NetSuite Reports and Saved Searches!
We encourage you to share your own tips, ask questions, and engage with fellow community members. Your experiences can help others on their journey to becoming NetSuite analytics experts!