Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
Concatenating a value for email field
Hi,
I'm trying to get this formula to mass update the email field.
Right now we have a standard for people without emails
noemail@xxx.com
but obviously this interferes with the duplicate detection.
So I'm trying to change them via mass upate to
CONCAT('noemail',to_char({entitynumber}),'@xxx.com')
So the result i would be noemailcust003223@xxx.com
But its giving me:
Search: Customer Search
Formula: CONCAT('noemail',to_char({entitynumber}),'@xxx.com')
Does anyone has any ideas how to fix this?
Thanks