Discussions
SuiteWorld brings thousands of innovators, builders, and leaders together to learn, connect, and shape what’s next. This October, explore how to build a stronger foundation for growth through inspiring keynotes, major product reveals, hands-on sessions, and unforgettable moments—all in one place for our biggest event of the year. Join us
NSC | Resolve Error: "Field Not Found" when Copy-Pasting formula from SuiteAnswers
Scenario
User creates a saved search and is copy-pasting the formula provided in SuiteAnswers. However, when the search is ran, it returns ERROR: Field Not Found for that column.
Solution
Normally, if a copy-pasted formula doesn't work, it means that there is something wrong (like incorrect spelling or symbol) or something missing (like parenthesis or comma).
Some might have encountered this before with the apostrophe and single quote symbols. If the formula was typed in MS Word wherein the ' symbol is treated as an apostrophe, and is considered invalid in SQL formula (single quote symbol works).
But if those were already ruled out, then there might be a
Learn how to Refer A Member | Earn the Answer Accepter Badge | Be the Content Creator of the Quarter | Vote for the content you want to see!