My Stuff

Frank Lau Red Ribbon

Comments

  • Never mind this post, I found the solution now.
  • Solved now, just need to use the entity field values(company name, first name, and last name) for the custom record fields as the URL parameters.
  • NetSuite: When I open the Record Type list, I can see some custom record type is UNDERLINED but some are not. How can I take off the underline? If the record type is underlined, the user simply click on it and be able to config the record type, and I do not want the user config the record type. For example) Custom Record…
  • Just wonder, is what you plan to do below related to tracking HITs on an Ad banner? I wonder how you track those HITs that lead to the NetSuite online form submits Hi there, We are trying to write a suitescript that will activate the google analytics track transaction code when customer service creates a sales order in the…
  • Are the code you provided for hiding buttons on UI ? not on the custom online forms, right?
  • Actually I had the issue in iPad mini.... iPad seems to be fine. I open an online form in iPad mini, select a dropdown selection, a javacript pop up message shows up with "OK" buton. I press OK button but it does go away, and I can not do much after that, the pop up message does not go away. Please see if you have the same…
  • Anyone have the same issue in ipad mini like I do?
  • Can I use nlapiAddDays(d, 1/24) to add ONE hour ? Hi all, I see there we can use nlapiAddDays(d, days) for adding days to the system date. But how do I add hours to the system date? thanks
  • shocking... I thought PCs do calculation just like calculators, apparently not... Yes, this is a known issue within Javascript (and many other languages in fact). You can do some Google research, but he's a basic article I found explaning very briefly the problem: http://floating-point-gui.de/basic/
  • Thanks Ayman. But I think Math.ceil() will increase any outputs to its nearest integer, am I right? so for example, Math.ceil(4.1) = 5 I think I just wanted to know if this happens to everybody who codes scripts in NetSuite. thanks Try the following , hope it will help.: var num = 61776 / 1.08; // == 57199.99999 num =…
  • awesome tip, thanks nlapiSearchRecord requires a "saved search id" parameter. If you're not searching using a specific saved search, pass null. For example: var results = nlapiSearchRecord('salesorder', null, [ ['mainline', 'is', 'T'], 'AND', [ ['sometextfield', 'startswith', 'This'], 'OR', [ ['sometextfield',…
  • Awesome ! thanks You can use Filter Expressions in nlapiSearchRecord. Here is an example: var filters = [['mainline', 'is', 'T'],'AND', ['type', 'anyof', ['CustInvc']],'AND',[['sometextfield', 'startswith', 'This'],'OR',[['sometextfield', 'startswith', 'That'],'AND',['sometextfield', 'contains', 'OtherThing']]]]; var…
  • Awesome tip, thanks OniNoKami. Using setOr(value), value can be true or false. If we set value to false, then it will set AND, if we set value to true, then it will OR var filters = new Array(); filters[0] = new nlobjSearchFilter( 'custrecord52', null, 'contains', 'aaa' ).setOr(true); filters[1]= new nlobjSearchFilter(…
  • Hi, Are you positive that I can not apply your filter expressions below to nlapiSearchRecord() ? thanks Using filter expressions... var search = nlapiCreateSearch('transaction', [ ['mainline', 'is', 'T'], 'AND', ['type', 'anyof', ['CustInvc']], 'AND', [ ['sometextfield', 'startswith', 'This'], 'OR', [ ['sometextfield',…
  • Hi, thanks. I also wonder how system knows how to group OR/AND wihout using brackets? For example, filter[0] OR filter[1] AND (filter[2] OR filter[3]) is different from filter[0] OR (filter[1] AND filter[2]) OR filter[3] thanks Using setOr(value), value can be true or false. If we set value to false, then it will set AND,…
  • thanks, so all I need to do is to insert your codes below my example, will it work? I have had success on the client side doing the following filters[0].isor = true; filters[1].isor = true;
  • Likely, you will need to script to track all of the email messages under the customer, and then track all of the files (internal id) that are attached to the messages, then perform delete one by one. See if you can use a search to come up with all of the message id and file id We're cleaning up a spam flood in which many…
  • Is it a transaction PDF layout form? Have you tried to change your encoding to UTF-8 in preference? BFO XMLtoPDF can it display Chinese? We are a Hong Kong company, some of our custom PDF should have some Chinese character in the form. Until now, i still can't type in any Chinese character by the code. Does anyone know…
  • a blank page will pop up though... Hi All, Is there any way to access/trigger a Suitelet by an User event script? Thanks
  • I have tried to use script assign Sales Rep but it seems like script can not do so. can you let me know if workflow works on this? thanks Hello Skhanna, Yes, I have ended up making a large workflow to set this based on Sales Rep. Trigger on: After field Edit Client Field: Sales Rep Condition: Sales Rep = Salesrep1,…
  • Olivier, thanks. What happens if the mian file and its library files have the same function names? Yes. You don't need to do anything special. Anything in a library file can be used just like if it was in your main file.
  • Hi, For example, if the conditions in the following if-else are not met, the online form can not be submitted. In addition to this costom if-else, there are mandatory field (YES/NO) checkbox on the NetSuite online form config. If the conditions on the mandatory (YES/NO) are not met, the online form can not be submitted…
  • Hi Olivier, Can you comment on the following question? thanks Olivier, ok. I do need to set fields. How about this, let us say I make another UE scripts to take care of the set fields, and this new UE script is triggered on the CREATE of a sales order. so menaing that, an online Submit will trigger UE script#1 to make…
  • Hi Olivier, The UE script is triggered on the custom online form Submit (on the create of a new prospect record) Are you sure that simply use nlapiGetFieldValue() will work? without loading, how do I do nlapiSubmitRecord(???, true) thanks afterSubmit should work
  • Hi Olivier, So are you saying the deployment of User Event scripts should not delay the opening of redirectURL ? but the delay was due to the efficiency of the coding ? I turned off most of the UE scripts applied on "Create", and it took only 4 seconds afterSubmit to the redirectURL But when UE scripts are applied, it…
  • thanks Olivier, ok. I do need to set fields. How about this, let us say I make another UE scripts to take care of the set fields, and this new UE script is triggered on the CREATE of a sales order. so menaing that, an online Submit will trigger UE script#1 to make sales order, then the new sales order will trigger UE…
  • Hi Olivier, Nevermind about the following question, I found out where the problem is. thanks Hi Olivier, Can you take a look and let me know why the following UE script result an error "Title" (SSS_MISSING_REQD_ARGUMENT) ? ------------------------- function onlineSubmit() { var inCosID = nlapiGetRecordId(); var senarioID =…
  • Olivier, thanks for the tip. Yes, I tried nlapiGetFieldValue() before, yet I kept getting an error text like "title" so I gave up. If I want to use nlapiGetFieldValue(), do I set the script to beforeload, beforeSubmit, or afterSubmit ? Ah, you create SOs. Yes, that will take a few seconds to do. However, your scripts can…
  • Olivier, It will be very helpful if you can tip me on this one, this can be the bottle neck of this project. Thanks ====================================== Hi Olivier, The UE script is triggered on the custom online form Submit (on the create of a new prospect record) Are you sure that simply use nlapiGetFieldValue() will…
  • Hi Olivier, The following is the algorithm of one of the UE script that I applied on "Create" so it is triggered through the online forms (and I think I use the same algorithm for most of the UE scripts) can you see if this is the right way to do it? =========================================== //Get prospect data var…