Wednesday, December 19, 2018

Formula (Text) Value which starts with the Word ‘User’ Returns “ERROR: Invalid Expression” in the Search Results

When using a Formula (Text) to return a value that starts with "User", the search result returns "ERROR: Invalid Expression".

Using the simple steps below, we can demonstrate how the error happens to better understand this unique scenario:

1. Go to Lists > Search > Saved Searches > New > Transaction.
2. Under the Results tab > Columns sub tab, add:
   • Formula (Text) 
     - Type this value in the Formula field: 'user' 
4. Preview. "ERROR: Invalid Expression" appears in the Search Results.

This errors because the word "User" is a reserved word and is not recognized as a string in the system.  

To avoid this error concatenate the characters to form the word "User". Like: 

   • CONCAT('Use', 'r') 
   • 'Use' || 'r'  

No comments:

Post a Comment