3944986 Green Ribbon

Take a look at Epiphany, Inc. eCalendar if you need to view multiple users calendars at a glance. The new version looks pretty good, although it is in beta right now. Displays calendars in a graphical format and allows you to create groups and set color codes for categories.

There are several ways to accomplish this depending on your data fields. A simple formula for date calculation would be something like this in search results add field formula numeric. for the formula use something like this round({statusdatefield}-{today},0).

Not sure about the "more" question. But if you wanted to just display 15 characters you could use SUBSTR({messages.message}, 0,15) in a formula field

That should be possible with the new workflow manager.

If you are joining to transaction I think you would need to set mainline=no and look for item on any line.

I'm not sure if this will work but maybe something like this... case when (condition 1 and cond 2 and cond 3) then case when A then $xxx when B then $xx when C then $xx else $0m end end

Couldn't you use the contact internal id as a field on the criteria. Contact : Internal Id (Number) is not empty

You could probably use a simple pageinit script. Something like this. var newFormID = 100; //replace with the correct form number var formID = nlapiGetFieldValue('customform'); //get value of current form if (formID != newFormID) nlapiSetFieldValue('customform', newFormID); //replace form if ID is not the correct one

For transaction column fields it may be easier to do this using client-side SuiteScript than using a formula. A validate-line or item/quantity field on-change function that sets this custom field based on the values in the transaction line might be better suited. Issues #1 & #2 are resolved right away and #3 could be…

(JMU) I initially tried the approach you listed in steps 1-3 but had the following issues. 1. Sales order form comes back with "ERROR:Field not found" for the itemmultiplier. 2. There is no inline option available for a custom column field like there is with standard fields.

Do you really mean column tab? There is no tax box there. It is under the footer tab.

Thank you, not quite what I'm looking for as that would require us to edit all customer records. If anyone has a solution that allows me to concatenate the fields on the PDF form I'm still interested.

I logged a case yesterday. Number is 581923. I can setup a webex meeting to review the issue. Note that the tech that responded did not understand my issue clearly and thought that I was trying to type text in a number field. I need to get this resolved ASAP so any assistance would be appreciated. 650-428-1866 x202

There is a post somewhere that details this. You use custom elements that concatenate the address and the phone #, and use them to replace the existing address elements. But you will need to get that custom field working. If it is not showing phone #s then there's something wrong with the setup. There may be a missing step…

Unfortunately, most of these are client event scripts.

Using nlapiGetFieldValues will create an array of the multi-select list. With that you can loop through the values to check if there is a match found. Something like this... var seatList = new Array(); seatList = nlapiGetFieldValues('custbody_seatid_attachment'); if (seatList != null) var seatListLength = seatList.length;…

Maybe something like this would work. This assumes you have an existing saved search that you want to use and that it loops through each item in the search results and sends an email. I didn't test this just copied/pasted bits of code I've used in the past. function emailSearchContacts() { var authorID = 64; //netsuite…

When I've had scripts that needed optimization I usually put a couple of line to get script usage at key points in the code so that I can focus on the really heavy script usage areas. Something like this at the beginning and end of a for loop. var context = nlapiGetContext(); var usageRemaining =…

I think that depends somewhat on your workflow. When I use them I usually either do User Event or Scheduled. If I do scheduled my saved search usually has a date filter for TODAY. Feel free to PM me and we can discuss in more detail offline if you want.

There are probably a couple of ways of doing this you should decide on when you want it updated like after an invoice or cash sale is saved or when the customer is saved. But you could create a saved search that summarizes the values you want to total like invoice amount and cash sale amount. Then call that search in a…

I am not sure if this is what you are looking for but I did something similar a while back. var endTime_S = nlapiGetFieldValue('custrecord_endtime'); var tempendTime_D = nlapiStringToDate(endTime_S); var endHour = tempendTime_D.getHours(); var endMinute = tempendTime_D.getMinutes(); if (endHour == 0) { endHour = 12;…

Here is one that I've used. var filters = new Array(); filters[0] = new nlobjSearchFilter('custrecord_field1', null, 'is', checkLocation); filters[1] = new nlobjSearchFilter('custrecord_field2', null, 'is', checkClass); filters[2] = new nlobjSearchFilter('custrecord_field3', null, 'is', checkBook); var orderRecords =…

Thanks, I had just found that.

I have used something like this in the past. startDate = new Date(); endDate = nlapiAddDays(startDate,42) endDateString = nlapiDateToString(endDate);

I think you need to use the internal id. For example, I have a search whose id is customsearch1440, the internal id for this search is 1440.

Nevermind...with more looking at my code, I found a typo...problem resolved.

I am also having trouble with this. Here is my scenario. 1. Create a custom record. (custrecord_support_crew) 2. With a script, a calendar event record is created which would be associated with the newly created custom record. (linking field is custrecord_support_event) 3. The custom record would now be a sublist in the…

If I used a script like the one you have here and I wanted to update a field on the contact record as part of the script...what might that piece of code look like. For example say I have a custom checkbox field for active customer. How might I update that field as part of the script.

I have a script that does something similat but not using the same call as you. Mine is reducing taxamout by 50% instead of changing the taxcode. Here is the function I am using. nlapiSetCurrentLineItemValue('item', 'taxrate1', calcTaxRate);

So do you mean it should look something like this? var calcTaxRate = parseFloat(lineTax) / 2; calcTaxRate = Math.round(calcTaxRate*100)/100; calcTaxRate = calcTaxRate + '%';