3942099 Green Ribbon

If you are using FireFox 2 or Internet Explorer 7, you can make your own NetSuite browser search with an "OpenSearch" XML file. The concept is similar to Olivier's, but will use the browser's search bar to pass criteria to a NetSuite saved search URL. See this thread for more details:…

For CSV imports, the custom field name is used, not the ID. In javascript or web service, the ID is used. When naming your ID's, consider preceding the ID with a underscore. This is simply for readability since NetSuite will tack on "custitem" to the front of your ID. For example "_mycolors" becomes "custitem_mycolors"

Yes. Are you referring to a formula defined in a field itself or a formula in a search? Either way, the formula syntax for the field name would be preceded by "custrecord". For example: {custrecord_fieldname} Matt

It would be great if we could do something like that. I wanted to view the max creation date of tasks on the customer, but no such luck in the formula field for something like that. count() would be cool too. I used server script to populate the field instead. Perhaps you could have a server script look for that sys notes…

Perhaps you could also use nlapiGetUser() to authenticate by employee's internal id. This could be manageable if you only had a handful of users to whitelist.

I don't recall where exactly I found {id} or {internalid}. It was probably out of trial and error from trying to get something similar to work a while ago. Other fields that are visible on the form are easy to identify though. Turn on "Show Internal Id's" under Home > Set Preferences. Then go to the form with the field in…

How secure must this be? If one of these many roles has permission to create their own searches, then the form data could be easily be extracted by an adhoc search of the record.

You may need to use the concat function to build the string. concat(str1,str2) Try this: concat(concat('http://example.com/contracts/',{internalid}),'.pdf') Matt

{internalid}

No wait... on the form it looks like internalid is just {id}. In a search formula field, I use {internalid}. Matt

You mention the columns sub-tab... Is this a transaction form you are editing? Did you make sure to select an appropriate "applies to" option when creating the field? Or are the items in your list by any chance set to "inactive"? Inactive list items will not show up in the drop-down selection.

You could, as a custom workaround (unsupported by the api), disable buttons in edit mode by manipulating properties of HTML elements directly. See code for a similar example in this thread: https://usergroup.netsuite.com/users/showthread.php?t=1633 Matt

Yes. Ideally we'd like to track percent allocations for each transaction line item. Our legacy system currently does this. The NS "team selling" feature can accomplish this by specifying a percent contribution at the customer or transaction level, but not individual line. I'd estimate less than 3% of transactions are…

Issue 129523

Do you mean custom or customer records? ID is unique, but Name is not on custom records. You will have to query and check on save as Olivier suggests. Matt

From what you describe it would seem like you have created these fields on a custom record, not a customer record, is that correct? Do you happen to have any custom code running? While it is pretty general, that error is typical if you have an error hanging your code.

Is this running on new customer records (or existing customers without an address)? If so, try first inserting an address row using .insertLineItem() Then set the value in your row to US with .setLineItemValue(). I don't think you can manipulate just the value in the "address editor" portion of the screen.

Ok thanks, that's good to know. I do have a few sourced fields of different types, all are sourced from fields on the item record: check box (hidden, sourced from check box item record) single select (not stored, sourced from multi-select on item record) single select (hidden, sourced from single-select on item record)…

For the sync issues, I'm suspecting a sourced/filtered field in the row to be the cause. Something like this isn't working: for (var i = 1; i <= nlapiGetLineItemCount('item'); i++) { nlapiSelectLineItem('item',i); nlapiSetCurrentLineItemValue('item','amount',100+i, false, true); nlapiCommitLineItem('item'); } For a 3…

I use a similar method elsewhere... In sublists driven by saved searches, I will use formula-text search result fields to output HTML and render the link. Also in custom fields, I use an inline text field with formula that produces HTML.

Client side nlapiSetLineItemValue() seems to work fine on other fields, but does not work with amount. I've also tried in a server before load using nlapiSetLineItemValue() with no luck. And also tried in a before submit with .setLineItemValue() on the record object. Again this works with other fields, but not amount. I'd…

Ha! Custom records of states?... we do the same thing, for the same reason. I do have a working suitelet with several custom record fields that work, some with hundreds of values. However, now that I think of it, they are all multi-select. Are you populating your values with the source parameter in nlobjForm.addField()? My…

I believe you will need to replace 'customer' with 'entity' to attach to a customer record.

Not sure if this was a typo when you posted the code, but "SetFieldValue(...)" is incorrect. It should should be "nlapiSetFieldValue(...)"

If you can't search role records directly, perhaps you could try this: Create a custom record type with a list/record field of type role. Enter records and associate each with a role. Then search your custom record type and specify the role id you are looking up via the custom field. With the search results, add "_display"…

Glad it worked for you! I learned of _display while working with list and sublist objects. It is listed in help either under nlobjList or nlobjSubList. At some point during troubleshooting I applied it to search result objects. (thread here) You're right, the help doesn't seem to make reference to this trick with search…

You can use nlapiStringToDate to convert a NetSuite date field value to a javascript date object and do a comparison. You may want to use .setHours() method to clear out the hours/min/sec from the system date. var myDate = nlapiStringToDate( nlapiGetFieldValue('myDateField') ); var today = new Date();…

Interesting... you may have found combination that happens to work, but I don't think this should. The single pipe "|" is the bitwise operator for OR. For example, 2|3 = 3. In binary that looks like... 2 = 0010 3 = 0011 The bits overlap, so after an OR, you're left with 3 (0011) In an example where the bits don't overlap,…

It sounds like you're looking to make the fields mutually exclusive. You might give something like this a try: function myFieldChangedFunc(type, name) { if (name == 'yesFieldId') { if( nlapiGetFieldValue('yesFieldId') == 'T') { nlapiSetFieldValue('noFieldId','F',false); nlapiDisableField('noFieldId',true); } else {…

I agree. Disabling the fields is not needed to make the values mutually exclusive. This method would require 2 clicks (uncheck, then check) to change values. Based on the original request, it seems like Ravi was interested mostly in enabling/disabling of the UI (perhaps for other reasons not stated). Clearing values alone…