[sklett]

I’m trying to find it in the help but failing. I’m referring to the syntax that came out maybe 3-4 years ago where you define a field in a formula like this: {fieldid.name} or {fieldid.id}. Anyone know what I’m talking about?
This is a cached copy. Click here to see the original post.

[michoel]

https://system.netsuite.com/app/help…_N2832369.html

Using Foreign References in Formula Fields

When creating a formula field, you can reference data contained in fields on related records.

For example, if you created a custom entity field to apply to customer records, you could add a formula field that referenced a field on the employee record of the sales rep assigned to the customer.

Note: When referencing fields on other records, you are restricted to the records with search joins.

The format for formula field references is:

{fieldOnAppliedRecord.fieldOnJoinedRecord}

[Author]

Posts