Eh, it only took a few minutes. It would have been quicker if I knew jQuery better. Check out this jsFiddle for a demo and code. You'll need to create an inline HTML field and add this HTML to it to get jQuery: [PHP] <script type='text/javascript'…

We don't use a web store, so that would be outside my knowledge.

I assume the plug-in you're referring to is the official one NetSuite provides. That plug-in is used primarily to upload SuiteScript (JavaScript or .js) files to your file cabinet. There is a thread here in the forums discussing how to remove the built-in filter so you can upload files with other extensions, but I don't…

Thanks. We might be looking into this. We don't use the NS website for our customers. I wonder if this would be as easy to install into, say a DNN site?

We are testing Olark and so far it is really cool. I would like to know more about that. Can you point me to some docs, screenshots, etc?

Check out the Celigo File Explorer. http://celigo.com/products/netsuite/file-explorer/ Well, you learn something every day, it seems. I can't believe I didn't know about this. It would have made my life much easier a couple months ago.

I was thinking about creating a custom record based on Products, calling it Classes and attaching it to the Contact record. I am not so much concerned with the billing aspect of this (as this is a one time purchase) as I am the tracking and registering. I am really just trying to replicate a process we use in Epicore's…

Sweet. Thanks.

Does my company have to be a partner to get access to that reference (com.netledger.forpartners.sso)?

Worked like a charm. Thanks.

Alternatively, you could use SuiteTalk to post the values to a custom record which you use as a work queue and call a SuiteScript function on create to join these together. Which function do you use to attach an issue to a case in script?

You first need to create a static group of type contact either in WS or the UI, then use the attach operation to associate contact members to the group. Can you give a quick code example if this? The wording in the help file is a little confusing to me: Group Note: Although you cannot currently attach Contact records to…

Hello, There is currently an enhancement request for this ability via Web Services and via the UI. Please feel free to vote for these enhancements via the NetSuite support center. Thank you. Enhancement 82642: WS - Make createdDate and endDate settable on Support Case record. Enhancement 155364: List > Support > Cases --…

Two votes on that issue, Elham. Why is it all the enhancements our company needs/wants have so few votes? We must be bleeding edgers :)

This problem could have been solved by exposing default elements like type and priority to the system notes. I could have done: decode({systemnotes.field}, {priority}, decode({systemnotes.type}, 'Set', {systemnotes.newvaue})) to find the original priority. I am going to have to create yet another custom field to hold this…

Ok, still have a problem. I am trying to group on priority and type and then I have a formula to give an average of the response time (using a date/time field). Running the search now gives no results. Unless I group by number as well, which I don't want.

How do you do a summary criteria?

What did I say yesterday? Always the dumb S#%$. Now I feel stupid. Thanks once again Even. You're the man. See you next week :)

I was afraid you were going to say that. I will keep plugging away.

Weird. Works: to_date({systemnotes.newvalue}, 'MM/DD/YYYY HH24:MI:SS') Doesn't Work: to_date({systemnotes.newvalue}, 'MM/DD/YYYY' ) I just rebuilt one of my old searches with the above. Hacks it is. I was thinking substr would work but felt wrong, funnily enough.

My search has criteria for both the field not being empty and for the system notes field to be the custom field and, in fact, I have a criteria for one record. Formula (Date/Time) to_date({systemnotes.newvalue}, 'MM/DD/YYYY HH24:MM:SS') gives error

Try TO_TIMESTAMP for setting time zones. Check the first page of my other post on datetime:

Have you tried just this: to_date({systemnotes.newvalue}, 'MM/DD/YYYY')

Formula (text) {systemnotes.newvalue} Gives: 04/01/2013 09:34:58 Using this: Formula (Date/Time) to_date({systemnotes.newvalue}, 'MM/DD/YYYY HH24:MM:SS') Gives this: ERROR: Invalid Expression

Oh FFS. It's always the dumb S#$%. I had MM for minutes instead of MI. Also, when I had been MI in my previous posts I was trying HH instead of HH24. It's working now. I have literally been messing with this off and on for a week. Thanks Evan.

Many time many different ways to_date returns an error every time. Evan, my case number is 1676039 if you'd like to look at it. The problem I am having is that I am unable to parse out the string value the system notes has into a format that will convert to date that I can then check against the custom date/time field. For…

I am pretty sure there has to be a way to convert this string into a date form; I just haven't figured it out yet. I don't want to add yet another custom field. I have opened a support ticket. I will post back what they say.

All of our east coast support reps are skewing our response time data because of this. We found out what is causing it and now I am trying to fix the data but converting the system notes string is my stumbling block.

I would be interested in seeing someone's implementation as well. I assume it's like ExtJS and that you can just call on the library functions. Caveat being that they can switch at any time and leave you with dead code. If you were clever enough, I bet you could build out an application using the new SuiuteScript Server…

I don't think you can in a report or a saved search. If we had access loops in a formula you could at least account for weekends and those holidays like Thanksgiving that fell on predictable days. We have a business policy here that new cases are always responded to before day end. That way we can just use <720 as the…