My Stuff

Frank Lau Red Ribbon

Comments

  • 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 = nlapiGetFieldValue('custentity219'); var cosID = nlapiGetFieldValue('entityid'); var…
  • Are there any ways we can make the directURL show up first before USER Event scritps are triggered ?? Why would an UE script that has nlapiLoadRecord() command slow down the URL redirect on the online form?
  • Why would an UE script that has nlapiLoadRecord() command slow down the URL redirect on the online form? Hi all, I am facing an issue that the online form submit process takes too long to do URL redirect because of many USER EVENT scripts applied to the prospect records. If there are no user event scripts applied, the time…
  • Yes, and I applied to all roles. It is very strange, I have tested so many times to see where the issue is, then I find out that the end users can trigger the scripts yet they can not send out email by nlapiSendEmail() unless I include the end users into the Adm roles. Why? Is the deployment set to Execute as Admin?
  • Still have problem with this issue. Hi all, Are there anyone who have no problem with overwriting custom preferences using the admin role to trigger a suitelet script, yet have problem doing so by using non-admin roles ? I find I can not use non-Admin roles to access user type parameters under custom preferences. Any tips…
  • Are there anyone who can tip me on this? Hi all, Can someone tip me on this issue? I am working on a suitelet script that needs to access the parameters in custom preferences. so I made the suitelet parameters to be "User" type so our end users can set the values on their own. Yet, so far everything works perfectly fine…
  • Hi, I forgot to read the last line you wrote.... Even though it is risky, I think the script you provided will not delete any existing files, right? Thanks Here. You can use the sample code below to change the location of the folder and then copy its contents with it. function changeFolderLocation() { var originalFolderId…
  • Thanks, this will make it easy for the backup job. Here. You can use the sample code below to change the location of the folder and then copy its contents with it. function changeFolderLocation() { var originalFolderId = '13'; var newFolder = nlapiCopyRecord('folder', originalFolderId); newFolder.setFieldValue('parent',…
  • Hi, Did you mean nlapiCopyRecord does not COPY the files within the folder? Are there anyways that I can automate this copying process by scripting? Thanks You can use the sample code below. It will change the location of the folder. function changeFolderLocation() { var folder = nlapiLoadRecord('folder', 13);…
  • thanks, but NO, that is not what I was looking for. What you meant was to change the date format per end user's preference. But what I meant was the system wide customer online forms that are already published, changing my preference will not change the date format system wide. I am not sure if this is what you would want…
  • Hi all, If there are no ways to stop this auto-reformat on the NetSuite config, I think I have to convert this DATE field type to Text field type, and then I can add the script to the validation handler for checking the format. The date validation works very well on the text field type. but I do not think the validation…
  • Thanks Yang. My original validation intention ONLY is to check the format is YYYY/MM/DD But now, without any validations, the date field re-format the format by itself. After re-format, the format is correct, but the date is not what the customer wanted. Are there any places in NetSuite that I can control(or stop) this…
  • Thanks, One more question: If a scheduled script has a limit of 10000 units for a single execution, does it mean 10000 units for all of the deployments under this scheduled script? What is the limit for one deployment? Thanks
  • Hi Olivier, Thanks. Then, how do I pass the inputs on the HTML textbox through the SuiteLet to NetSuite? All of the HTML textboxes are hardcode in the Suitelet parameters, how do I get the inputs, and then pass? Do I have to include all of the inputs in the new suitelet URL that is re-called by the submit button? Thanks…
  • Hi Olivier, Thanks. Yes. I used nlapiSearchRecords() to call an existing search, then I used nlapiLogExecution() to output the length of the search on the system note so I have an idea about the records that are processed. But then, the length of the search changes sometimes. For example, if the search has 100 records left…
  • Thanks, but using "location" really does not work all the time. So far, window.open() works all the time.... Therefore, this is the recommendation to the others in case you need to close the window pop up after the suitelet script is triggered. You have to assign a variable to the window.open() then you can close() the…
  • Hi, Same problem, "location.href" does not work always... Soemtimes, it triggeres, sometimes it does not. Why? @fulanku you can try "location.href" instead of "document.location"
  • The following URLs are samples only. For example, using the following works sometimes.... document.location="https://forms.netsuite.com/app/site/hosting/scriptlet.nl?script=113&deploy=1&compid=448734&h=bb9bbb453534534355354"; So, I use the following instead, it works all the time, but I will have one pop-up window.…
  • Yeah... guys.... I found out Accounting lists like "term" is not available on the online form. Can you guys confirm if you have the same problem too? Is the "term" available on the online form ? Thanks
  • Olivier, If the online form does now allow searching on customer or sales order records, how can I prevent an EXISTING customer submit more than one time online form to create new sales order? Meaning, if I let the online form trigger a suitelet script to create a new sales order, I want to prevent the customer submit more…
  • The online form gives me this error when I used the online form to do sales order searching: JS_EXCEPTION TypeError Access is denied. I think the Online Form does not have the require rights to access Saved Searches in Netsuite. Try fully coding your search within your script rather than calling search 2271 with additional…
  • Hi Olivier, Suitelet can be triggered ONLY by URL, then are there anyway that I can make the URL page close by itself after it is triggered? It is bothersome when I have to let the customers close the page... Thanks I think the Online Form does not have the require rights to access Saved Searches in Netsuite. Try fully…
  • so you certainly would use Suitelet rather than User event script? So far, user event script works fine on searching a specific sales order. Meaning that I can let external customer submit an online form with radio button value and existing customer ID, then upon submit, the user event will search existing sales order…
  • Olivier, Thanks. How about this, can you tell me how I can use a client script to trigger a Suitelet script. What I can do is to get the radio button value through the client script(custom code) on the online form, then hopefully the client script can trigger the Suitelet with some parameters in the suitelet URL. If using…
  • NetSuite or Olivier, I have a new problem with making the user event script that needs to make a new sales order. I have a HTML radio button parameter and I need to pass its value to the user event script. I have been getting some errors and I need some tips for passing the value: What is the commend to pass the radio…
  • Olivier, I got it. Here is the sample: var searchresults = nlapiSearchRecord( 'opportunity', null, filters, columns ); Thanks
  • Hi Yang, Thanks, can you tell me if I can overwrite the value of 'sRedirectUrl' in the online form custom code? I want the online form redirect to different sites based on the submitted values.
  • I think I really have problems with this online form calling scripts. I made an user event script, and it works when an online form is submitted, but I have some radio buttons on the html form and I do not know how to pass the values to the user event scripts. I also made a suitelet script with an URL to be triggered when…
  • Olivier, Thanks. I see, so you mean not to call the existing search but to initiate a new search? Can you let me know the basic commend to initiate a new search? any samples will be very helpful.
  • Hi Olivier & NetSuite, Thanks for the tips, as I am testing the script now, I am having a problem and I can not find any solutions: The following script works when I edit the customer record in NetSuite, but it does not work when I submit a record through the online form. The error message shown through the online form is:…