Set default value of a single line text variable from HR profile table

[Souvick A]

Hello All,

I have a requirement as below:

A single line text variable on a record producer. The default value of the variable should be a field value from the HR profile table of the subject person of the record producer. For example: the business title of the subject person.

Please help on fetching the default value code/process for this variable.

Thanks in Advance

Regards
Souvick

[Mike_R]

If it needs to be from the HR Profile table, then you'll need to create a script to do the lookup. Put that script in a script include and then call it from the default value field.

If it can just come from the sys_user table, you can try this

javascript:gs.getUser().getRecord().getValue('title');