Awesome tutorial :) by the if I may ask, is it possible to make the list dynamic? Like can we add a Radio button or select field to the column to update the data? Thanks!
Great overview. How would you go about adding column Totals. (e.g. Total count of Cases, or if there were values to sum, the Sum in the relevant column)?
Lots of ways to go about this. Sublists have a "Totalling Column" you can leverage which works similar to the way Transactions will show the total amount of the Items sublist on the sublist tab. There's not a good native way to visually distinguish any row from any other. If I needed a full row of totals or several total values, I'd likely put them in body fields within a field group above the list, below any filters or other fields.
Hello Eric, Would it be possible to add real-time filters to the sublist (just like in the saved search where you select filters after running the search)?
Sure you can add your own fields to the Suitelet page that act as filters. General approach is to add the relevant fields to the Form, then use the Submit button to POST back to the Suitelet. In your POST handler, read the values from the filter field to reconstruct the search that populates your sublist with the appropriate filter values.
@@StoicSoftware Thats what Im actually doing right now, I thought there was a way to implement the native look and feel of the saved search filter region (with the cool date selector and all). Guess thete isnt an easy way. Thanks!
@@pjl3dm Yeah unfortunately that's the best option we have. Apparently there is a major overhaul of the UI API coming some time in the near future, but I don't have any details on it yet.
Check the Help documentation for the Sublist object; there is an `addMarkAllButtons` method. There is not one for the List object, so you'd have to make your own custom button to mimic the functionality.
I would like make a form for searching item request slips and allow user can select result on multi rows then click "Generate PO" button. There 2 buttons Search and Generate PO. Can suitelet resolve it?
Thanks Eric for sharing! I'm kind of new here and I have an issue with the map function. Does not work for me. My saved search is not not as simple, I have joins and formulas :( Do you have any clues please? Thanks
The `getValue` function has a `join` property you can lean on to retrieve your joined values. Formulas are more complicated, particularly if you have more than one formula of the same type. I do have cookbooks that provide a ton of examples for working with the Search API, including joins and multiple formulas: stoic.software/cookbooks/.
Question: The map(resultToObject) worked fine a few months ago, but now visiting this I am getting " Cannot find function map in object search.ResultSet. " Did something change with the newest update to Netsuite? Also, great videos!
Would have to see your code, but it looks like you're invoking `map` on the `ResultSet` rather than on an Array of `Result` instances (e.g. the output of `getRange()` ). It's likely you just missed a single step/call in your code.
@@StoicSoftware Queue Bette Midler "You're my hero." Was as you said, was invoking on ResultSet. Sigh. *head shake* On a positive note: your search cookbooks are great. Keep them coming, I'd be willing to pay for more and I would say others too since you are the only reliable resource on SuiteScript I have found.
Suitelets are not built for bulk processing. If you are using a Suitelet as a front-end for a larger process, then the Suitelet only needs to pass the relevant data along to a Map/Reduce.
![[ESS] The Event Lifecycle of a NetSuite Record](http://i.ytimg.com/vi/coLkgeuTFFM/mqdefault.jpg)
![[ESS] The Event Lifecycle of a NetSuite Record](/img/tr.png)
![[ESS] How Do I Add a Button to a Suitelet in NetSuite?](http://i.ytimg.com/vi/u0B3EVX8JvE/mqdefault.jpg)
![[ESS] A Brief Overview of SuiteScript](http://i.ytimg.com/vi/CmfgG-cxm_c/mqdefault.jpg)
![[ESS] How do I add a button to a NetSuite record with SuiteScript?](/img/n.gif)
Absolutely awesome. Many years old but still relevant today. 🙏
Thanks for the kind words! Glad you found it helpful.
Thanks! I enjoyed the subliminal storm trooper at 9:27, but it left me feeling a little like I should subjugate.
Awesome tutorial :) by the if I may ask, is it possible to make the list dynamic? Like can we add a Radio button or select field to the column to update the data? Thanks!
Great video. Really enjoyed your workflow!
How would one go about adding filters to this suitelet to filter the rows in the list?
same question for me also..did u get answer?
Great overview.
How would you go about adding column Totals.
(e.g. Total count of Cases, or if there were values to sum, the Sum in the relevant column)?
Lots of ways to go about this. Sublists have a "Totalling Column" you can leverage which works similar to the way Transactions will show the total amount of the Items sublist on the sublist tab. There's not a good native way to visually distinguish any row from any other. If I needed a full row of totals or several total values, I'd likely put them in body fields within a field group above the list, below any filters or other fields.
Thanks for sharing your knowledge
Please share the source code in the description too since it's easier to check as to where and what needs be done and changed.
Thank you Eric!
Hello Eric,
Would it be possible to add real-time filters to the sublist (just like in the saved search where you select filters after running the search)?
Sure you can add your own fields to the Suitelet page that act as filters. General approach is to add the relevant fields to the Form, then use the Submit button to POST back to the Suitelet. In your POST handler, read the values from the filter field to reconstruct the search that populates your sublist with the appropriate filter values.
@@StoicSoftware Thats what Im actually doing right now, I thought there was a way to implement the native look and feel of the saved search filter region (with the cool date selector and all). Guess thete isnt an easy way.
Thanks!
@@pjl3dm Yeah unfortunately that's the best option we have. Apparently there is a major overhaul of the UI API coming some time in the near future, but I don't have any details on it yet.
How I have suitlet to take input and return data on same form, instead of going to other forms
Really like your work
How to add Mark all and Unmark all in Suitelet for list in 2.0
Check the Help documentation for the Sublist object; there is an `addMarkAllButtons` method. There is not one for the List object, so you'd have to make your own custom button to mimic the functionality.
how to add total count at the rightmost of list navbar?
I would like make a form for searching item request slips and allow user can select result on multi rows then click "Generate PO" button. There 2 buttons Search and Generate PO. Can suitelet resolve it?
It was a great video, I need some help in Suitelet development this is something not easy but kind of hard, How I can reach out to you?
Thanks Eric for sharing! I'm kind of new here and I have an issue with the map function. Does not work for me. My saved search is not not as simple, I have joins and formulas :( Do you have any clues please? Thanks
The `getValue` function has a `join` property you can lean on to retrieve your joined values. Formulas are more complicated, particularly if you have more than one formula of the same type. I do have cookbooks that provide a ton of examples for working with the Search API, including joins and multiple formulas: stoic.software/cookbooks/.
You are my Hero
Question: The map(resultToObject) worked fine a few months ago, but now visiting this I am getting " Cannot find function map in object search.ResultSet. " Did something change with the newest update to Netsuite?
Also, great videos!
Would have to see your code, but it looks like you're invoking `map` on the `ResultSet` rather than on an Array of `Result` instances (e.g. the output of `getRange()` ). It's likely you just missed a single step/call in your code.
@@StoicSoftware Queue Bette Midler "You're my hero." Was as you said, was invoking on ResultSet. Sigh. *head shake*
On a positive note: your search cookbooks are great. Keep them coming, I'd be willing to pay for more and I would say others too since you are the only reliable resource on SuiteScript I have found.
how do you handle ss governance? suitelets only have 1000units 🥺
Suitelets are not built for bulk processing. If you are using a Suitelet as a front-end for a larger process, then the Suitelet only needs to pass the relevant data along to a Map/Reduce.
Stoic Software thank you for your insight.