App Engine Table Question

[Brian Sorensen]

I have a custom table with a simple App we have called New Hires

On the table I have a field called Position ID

In here our team enters the Position ID tied to a new hire.

On my ALM_hardware table I have a similar field, what I want to do is have the Workday Position ID column look at the record in in the ALM_table and post the model of computer we have for that role.

Above is the example of the App Engine table

This is the properties

Any idea how I configure this?

Essentially if someone enters the ID P017254, the Available asset would return the Model value below

Assuming there is something in here I need to code?

[Brian Sorensen]

I think this is right, but maybe I missed a step?
We are going to go with Display Name in the field for the asset
here is what I have

System > Business Rule

(function executeRule(current, previous /*null when async*/) {

// Add your code here

var gr = new GlideRecord("alm_hardware");

gr.addQuery("MLSE Position ID", current.workday_position_id);

gr.query();

if (gr.next()) {

current.available_asset = gr.display_name;

}

})(current, previous);

When I look at the table I see this

I know a few don't have an asset, but P529090 does

I'll recheck for typos

[Danish Bhairag2]

Hi @Brian Sorensen ,

U wish to populate model display name correct?

if yes then do something like this

current.available_asset = gr.model.getDisplayValue();

Thanks,

Danish

[Brian Sorensen]

Yes that is what I want to do.

So if I add your line in replace of 

current.available_asset = gr.display_name;

?

Will try