How to store the data in particular table.

praveen1231
Tera Contributor

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.

1 ACCEPTED SOLUTION

Shane J
Tera Guru

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:

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

View solution in original post

6 REPLIES 6

Danish Bhairag2
Tera Sage
Tera Sage

Hi @praveen1231 ,

 

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

 

Thanks,

Danish

@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

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

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