Hi Thanks for the reply, no it is not related to a support case, this is just a custom record to capture a query against another custom record, when the query is responded to I can set a field but would like someway to alert/change status when the email is responded too.

Thanks Jack that worked great. Thanks for all the other ideas as well everyone.

Hi, Many Thanks for your reply, the date/time is showing correctly now but when I try to save the record this is applied to (Customer record in this case) I receive an unexpected error. 'An unexpected error has occurred. Please click here to notify support and provide your contact information.' EDIT : Seems to have been an…

Sorry to dig up an old post, but did you ever resolve this as we are experiencing similar issues.

I have a similar issue, if I try to go to an existing record the field does not get populated, however if I can to create a new record the field will be populated. I've tried adjusting my actions as suggested above but still not joy.

Has anyone tried running this on a Windows limited account, we have them throughout our organisation to stop users from being able to fiddle with their systems and net suite for outlook doesn't even start up, we get a garbled error message and no sign of the save to net suite buttons in outlook. Has anyone else got it…

Thanks Sean, I have used nested list that way previously, unfortunately in this instance I can't set the first field by default it needs to be selectable. I might have to approach this in a different way.

nlapiSubmitRecord gives you the customer ID directly. (so no need for id.getFieldValue, you can use id directly) You cannot set a value on a record gotten from nlapiGetNewRecord (it is read-only). You could do : nlapiSubmitField(newRec.getRecordType(), newRec.getId(), 'custrecordsb_tranid', id); I am not entirely sure how…

Many Thanks, this is all really interesting stuff and certainly gives me a few options to play with.

Removing the sublist from the form and replacing with the search sublist works in terms of viewing what i want, but when you try load the parent record via suite script the sublist does not show, I have tested this in debugger (see screenshots, top one child sublist shown, bottom one search sublist shown)…

Thanks for the idea, I like the way it looks but for my purposes having the child record attached to the parent as a sublist is important for future processing, via the search that relationship is not available via script without some search comparisons.

Zeeshan, Thanks very much for your reply, after a few attempts i finally managed to get all the buttons to disappear. Just need to work out how to do it in edit mode now as the ID I am collecting does;t appear to be working!! Many Thanks Ben

Hi Ben, Yes, this is achievable. I've done something similar. I wrote a function that sets my NAME field based on other fields populated on the form. The set field value line looks like this: nlapiSetFieldValue('name', meetingName); I saved this script and uploaded it to my client's site. From within my Custom Entry Form…

It was a WFA, managed to get it to work in the end, but now found out this isn't a viable solution anyway so have scrapped the idea. Thanks for taking the time to reply.

Just an addition - This code runs perfectly in Debugger, only gets the error when actioned from a workflow button. Solved now - file had corrupted on upload

I've done this when creating a new record I am able to set the form, you need to make sure the checkbox 'Store Form With Record' on the form is checked. As far as I can see from testing that form then stays set to that record. var AssRepRec = nlapiCreateRecord('customrecord_report_writing');…

Figured this out myself, there is an 'allof' expression, not listed in the help guide though!!! Tut tut netsuite.

Thanks for the advice, I'll give that a try.

Did anyone get an answer to this as I have the same problem. 

nevermind I solved it.

Sorry mate this was 2 years ago and I don't remember the exact cause.

I'm not convinced it is a defect, my problems seem to be around this section. //Set up array of email addresses var ccArray = new Array(); if (clientEmail != null) {ccArray.push(clientEmail);} if (ManagerEmail != null) {ccArray.push(ManagerEmail);} if (CaseAdvEmail != null) {ccArray.push(CaseAdvEmail);} if (Email1 != null)…

Predeep, you are the Man!! Thanks very much, that worked a treat.

Hi Ben, if you are using saved search, first you have to get all columns and then you can get the column value. Refer the below code. var arrSearchResults = nlapiSearchRecord('transaction','customsearch_ass_inc_midras_total_2',null, null); //Looping through each result found for(var i = 0; arrSearchResults != null && i…

Hi Predeep, I am doing this on a Workflow Action script as I want it firing via a button press, I have actually got it to work now using the following code. // Close the attached Sales Order var soRec = nlapiLoadRecord('salesorder',Soid); // Define variables var n_icount = soRec.getLineItemCount('item'); var n_linesclosed…

I've tried the below code and it seems to work but nothing changes on the record, anyone got nay idea why? var soRec = nlapiLoadRecord('salesorder',169408); // Define variables var n_icount = soRec.getLineItemCount('item'); var n_linesclosed = 0; var chklineclosed = false; // Loop through line items for (var i = 1; i <=…

Thanks man, that worked. Interesting on the before after submit, I did it this way as I needed the value to be populated in a field for use in a mail merge, when I tried before submit the field data would't get used in the mail merge.

Might I suggest you don't populate the array element with a null value in the first instance? something like : if (managerEmail != null) {ccArray.push(managerEmail);} if (customerEmail1 != null) {ccArray.push(customerEmail1);} etc. Many Thanks that worked a treat.

Thanks for the replies, Danielmerekyan I really wanted to just remove the null fields from the array rather then loop through and send individual emails to each fields which are populated. These are essential CC addresses rather than the main TO address khultquist, tried that loop but it doesn't seem to make any changes to…

I managed to get it working by creating a hashtag array to get the values of the fields I needed from the secondary record, help documentation say it is optional but it seems it is required IF you use the optional secondary record fields, perhaps the documentation should be updated to show this??? Thanks for the help again…