a saved search that is emailed; is it possible to ...
# ask-stanley-ai
m
a saved search that is emailed; is it possible to create a grid so that the colums is easier to read?
c
AI generated answer (using internal Slack threads):
Yes, it is possible to format the results of a saved search when it is emailed. You can use HTML tags in the email body to format the results. However, this works best for single record results. For example, you can use a formula HTML field to highlight a certain column or individual "cell" (result) instead of highlighting the entire row. Here is an example:
Copy code
CASE WHEN {field1} = '1' THEN '<p style="background-color:#000000">'||{value}||'' WHEN {field1} = '2 ' THEN '<p style="background-color:#FFFFFF">'||{value}||'' ELSE {value} END
This formula will change the background color of the cell based on the value of {field1}. However, if you are trying to email a saved search that includes multiple records and you want it to appear in a column format (like an Excel file) within the email body, this might not be possible directly within NetSuite. The data might show up each record one by one in the email instead of in a column format. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******
Slack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.8450858
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.842777133
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.841521382
Please provide your feedback on this answer.