Discussions

Check out Oracle NetSuite upcoming events and conferences here
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now!
RUN, DON’T WALK...Registration for #SuiteWorld 2022 is officially OPEN! This special early bird price won’t last long, so make sure you don’t miss out: https://lnkd.in/gGRN78A3
YOUR VOICE MATTERS! VOTE FOR OUR NEXT WEBINAR TOPIC NOW.
Click on this link for the poll.

Saved Search - Display Formula Text Field to Screen

edited Dec 2, 2019 5:45PM in SuiteCloud / Customization 17 comments

I need to display the results of a saved search calculated field - Formula(numeric)

So far I was able to display the Internal ID, Name, Description which are grouped. Code so far looks like this:

function downstocking(request, response)  {      // Global Variables        var form;        // GET Request      if (request.getMethod() == 'GET')      {                      var myform = createForm();                var mysublist = createSublist(myform);                    var filters = new Array();                    //select all and remove all              mysublist.addMarkAllButtons();            //Define search columns          var columns = new Array();          columns[0] = new nlobjSearchColumn('internalid').setSort();          columns[1] = new nlobjSearchColumn('name');          columns[2] = new nlobjSearchColumn('displayname');          var searchresults = nlapiSearchRecord('item','20995');            var p = 1;            for (var i = 0; searchresults != null && i < searchresults.length; i++)                    {                      var searchresult = searchresults[i];                        mysublist.setLineItemValue('internalid',p,searchresult.getValue('internalid',null,'group'));                                                          mysublist.setLineItemValue('name',p,searchresult.getValue('name',null,'group'));                      mysublist.setLineItemValue('description',p,searchresult.getValue('description',null,'group'));                      p++;                                         }        function createForm()      {            form = nlapiCreateForm('Downstocking Report', false);                    form.addFieldGroup('maingroup', 'Select').setShowBorder(false);                    //form.addSubmitButton("Submit Checked Item(s)");           
Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!

Leaderboard

This Week's Leaders

This Month's Leaders

All Time Leaders