mohankaladi's Profile
Rookie
5
Points

Questions
0

Answers
2

  • Rookie Asked on August 10, 2021 in Saved Searches.

     

    Hi Margie,

     

    Try out the below Formula; I am assuming that the custom field name as FullName.

    Formula:

    Full_name à “John Lucky”

    Take First Name: SUBSTR({full_name}, 1, INSTR({full_name} , ‘ ‘ , 1 , 1))   à John

    Task Second Name: SUBSTR({full_name}, INSTR({full_name} , ‘ ‘ , 1 , 1)+1 )      à Lucky

     

    I hope it will help and clear the issue, For More NetSuite Support Services 

    • 946 views
    • 1 answers
    • 0 votes
  • Rookie Asked on August 10, 2021 in Saved Searches.

    I have updated the Send Email action by setting the condition formula as {custbody_cc_emails} is not null.

    In this case CC field value is {custbody_cc_emails}.

    I have created another Send Email Action, where I set the condition formula as {custbody_cc_emails} is null and left the CC field in Action as blank.

    In this way, 1st Send Email action will be executed, when the “custbody_cc_emails” field is not blank, and the 2nd Send Email action will be executed when the “custbody_cc_emails” field is blank.

     

    I hope my answer will help you with NetSuite saved search issues.

     

    • 464 views
    • 2 answers
    • 0 votes