Is it possible to create a field on the fly with S...
# suitescriptd
dcrsmith
11/07/2019, 4:15 PMIs it possible to create a field on the fly with SuiteScript 2.x?
c
creece
11/07/2019, 4:18 PMYou can create one using the form just like you can in 1.0
d
dcrsmith
11/07/2019, 4:19 PMUsing the form? Example?
c
creece
11/07/2019, 4:21 PMN/ui/serverWidget.Form.addField(...)
SA: 43669
Not sure if this is what you are after or not.
d
dcrsmith
11/07/2019, 4:54 PMNo, I'm wanting to add a custom field to a custom or native record, not on a form.
c
creece
11/07/2019, 4:55 PMYou gotta set that up in the UI there is no scripting to do that
d
dcrsmith
11/07/2019, 4:56 PMI think you can do it with web services. But I want to know if it can be done with SuiteScript now in 19.2.
m
michoel
11/07/2019, 6:36 PMI stumbled across this bundle installation script from an old NetSuite bundle. It looks like that's what it's doing:
michoel
11/07/2019, 6:36 PMcsearch.setFieldValue('internalid','_ns_pivotcache_searchid');//1 UI
csearch.setFieldValue('fieldtype','INTEGER');//1 UI
nlapiSubmitRecord(csearch);
//cache searchid reference
var csearchid = nlapiCreateRecord('customrecordcustomfield',{"rectype":cacheid});
csearchid.setFieldValue('label','Cached Search Type');//1 UI
csearchid.setFieldValue('internalid','_ns_pivotcache_searchtype');//1 UI
csearchid.setFieldValue('fieldtype','TEXT');//1 UI
nlapiSubmitRecord(csearchid);
var ds_tz = nlapiCreateRecord('customrecordcustomfield',{"rectype":cacheid});
ds_tz.setFieldValue('internalid','_ns_pivotcache_ds_timestamp');//1 UI
ds_tz.setFieldValue('label','DataSource Load TimeStamp');//1 UI
ds_tz.setFieldValue('fieldtype','DATETIMETZ');//1 UI
nlapiSubmitRecord(ds_tz);
var cache_lmt = nlapiCreateRecord('customrecordcustomfield',{"rectype":cacheid});
cache_lmt.setFieldValue('label','Last Modified TimeStamp');//1 UI
cache_lmt.setFieldValue('internalid','_ns_pivotcache_lmt');//1 UI
cache_lmt.setFieldValue('fieldtype','DATETIMETZ');//1 UI
nlapiSubmitRecord(cache_lmt);
*/
var script = nlapiCreateRecord('script', {'scripttype':'SCRIPTLET'});
//set body fields
script.setFieldValue('name','PivotSearch Installation');
script.setFieldValue('scriptid','_ns_pivotsearch_installation');
script.setFieldValue('scriptfile',nlapiSearchGlobal('pivotsearch.js')[0].getId());
script.setFieldValue('defaultfunction','service');
//add the libraries
script.setLineItemValue('libraries','scriptfile',1, nlapiSearchGlobal('date2.js')[0].getId());
script.setLineItemValue('libraries','scriptfile',2, nlapiSearchGlobal('ext-util.js')[0].getId());
script.setLineItemValue('libraries','scriptfile',3, nlapiSearchGlobal('trimpath-template-1.0.38.js')[0].getId());
script.setLineItemValue('libraries','scriptfile',4, nlapiSearchGlobal('PG-LayoutComposer')[0].getId());
var scriptid = nlapiSubmitRecord(script);
var deployment = nlapiCreateRecord('scriptdeployment', {'scripttype':scriptid});
nlapiSubmitRecord(deployment);
/*
javascript:{
nlapiSetFieldValue('name','PivotSearch Installation');
nlapiSetFieldValue('scriptid','_ns_pivotsearch_installation');
nlapiSetFieldValue('scriptfile',nlapiSearchGlobal('pivotsearch.js')[0].getId());
nlapiSetFieldValue('defaultfunction','service');
nlapiSetCurrentLineItemValue('libraries','scriptfile',nlapiSearchGlobal('date2.js')[0].getId());
nlapiCommitLineItem('libraries');
nlapiSetCurrentLineItemValue('libraries','scriptfile',nlapiSearchGlobal('ext-util.js')[0].getId());
nlapiCommitLineItem('libraries');
nlapiSetCurrentLineItemValue('libraries','scriptfile',nlapiSearchGlobal('trimpath-template-1.0.38.js')[0].getId());
nlapiCommitLineItem('libraries');
nlapiSetCurrentLineItemValue('libraries','scriptfile',nlapiSearchGlobal('PG-LayoutComposer')[0].getId());
nlapiCommitLineItem('libraries');
nlapiSetCurrentLineItemValue('deployments','title','PivotSearch Deployment');
nlapiCommitLineItem('deployments');
}
*/
```
michoel
11/07/2019, 6:36 PM```//customrecord - layout
var layout = nlapiCreateRecord('customrecordtype');
layout.setFieldValue('recordname','Search Pivot Layout');//1 UI
layout.setFieldValue('scriptid','_ns_pivotlayout');//1 UI
layout.setFieldValue('includename','F');//1 UI
var layoutid = nlapiSubmitRecord(layout);
//customfield
var searchRef = nlapiCreateRecord('customrecordcustomfield',{'rectype':layoutid});
//searchRef.setFieldValue('fieldtype','SELECT');//1 UI
searchRef.setFieldValue('fieldtype','INTEGER');//1 UI
searchRef.setFieldValue('label','Saved Search');//1 UI
//searchRef.setFieldValue('selectrecordtype','-119');//1 search record type
searchRef.setFieldValue('internalid','_ns_pivot_layout_search_id');//1 UI
nlapiSubmitRecord(searchRef);
var searchRef2 = nlapiCreateRecord('customrecordcustomfield',{'rectype':layoutid});
searchRef2.setFieldValue('label','Search _Type');//1 UI
searchRef2.setFieldValue('internalid','_ns_pivot_layout_search_type');//1 UI
nlapiSubmitRecord(searchRef2);
//layout title
var searchRef3 = nlapiCreateRecord('customrecordcustomfield',{'rectype':layoutid});
searchRef3.setFieldValue('label','Title');//1 UI
searchRef3.setFieldValue('internalid','_ns_pivot_layout_title');//1 UI
nlapiSubmitRecord(searchRef3);
//custom record - fields
var fields = nlapiCreateRecord('customrecordtype');
fields.setFieldValue('recordname','Search Pivot Field');//1 UI
fields.setFieldValue('scriptid','_ns_pivotfields');//1 UI
fields.setFieldValue('includename','F');//1 UI
var fieldsId = nlapiSubmitRecord(fields);
//customfield - parent reference
var parent = nlapiCreateRecord('customrecordcustomfield',{"rectype":fieldsId});
parent.setFieldValue('label','Layout');//1 UI
parent.setFieldValue('fieldtype','SELECT');//1 UI
parent.setFieldValue('selectrecordtype',layoutid);//1 UI
parent.setFieldValue('isparent','T');//1 UI
parent.setFieldValue('internalid','_ns_pivot_field_layout');//1 UI
nlapiSubmitRecord(parent);
//cf - report field sequence number
var seqnum = nlapiCreateRecord('customrecordcustomfield',{"rectype":fieldsId});
seqnum.setFieldValue('label','Search Field Sequence Number');//1 UI
seqnum.setFieldValue('fieldtype','INTEGER');//1 UI
seqnum.setFieldValue('internalid','_ns_pivot_field_seqnum');//1 UI
nlapiSubmitRecord(seqnum);
//cf - pivot type row/col/fact/measure
var type = nlapiCreateRecord('customrecordcustomfield',{"rectype":fieldsId});
type.setFieldValue('label','Pivot Type');//1 UI
type.setFieldValue('internalid','_ns_pivot_field_type');//1 UI
type.setFieldValue('ismandatory','T');//1 UI
nlapiSubmitRecord(type);
var type = nlapiCreateRecord('customrecordcustomfield',{"rectype":fieldsId});
type.setFieldValue('label','Search Alias');//1 UI
type.setFieldValue('internalid','_ns_pivot_field_alias');//1 UI
type.setFieldValue('ismandatory','T');//1 UI
nlapiSubmitRecord(type);
/*
//customrecord - cache
var cache = nlapiCreateRecord('customrecordtype');
cache.setFieldValue('recordname','Pivot Search Cache');//1 UI
cache.setFieldValue('showowner','T');//1 UI
cache.setFieldValue('scriptid','_ns_pivotcache');//1 UI
cache.setFieldValue('includename','F');//1 UI
var cacheid = nlapiSubmitRecord(cache);
//cache metadata
var metadata = nlapiCreateRecord('customrecordcustomfield',{"rectype":cacheid});
metadata.setFieldValue('label','MetaData');//1 UI
metadata.setFieldValue('internalid','_ns_pivotcache_metadata');//1 UI
metadata.setFieldValue('fieldtype','TEXTAREA');//1 UI
nlapiSubmitRecord(metadata);
//cache jsondatasource
var ds = nlapiCreateRecord('customrecordcustomfield',{"rectype":cacheid});
ds.setFieldValue('label','Cached DataSource');//1 UI
ds.setFieldValue('internalid','_ns_pivotcache_datasource');//1 UI
ds.setFieldValue('fieldtype','DOCUMENT');//1 UI
nlapiSubmitRecord(ds);
//cache searchid reference but
var csearch = nlapiCreateRecord('customrecordcustomfield',{"rectype":cacheid});
csearch.setFieldValue('label','Cached Search Id');//1 UI
michoel
11/07/2019, 6:37 PMSorry I'm on mobile ATM...
c
creece
11/07/2019, 6:38 PMinteresting ive def never seen something like that
d
dcrsmith
11/07/2019, 6:38 PMI was able to create a custom field
dcrsmith
11/07/2019, 6:39 PMJust not a custom record. I wonder if I can go off of this. Thank you @michoel
p
PabloZ
11/07/2019, 9:26 PMas far as i know - from years ago - this is indeed possible (with the code above, as custom record definitions are also records) but undocumented and not officially supported.
e
errol
11/08/2019, 1:56 AMUnless I am not fully understanding what you are looking for, you can create fields beforeLoad in user event scripts. form is passed in the context before load and you can add fields, buttons, sublists on the fly.
d
dcrsmith
11/08/2019, 1:58 AM@errol I'm not looking for form fields but rather record fields. I was able to do the fields. I haven't tried tackling the records yet.
e
errol
11/08/2019, 2:00 AMAhh I see. Out of curiosity if you don’t mind, what is the use case of needing to do that via script?
d
dcrsmith
11/08/2019, 2:01 AMbundle install script so the bundle doesn't have dependencies on records that are out of our control.
e
errol
11/08/2019, 2:03 AMMakes sense... cool idea
c
creece
11/08/2019, 2:33 AM@dcrsmith Can you post it (if you are able) once you figure it out? I am curious.
d
dcrsmith
11/08/2019, 2:33 AMpost what? my library for doing it or the install script