Recent Problems with onChange events...urgent help needed

[clankford]

Hello all,

In short, I have recently ran into an issue where the below code does not seem to trigger when assigned to an onChange event on another field

When I put this exact code into a button or trigger based on any other means than onChange it works fine, but when I put into onChange event it does not fire.

Again, the objective is to have the fields listed below get updated with user information anytime this other field is updated. I really feel it has something to do with latest build because this exact code is still working in production apps that I have not published any updates over the last couple months.


**Please help as this is the last stage of a significant update I'm trying to roll out in coming days but need to get past this.



var name = {grid.Object}.__currentUserName;
var d1 = new Date();
d1 = d1.toFormat('MM/dd/yyyy 0h:0m:0s am');
var name_stamp = name + ' ' + d1;

{grid.object}.setValue('G', 'aStatusChangeUserID', {grid.RowNumber}, name);
{grid.object}.setValue('G', 'aStatusChangeTimestamp', {grid.RowNumber}, d1);
{grid.object}.setValue('G', 'aStatusChangeSignature', {grid.RowNumber}, name_stamp);


Thank you, Casey

[lgrupido]

Re: Recent Problems with onChange events...urgent help needed

What type of control is it not working in? Is it all controls? (Because I have things in on-change on the current version that are working fine.)

[clankford]

Re: Recent Problems with onChange events...urgent help needed

It is a text box within a grid.

And yes, I have previous grids that used on change with no problems, but if I pull up in the most current build and try to preview or publish the same onChange does not work now....

Are you on the most current build? If so, try to preview it as a live preview within Alpha dev software and see if still works??

Let me know.

Thanks

[Davidk]

Re: Recent Problems with onChange events...urgent help needed

What build are you using? What was your previous build? What type of Control do you have the onChange event set? Have you read the onChange notes?

If you tab out of the control you're in (where this code is set for the onChange event) then the code fires and your other fields are updated.
If you click out into another row then the grid doesn't really know where you are... and can't update. It's a timing thing. For a UX it's not that big a deal, unless you're working with a Repeating Section. For a Grid, you're dependent upon the row.

You could put your code into the onKeyDown event. You're code will run more often... but... it's client-side so you won't feel a thing... and your Status fields will get updated.

The notes for onChange talk about setTimeout. Try the suggestion of {noSetTimeout}... as in...

{noSetTimeout}
var name = {grid.Object}.__currentUserName;
var d1 = new Date();
d1 = d1.toFormat('MM/dd/yyyy 0h:0m:0s am');
var name_stamp = name + ' ' + d1;
{grid.object}.setValue('G', 'aStatusChangeUserID', {grid.RowNumber}, name);
{grid.object}.setValue('G', 'aStatusChangeTimestamp', {grid.RowNumber}, d1);
{grid.object}.setValue('G', 'aStatusChangeSignature', {grid.RowNumber}, name_stamp);

This will give you back the older behaviour.

[clankford]

Re: Recent Problems with onChange events...urgent help needed

Thanks David. I tried to insert the noSetTimeout but was not sure exactly where to put it. I will try when I get back to my PC for sure.

What i have always been able to accomplish was using as sort of a trigger. When a user changes the value in one field it actually updates adjacent fields with tracking like info.

Like I said this code always worked in previous builds but now doing this.

What sort of has be leaning towards a bug is that there is a grid that I made changes to other non related fields however a user the other day mentioned it was behaving differently (not updating additional fields based on onChange. At the time was puzzling because I never touched the code, now I realized because I republished the grid because of something else now did not work with current build??

Again, I'm definitely going to try the noTimeOut code at top of code and see. I really hope this makes it behave as before....

Thanks again!

-Casey

[clankford]

Re: Recent Problems with onChange events...urgent help needed

Just tried and did not work....

So strange because the same code works on onKeyPress, onBlur, onSelect, etc......the problem is that for the functionality needed I truly need this javascript to be triggered by onChange....

Any additional ideas welcome...

Thanks again David,,

-Casey

[clankford]

Re: Recent Problems with onChange events...urgent help needed

Sorry, forgot to mention in my last post. I'm on Version 12.4.3.2, Build 4119.....System addins - Build 4825

[Davidk]

Re: Recent Problems with onChange events...urgent help needed

This works for me under 4119. I added fields to my table to match your status fields... and... with the {noSetTimeout} in place, the fields are updated by the onChange event code as soon as I leave the Textbox control I've attached the code to... no matter how I leave that control. There must be something else going on with your Grid... or your process. The onKey events are essentially "change" events. What's special about the onChange event that it must be used. Any Javascript errors generated?

[clankford]

Re: Recent Problems with onChange events...urgent help needed

Thank you David for taking the time on this on a Friday night :), I truly appreciate it

Wow, interesting. Well, we are getting somewhere then....

I still think there is a problem with my {noSetTimeout} code because the text color stays black, as if there is something wrong with it....is that normal?

Attached is a screenshot of how I have it nested in the onChange coding...

Screenshot_031017.doc

[Davidk]

Re: Recent Problems with onChange events...urgent help needed

It's just code that's being interpreted by Alpha... they're testing for {noSetTimeout}.

If you click into another control on the same row... the code doesn't fire? If you put an alert('test'); in your code... you don't get the alert?

[clankford]

Re: Recent Problems with onChange events...urgent help needed

Yes, I tried the alert code and it brings back alert fine...

I was also thinking it must have been something with grid to I created a brand new grid with same coding and just cannot seem to update other fields based on the change of the "source" field....

Like I said, so odd that I use this "triggering" accross many apps and historically have always, and still do, it is just now when I try to implement in this new build getting this issue.

The fact that yours works is even stranger.....

So you are putting in same location as "text" code?

No errors.

[Davidk]

Re: Recent Problems with onChange events...urgent help needed

So you are putting in same location as "text" code?

Not sure what this means... could you explain?

You'd have to post the Grid and a sample table dump with a few records. Otherwise it's all just guessing.

[clankford]

Re: Recent Problems with onChange events...urgent help needed

I hear you David. My apologies. It is definitely hard to describe in words my issue....

I will try to prepare something tomorrow to post.

In the meantime Would you maybe be able to provide a screenshot of where exactly you are placing this same code that is working for you?

[Davidk]

Re: Recent Problems with onChange events...urgent help needed

Sure, but I'm not sure why that might help. onChange event of a Textbox Control. It really feels like there is some missing information here.

GridOnChange.PNG

[clankford]

Re: Recent Problems with onChange events...urgent help needed

Thanks David, honestly I'm intentially taking this approach because I actually recreated a brand new grid from scratch with no other coding and just these fields and still experienced the same issue.

If possible can you forward your grid complement that is working and let me try to import into my project and see if I still have the issue?

Thanks again.