Populate fields in record producer and update them in the table

Kevin Paul · ‎10-09-2020

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?

Vamshi dhar · ‎10-09-2020

Hi Kevin,

Please follow the below steps, your requirement will be fulfilled:

1. First, create a record producer and create all the necessary variables in the record producer.

2. Create an onload script, to update all the logged-in user details in the Record Producer.

3. Write Record Producer script, such that first if should query the User table to check the record exists for the Logged-in user or not. If exist simply update the fields what he has updated in Record producer, If the record doesn't exist then simply create a record in User Table.

Please Feel free, to ping me if you stuck somewhere.

Please mark it as Correct/Helpful if it fulfills your requirement

Thanks

Vamshidhar

View solution in original post

David Whaley · ‎11-12-2021

Hi Kevin,

I realize this is about a year old and a solution is marked but I would like to offer another solution for anyone else that may have this requirement as this thread is one of the first I looked at while trying to solution a recent requirement I had.

While there is a solution from @Ankur Bawiskar feel that a record producer is a proper solution. I did not feel the need to generate a request/requested item just to update a record in a table and started looking at import tables. You probably already have a data source and transform map created for your User table.

Get the import table name from the import or create a new data source to the user table.
Once you have the table name or the table has been created from a test import navigate to System Definition -> Tables
Search for the table name and click the table record.
Under related links for the import table there is a link to "Add to Service Catalog"
Click "Add to Service Catalog" link.
A new window will show up and this is where you start building the Record Producer, You give it a name, short description and can add to to a category in your service catalog. The fields you select from the import table will automatically be created as variables
Click "Save and Open" and your record producer will appear for you to finish creating.
Now all you would need to do is create the OnLoad client script to populate the logged in user data from the User table. When the item is submitted the updates go into the import table and the transform map will take over.

Opening import tables to record producers is a very nice way to get data and updates into tables from your users and reusing items you may have already created.

If you have any questions please let me know.

David Whaley