Hi,
I was wondering how if may be possible to update the current cell in a grid based on what the user typed. Let's say I wanted to convert '123' to '000123'.
In a dynamic action based on a standard page item, this could be a SetValue action, using a PL/SQL LPAD expression, suppressing the change event as to avoid an infinite loop.
With IG, a SetValue action can be used to set another column. But if the suppress change event is set, then the new value doesn't even get applied.
So if a SetValue action is set to the current cell, it will either not update, or it will constantly trigger itself over & over.
It appears possible to safely update the triggering cell using the JavaScript described in this post. ie, a change event on JOB could ultimately run the following
model.setValue(record,"JOB",'Astronaut');
But how could I source this value from PL/SQL?