Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
Formula field reference by formula??
Hi-
I have a formula where the result is the correct text of another field name (the field is named "custrecord_parent.custentity_umay09"). Anyway, when I create a free form text "formula field" and enter the other field name I get--
BELOW PRODUCES-- "1234"
{custrecord_parent.custentity_umay09}
If I enter my formula I get-
BELOW PRODUCES-- "{custrecord_parent.custentity_umay09}"
'{custrecord_parent.custentity_u' || TO_CHAR({custrecord_start}, 'mon') || TO_CHAR({custrecord_start}, 'YY') || '}'
If I enter my formula less the part that produces the brackets, and surround it by a set of brackets I get-
BELOW PRODUCES-- "ERROR: Field Not Found"
0