November 2nd, 2014

Lost password?
Advanced Search

— Forum Scope —

— Match —

— Forum Options —

Minimum search word length is 3 characters - maximum search word length is 84 characters

The forums are currently locked and only available for read only access
sp_Feed Topic RSS sp_Related Related Topics sp_TopicIcon
One cell Formatter not executing after updating another cell?
Forum Posts: 7
Member Since:
sp_UserOfflineSmall Offline

I have formatters on visible cells that combine values on two or more hidden cells. I do editing in another area of the web page and pass the values to the grid's hidden cells using the setCell function. The formatters are not updating  the visible cells, although I thought that they were once doing so. I am not detecting any web page errors.

The formatters work when data is initially loaded. Since my editing also writes values into the database, re-running the web page will show my changes in the formatted cell. I don't want to reload the entire grid upon each data save, which is why I am attempting to change the grid cells as I save to the database.

This is my formatter function. I would like it to execute if I change the grid cells that contain values such as sAlertType, sNotifyTrigger, IUnits, etc. I've tried pasting as text and word, but both do not show well in this post. Text loses indents. Word loses linewraps.

function triggerFormatter(cellvalue, options, rowObject) {

var value = '';

var date;

switch (rowObject.sAlertType) {

case 'N':

value += 'Change in ';

value += rowObject.sNotifyTrigger;


case 'SR':

case 'PR':

case 'R':

value += rowObject.IUnits;

value += ' ';

value += rowObject.sUnitOfMeasure;

value += '(s) ';

if (rowObject.sTimeRelation == '-')

value += 'prior to ';


value += 'after ';

if ((typeof (rowObject.sNotifyTrigger) != 'undefined') && rowObject.sNotifyTrigger != null) {

value += rowObject.sNotifyTrigger;


value += ' (';

try {

if (eval('rowObject.' + rowObject.sNotifyType)) {

date = new Date(parseInt(eval('rowObject.' + rowObject.sNotifyType + '.substr(6)')));

value += $.datepicker.formatDate('mm/dd/yy', date);



value += '[blank]';


catch (e) {

if (typeof (rowObject.sNotifyType) != 'undefined') {

if (rowObject.sNotifyType != '')

value += '[' + rowObject.sNotifyType + ']';



value += ')';


case 'W':

value += 'Watch folder ';

if (rowObject.sInherit == 'Subs')

value += '(including subs) ';



value += 'N/A';



return value;


Forum Timezone: Europe/Sofia

Most Users Ever Online: 496

Currently Online:
18 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

OlegK: 1255

markw65: 179

kobruleht: 144

phicarre: 132

YamilBracho: 124

Renso: 118

Member Stats:

Guest Posters: 447

Members: 11373

Moderators: 2

Admins: 1

Forum Stats:

Groups: 1

Forums: 8

Topics: 10592

Posts: 31289

Newest Members:

, razia, Prankie, psky, praveen neelam,

Moderators: tony: 7721, Rumen[Trirand]: 81

Administrators: admin: 66

Comments are closed.
Privacy Policy   Terms and Conditions   Contact Information