Store value other than the display value

[raed1]

Hey guys,

Is there a way to display and store the value on a reference field other than the display value of the table it is referencing? I am currently dynamically trying to populate the Step field, based on the Job Title selection, however I want the 'Step' reference field to display the u_step field on the table instead of the name id (which is set as the display field).

This what I have on the form:

This is my script include that I am calling as reference qualifier on the step dictionary item:

var ChangeStep = Class.create();
ChangeStep.prototype = {
       initialize: function() {
       },
   changeOptions : function() {
             var stepList = ' ';
             var jt = current.u_job_title;
             var sl = new GlideRecord('profiles');
             sl.addQuery('u_udc','position');
             if(jt) {
                       sl.addQuery('uc_code',jt.u_it_code);
             }
             sl.query();
             while(sl.next()) {
                       if (stepList.length > 0) {
                                 stepList += (',' + sl.u_step);
                       }
                       else {
                                 stepList = sl.u_step;
                       }
             },
   return 'u_stepIN' + stepList;
   },
         type: 'ChangeStep'
};

Thanks,

Raed

[raed1]

Hello Dennis,

Thank you for your reply. That is exactly what I want. I tried to do what you suggested, however, I am still seeing the display value of the nameID instead of the u_step.

On lookup:

On selection:

[Harsh Vardhan]

have you made the u_step coulmn display "true". go to the table and mark display true for this

[raed1]

Hello Harsh,

I already have the NameID set as the display value. This reference field is being used in other forms as well, so I only want this to be changed across this particular form and not the other ones I have.

[Harsh Vardhan]

is it ok if you create another field on form. when ever you will select nameid based on that step will populate in another field. via dot walking.

[leemey]

Dear Raed,

I am facing the same issue as you, have resolved this problem now?

Thanks,

Leemey