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?

[Kevin Paul]

what do you think about using default values? using the glideuser api like 

javascript:gs.getUser().getMobileNumber();

[Vamshi dhar]

No, Kevin, I don't think it's the best one. Instead of that write one Client script, it will update all the necessary variables of the Logged-in user.

Can you tell is it in the Portal view or Record Producer view. So that i can provide sample code snippet to you

Thanks

Vamshidhar

[Kevin Paul]

portal view

[Vamshi dhar]

Great!!! go for Glide Ajax and Script include to populate Logged-in User details in Record Producer. After that write a producer script either to update or insert a record. 

Let me know if you need anything!!!

[Kevin Paul]

Hi vamshi,

I have created the record producer and the script include and client script. Since i want multiple values, i used json to pass the values to the client script. The problem is, when i try the item, the variables are getting auto-populated with the value "undefined". What should i change? I will add the scripts here. Kindly respond