How to store the data in particular table.

praveen1231 · ‎10-10-2023

Hello everyone, my requirement is, I had created a table called u_table_record with column label (u_user, u_name, u_email).

And also created catalog item(Demo Table) with variable User, Name, Email. When I submit the catalog item these data are mapped to to u_table_record. Please let me know if you have any idea regarding this. Thank You.

Shane J · ‎10-10-2023

Depends on if you're using Flow (I think there's a create new Record Activity) or Workflow (probably a Script activity, using GlideRecord), but since you're using a Catalog Item you'll need to use the appropriate mechanism to:

Create a record in your new table
Populate that record with the values from your variables

View solution in original post

Danish Bhairag2 · ‎10-10-2023

Hi @praveen1231 ,

May I know any specific reason for creating a Catalog item instead of Record Producer?

Thanks,

Danish

praveen1231 · ‎10-10-2023

@Danish Bhairag2 Sorry there is not any specific reason for that. It's my requirement that's all. If you had any idea please share it to me. Thank you

Danish Bhairag2 · ‎10-10-2023

Hi @praveen1231 ,

The reason for asking the question was if there is no such requirement then instead of Catalog Item you can create a Record producer & create those 3 fields in it the same way u created it in catalog Item.

One advantage of using record producer would be you can directly map your record producer to your custom table.
Also the variables which u create u can map directly while them to the table fields.
so whenever the record producer is submitted ,On submission it will automatically map the values for User, email & Name in the respective tables columns.
Please try this out & let me know if it work for you or not.

Mark my answer as helpful & accepted if it helps you resolve your requirement.

Thanks,

Danish

praveen1231 · ‎10-10-2023

@Danish Bhairag2 Thank you for your help. But My requirement is to work on catalog item.