Need to pull a value from the Opened For's HR Profile

[Rylie Markle]

I want to add a value from the Opened For's HR Profile to a tab on the case form. When I go to add fields, it only gives me access to the Subject Person's HR Profile. Is there a way I can make a field with this information? Or do I only have access to pull from the Opened For/By's User Profile?

[Manmohan K]

@Rylie Markle 

Can you tell the value you want to set in u_donator_current_top_balance field needs to come from which field on which table. Basically explain your requirement 

[Rylie Markle]

@Manmohan K The value I want to set in 'u_donator_current_top_balance' is a field called 'top_available' on the HR Profile table. 

[Rylie Markle]

@Manmohan K sorry, its called "u_top_available"

[Manmohan K]

@Rylie Markle 

You have to modify client script to add GlideAjax to call script include 

You have to write a client callable script include and pass user id of opened_for user

Then you have to query the HR profile table and return the u_top_available value from script include to client script

[Rylie Markle]

@Shaikh Mzhar Hi Mzhar. In your code where you say "replace <hr_profile_field>.." should that be the name of the field I created? 

I created a new field to store the Opened For's HR Profile on the case table called "u_opened_for_hr_profile".