Populate fields in record producer and update them in the table

[Kevin Paul]

I have a requirement to create a record producer to update the user table. When the record producer is opened, the person who is logged in, all his data from the user table are automatically populated in their related variables of the record producer, then the user can update the values and on submit , the existing record in the user tables gets updated without creating a new record. Can someone help me on this? On how to start?

[Ankur Bawiskar]

@Kevin Paul 

update as below

remove variables from every place

Script Include:

var user = {

"user_name" : gr.user_name.toString(),

"first_name": gr.first_name.toString(),

"last_name": gr.last_name.toString(),

"email": gr.email.toString(),

"mobile_phone" : gr.mobile_phone.toString(),

"company" : gr.company.toString(),

"title" : gr.title.toString(),

"manager": gr.manager.toString()

};

return JSON.stringify(user);

Regards
Ankur

[Kevin Paul]

It worked, can you tell why those changes were needed? and what was wrong with mine?

[Ankur Bawiskar]

@Kevin Paul 

gr.variables or gliderecord_object.variables is used to fetch variable values from RITM record

but here you are using query to sys_user table so that would cause the script not to work.

Let me know if I have answered your question.

Please mark my response as correct and helpful to benefit future readers.

Regards
Ankur

[Ankur Bawiskar]

@Kevin Paul 

Thanks for marking my response as helpful.

Please close the question as answered by marking my response as correct.

Regards
Ankur

[Kevin Paul]

I tried the same for asset table, where I get all the asset records of the logged in user and based on the no of records returned I returned some value to the client script. The client script uses the value to populate the variables of the record producer. But, whatever the value is returned from the script include is showing as null and the variable is not populating. Can You tell me what is wrong? I have attached the script