Frank Lau

Olivier, Hope you can give me some tips on this one. I do not think that Online Form custom script can perform nlapiSearchRecord(), can you confirm with me on this one? Meaning, I can not simply insert nlapiSearchRecord() into an online form custom code file. Then, can the online form perform any searching on the customer…

in Create a sales order upon submit of Online Form Comment by Frank Lau Feb 22, 2010 12:41AM

Hi all, On the online form custom code, I tried these codes but none of them worked, why?? ------------------------------------- function toSuitelet() { nlapiSetRedirectURL('SUITELET', '113', '1'); return true; } -------------------------------------- function toSuitelet() { nlapiSetRedirect('SUITELET', '113', '1'); return…

in Create a sales order upon submit of Online Form Comment by Frank Lau Oct 14, 2009 11:17AM

Hi Olivier & NetSuite, I am having a problem with scripting a search, can someone help me out a bit? Thanks How do I include a transaction field filter into a customer search? For example, the following does not work. ---------------------------------------- filterSalesOrder[0] = new…

in Create a sales order upon submit of Online Form Comment by Frank Lau Oct 11, 2009 9:57PM

Olivier, Thanks for your tip. Your answer did provide me a basic idea. My process is, I will provide a pre-order online form to my existing customers for filling up their purchases, then the new sales order will be created upon the submit of the online form. Can you let me know the basic command that is used to create a…

in Create a sales order upon submit of Online Form Comment by Frank Lau Sep 29, 2009 10:35AM

Never mind the problem is solved now. Thanks

in Create a sales order upon submit of Online Form Comment by Frank Lau Oct 12, 2009 1:25AM

NetSuite, Under the Custom Code of any forms/online forms/custom records, the scripts are always underlined for the users to download. How can I prevent any other users to download the script files? Even though I restrict the groups in the "File Cabinet" and set the folders to private, can any other users still download…

in Prevent the others to download scripts Comment by Frank Lau Sep 16, 2009 8:54AM

Yang, Thanks. How come I submit an enhancement for voting? Frank

in User Event triggered by Import/Merging Comment by Frank Lau Aug 31, 2009 11:19PM

Hi Yang, Thanks for the tip. Can you take a look at the following function triggered upon SAVE of a custom record? I am very sure the record I SAVE has an internal ID, but the internalid value returned by the log is "NULL" function writeExternalID() { var regHistoryInternalID = nlapiGetFieldValue('internalid');…

in ExternalId in custom record type Comment by Frank Lau Aug 8, 2009 10:54PM

Yang & MGoodMan, For the USER EVENT script to write in the external value, I think I have to include nlapiSubmitRecord(true) right after the following two lines, correct? ------------------- nlapiSetFieldValue('externalid', toWriteExternalID); nlapiLogExecution("debug", "New External ID", "External ID Assigned: " +…

in ExternalId in custom record type Comment by Frank Lau Aug 9, 2009 10:37PM

Hi MgoodMan & Yang, Can you guys take a look at the following? These two functions are the samples I use as the custom code attached to the custom record form. pageInit() is for upon the EDIT and submit() is for upon the SAVE. Anything are wrong with the codes? function pageInit() { var thisExternalID =…

in ExternalId in custom record type Comment by Frank Lau Aug 6, 2009 10:07AM

Hi MgoodMan & Yang, Can you guys take a look at the following? These two functions are the samples I use as the custom code attached to the custom record form. pageInit() is for upon the EDIT and submit() is for upon the SAVE. Anything are wrong with the codes? function pageInit() { var thisExternalID =…

in ExternalId in custom record type Comment by Frank Lau Aug 6, 2009 10:04AM

Should I include nlapiSubmitRecord() or nlapiSubmitField() ??

in ExternalId in custom record type Comment by Frank Lau Aug 10, 2009 1:26AM

Hi Yang, Thanks for the tip. Can you take a look at the following function triggered upon SAVE of a custom record? I am very sure the record I SAVE has an internal ID, but the internalid value returned by the log is "NULL" function writeExternalID() { var regHistoryInternalID = nlapiGetFieldValue('internalid');…

in ExternalId in custom record type Comment by Frank Lau Aug 8, 2009 10:53PM

mGoodMan & Yang, Can you guys try out the two functions I mentioned earlier... ?? When I tried those two functions, it looks like it works from the values returned by alert() However, when I click SAVE, the value does not write into ExternalID. I really need to write values into this field by client script so there will…

in ExternalId in custom record type Comment by Frank Lau Aug 6, 2009 10:19PM

Thanks all, the problem is solved. Everything works fine now.

in ExternalId in custom record type Comment by Frank Lau Aug 10, 2009 8:28AM

Yang & MGoodMan, Sorry for bringing this issue up again. Actually it did not work, for some reasons, it just could not write in externalid value by using USER EVENT script. I wrote the following lines in the code, but nlapiSetFieldValue('externalid', brah) just could not work, nlapiLogExecution() works fine though.…

in ExternalId in custom record type Comment by Frank Lau Aug 9, 2009 10:22PM

Thanks. It works now..

in ExternalId in custom record type Comment by Frank Lau Aug 9, 2009 9:21PM

Yang, Thanks. In such case, I have to use an USER EVENT script to write in the externalID. How can I pass the parameters from the custom record to the user event script? For example, I want to pass the following parameters on the custom record(ID#001) to the user event script, so the script can write the externalID into…

in ExternalId in custom record type Comment by Frank Lau Aug 7, 2009 3:14AM

Hi anyone & NetSuite, I just need some tips on this issue: On the HTML template of a custom online form, I have include some non-NetSuite fields (HTML input controls). Then, I want a javascript to detect the fields upon field changed. I have tried to use if(name == xxx ) in the custom code file to detect the non-NetSuite…

in HTML and javascript integration Comment by Frank Lau Oct 29, 2009 4:43AM

Yang, Thank you for your advice. But can you double check for me to use the line you wrote me? I thought I could use the line too but it did not really work out for me. nlapiGetFieldValue() is ok to get externalID but nlapiSetFieldValue() failed to write in. Thanks

in ExternalId in custom record type Comment by Frank Lau Aug 6, 2009 5:24AM

Thank you all, the script is working FINE with lead, prospect, and customer now !!

in he record you are attempting to load has a different type Comment by Frank Lau Aug 17, 2009 2:13AM

Yang, Are you sure if I apply to customer only, and the user event script will be triggered on the Prospect too?? Do you think I can use the script to check on the TYPE of the customer and then somehow control the display of the error message? For example: function addressSWAP(type) {

in he record you are attempting to load has a different type Comment by Frank Lau Jul 26, 2009 8:49PM

The following is the sample of the user event script triggered on the EDIT of the prospect and customer record: --------------------------------------- function addressSWAP() { var theCustomer = nlapiLoadRecord(nlapiGetRecordType(),nlapiGetRecordId()); var customerID = theCustomer.getFieldValue('entityid'); var firstName =…

in he record you are attempting to load has a different type Comment by Frank Lau Jul 24, 2009 2:42AM

Hi all, Actually I have a problem now, after I modify the code you mentioned. The script somehow can not be triggered by "Apply to" customer. But it is triggered by Lead and Prospect... I do not understand why...

in he record you are attempting to load has a different type Comment by Frank Lau Aug 17, 2009 5:17AM

Yang, I am confused, I need some examples. Are you saying I need to edit this line to accept the change of the customer record type? var theCustomer = nlapiLoadRecord(nlapiGetRecordType(),nlapiGetRecor dId());

in he record you are attempting to load has a different type Comment by Frank Lau Jul 27, 2009 3:52AM

Yang, I am confused, I need some examples. Are you saying I need to edit this line to accept the change of the customer record type? var theCustomer = nlapiLoadRecord(nlapiGetRecordType(),nlapiGetRecor dId());

in he record you are attempting to load has a different type Comment by Frank Lau Jul 28, 2009 9:31PM

Yang, Thanks. But are there any other ways I can get the text of the country dropdown? I want to get the text on the "country" dropdown in the addressbook, how can I do it through the form custom code?

in Does not work, why ? (custom code on FORM) Comment by Frank Lau Jun 10, 2009 1:18AM

Problem is solved now, no need of any switch statements or codes... All you need is to add a new form field to the custom record for storing the abbreviated country code.

in Does not work, why ? (custom code on FORM) Comment by Frank Lau Jun 11, 2009 3:03AM

Yang, for example: In the addressbook, the value in the dropdown for United State is "US" But through the custom code of FORM, how can I get its text "United State of America" ??

in Does not work, why ? (custom code on FORM) Comment by Frank Lau Jun 10, 2009 1:37AM

var adminEmail[0] = 'someone@someone.com'; var emailTitle = 'NetSuite Script Execution Report'; Line#27 is either one of the above. I do not see anything wrong but the script would not work unless I took the whole portion out of the script...

in missing ; before statement (WHY?) Comment by Frank Lau Jun 2, 2009 12:31AM

MFA for Oracle Community

Frank Lau Red Ribbon

Comments