What is the difference between custom field types Free-Form Text, Text Area, Rick Text, and Long Text in terms of how they are treated in the NetSuite2 analytics data source?

AI generated answer (using internal Slack threads):

In NetSuite analytics data source, the custom field types Free-Form Text, Text Area, Rich Text, and Long Text are treated differently: 1. Free-Form Text: This is a single-line text field that allows users to enter any text. It is searchable and can be used as a filter in saved searches and reports. However, it has a character limit and may not display the entire text if it exceeds the limit. 2. Text Area: This is a multi-line text field that allows users to enter more text compared to the Free-Form Text field. It is also searchable and can be used as a filter in saved searches and reports. It is a better option if you need to display a larger amount of text in your reports. 3. Rich Text: This field type allows users to enter text with formatting (bold, italics, underline, etc.). However, it is not indexed and therefore cannot be used as a filter in the "Customize View" feature. It also may not work as a filter in some saved searches and reports. 4. Long Text: This field type allows users to enter a large amount of text. However, similar to the Rich Text field, it is not indexed and cannot be used as a filter in the "Customize View" feature. It also may not work as a filter in some saved searches and reports. Remember, changing the type of a custom field may result in the loss of data in that field. Always test such changes in a sandbox environment and backup your data before making the change in the live environment. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******