Show asset based on a variable value

[ServNowDev]

I have a variable value name Trip Type, choices would be work or personal

I have a variable in a variable set named Select Asset that is referenced to the alm_asset table.

Depending on the Trip Type i was to show certian assets in that lookup table

so if Trip Type == Work , I want all asset from the Stockroom that are unassigned

but if the Trip Type is Personal , I want all the assets currently assigned to the user to show in the select box

is it possible to code out in the Reference Qual 

[James Chun]

Hi @ServNowDev,

Yes, you can use the Reference Qualifier in a variable within a variable set.

e.g. javascript:"type=" + current.variables.trip_type;

Cheers

[ServNowDev]

Thanks for the reply, but wouldnt there be other steps to tell which assets to show , based on the type, would i need more code to write??

[James Chun]

Oh, I thought you already had the 'Trip type' column in the Asset table. Are you saying there is nothing to map the 'Trip type' to assets?

[ServNowDev]

correct i have nothing to mapp to the trip type in the asset table just if its type work, pull assets in the table that are in the location stockroom, and if type personal, pull only assets that are assigned to the current user.