Portfolio does not populate onto the Idea form - Record Producer

[Vaishnavi35]

Hi,

I have created a Record Producer with "select box" variable. I have added choices manually.

On the "Idea" form we have "Portfolio" field. Its a reference field.

Whatever value I am giving on the Record producer I want it to go on the Idea form.

current.portfolio = producer.portfolio; - this script does not work on the RP record

"Map field" is also not working.

Thanks,

Vaishnavi

[Rakesh41]

@Vaishnavi35 ,

Please try to pass the sys_id of the portfolio's from your record producer.

[AshishKM · Accepted solution]

Hi @Vaishnavi35 , 

As per all details given here, it looks that the local select box value ( from question_choice ) table are mapped with portfolio field on Idea table which is giving this overall issue becuase selec box value's has different sys_id than Profile [ pm_profile ] tabe.

Workarround :

You can write gliderecord query over pm_profile table and get the profile record sys_id based on selected profile on record producer using the below code.

current.portfolio = getPortfolio(producer.u_portfolio);

// Funtion to  return selected portfolio record's sys_id
function getPortfolio(protf){
 var grPorfolio = new GlideRecord("pm_portfolio");
     grPorfolio.addQuery("name", portf );
     grPorfolio.query();
     if(grPorfolio.next()){
       return grPorfolio.sys_id;
     } // if closed
} // function closed

-Thanks,
AshishKM