- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-04-2024 10:24 AM - edited 06-05-2024 04:54 AM
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.
Thanks,
Vaishnavi
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-05-2024 10:15 AM
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
Please mark this response as correct and helpful if it helps you can mark more that one reply as accepted solution
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-05-2024 04:11 AM
@Vaishnavi35 ,
Please try to pass the sys_id of the portfolio's from your record producer.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-05-2024 10:15 AM
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
Please mark this response as correct and helpful if it helps you can mark more that one reply as accepted solution