Populate Record producer variables with current user values

vaishali mahal1
Tera Contributor

Hello team,

i have record producer and i am able retrieve only userID.like this.

find_real_file.png

I have User[sys_user] table having details regarding this logged in user but i am not sure to retrieve that values and populate in record producer.

User[sys_user] will like this,

find_real_file.png

10 REPLIES 10

Harsh Vardhan
Giga Patron

either you can write glide ajax here to set the user details in your variable or you can pass the default value on your variables. 

 

sample:

to populate the employee number try with below line. same way you can populate the other field information. 

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

 

 

Hello Harshvardhan

i tried with  javascript:gs.getUser().getRecord().getValue('employee_number'); is not working.

can you add the screenshot please . where exactly have you added it 

Just for reference. 

 

 

Add it in default value field. 

 

find_real_file.png

 

now you can see in hiddens variable it has populated. 

 

find_real_file.png