Special Fields, Formulas, and Joins

The special field types are [time], [date], and [array]. If you set fields of these types on the Case or Task record, they should be declared in projectmap and casemap so NetSuite can process them correctly.

To define special fields, you need to include the appropriate suffix within the field. For example:

          "projectassets": "custentity_nxc_project_assets[array]" 

"exampledate": "custentity_example_timefield[time]" 

        

You can use formulas to apply more complex logic in the Program, such as providing a fallback if a field is empty. For example:

          "casetype": "formulatext:nvl({custentity_nxc_case_type},2)" 

        

You can also use joined fields when the value is reached through a related record. For example:

          "email": "contactprimary.email|" 

        
Note:

Some older accounts may contain projectmap entries for standard fields that don't need to be mapped. For example, you may see something like the following code:

"projectmap": { "casetype": "custentity_nxc_case_type" },

This entry is unnecessary, as custentity_nxc_case_type is a standard field and it can be directly included in the projectrules area. It won't cause issues if it's included in the projectmap area, but it's best practice to remove the entry. To make sure it still works, be sure to test your code after removing anything.

Related Topics

General Notices