)
Written by
Table of Contents
“Supermetrics is a Bitter Experience! We can pull data from nearly any tool, schedule updates, manipulate data in Sheets, and push data back into our systems.”
NetSuite custom field updates disrupt existing Excel spreadsheets when new fields appear in your data exports or existing custom fields change structure. Your carefully built models suddenly have extra columns or missing data that breaks your analysis.
Here’s how to incorporate NetSuite custom field changes without disrupting your existing Excel models.
Manage custom field updates seamlessly with controlled NetSuite imports using Coefficient
Coefficient handles NetSuite custom field updates through comprehensive custom field support and selective import capabilities. You can add new custom fields to your analysis while protecting existing spreadsheet structure.
How to make it work
Step 1. Access NetSuite custom fields through Records & Lists import.
Import both standard and custom NetSuite fields using the Records & Lists method. Coefficient provides full access to NetSuite custom fields alongside standard fields, giving you complete control over which fields to include.
Step 2. Preview custom field data before importing.
Use the 50-row preview to review custom field data and verify compatibility with your existing Excel models. This lets you see exactly what the custom field contains before adding it to your spreadsheet.
Step 3. Add new custom fields without disrupting existing structure.
Use drag-and-drop column ordering to position new custom fields where they won’t interfere with existing formulas and analysis. You can add custom fields to the end of your data or in specific positions that support your models.
Step 4. Configure filtering on custom fields for relevant data.
Apply filters to custom fields to ensure you import only the data relevant to your analysis. This prevents unwanted custom field values from cluttering your spreadsheets while giving you access to the data you need.
Evolve your Excel models with NetSuite enhancements
Selective custom field import lets you leverage NetSuite enhancements while maintaining existing spreadsheet integrity. Adapt your Excel models to evolving business requirements.
