Search code examples
formulanetsuitesaved-searches

Is there an option to see in Results Fields "Set By: Name", but to see the Internal ID of the employee instead of the name?

In Netsuite Saved Search in Results, I would like to see who create the record, but I would like to see the internal ID instead of the name. Is there any way "Set by: Name" setting in 'System Notes' field to show Internal ID of the employee rather than name Can I use formula instead of this field?

Thank you in advance

System Notes: Set by

Solution

  • To put this in an answer,

    Using {systemnotes.name.id} using Formula (text) as your field type will get you the answer. You can test this as {systemnotes.name} will just give you the user. You'll have to do a bit of filtering to ensure you're grabbing the right user.

    In the past, I've used workflows to fill a custom "Created By" field and grabbed my information from there.