Catalog item records insertion

[Rahul84]

Hi @Ankur Bawiskar /team

I have another requirement as - I need to create a catalog item which consists of 3-4 fields like manager name , employee name , address and email

Upon submission I need to create a task for one of the group to review the request.

Once any member from this group reviewed the request and closed it. I need to insert this data into a particular table "u_abc".

if the records already exists in the table "u_abc" then we need to skip this catalog request data.

## I am cleared till catalog item creation and task creation for one of the group via workflow.

But how we can have this below requirement fulfilled 

Once any member from this group reviewed the request and closed it. I need to insert this data into a particular table "u_abc".

if the records already exists in the table "u_abc" then we need to skip this catalog request data.

Thanks !

[Ankur Bawiskar]

Hi,

you want to skip the record? what it means?

Regards
Ankur

[Rahul84]

like when user submits the request using catalog item . If the data already exists in the table in which we are inserting the data , then we do not need to re-enter the same data, like we are skipping the insertion operation.

also we have one field on catalog form as list_collector in which we can select multiple values

if we have 4 values selected in this field and 3 are already there in the target table , then we need to insert only one left value in the table..

I have re-phrased my asked query.

-----------------------*****************----------------------

I have another requirement as - I need to create a catalog item which consists of 3-4 fields like name , table names (list collector) , address and email out of these fields one field is a list collector and can have multiple values

Upon submission I need to create a task for one of the group to review the request.

Once any member from this group reviewed the request and closed it. I need to insert the catalog request submission data into a particular table "u_abc".

if the table names (list collector) field values already exists in the table "u_abc" then we do not need to insert the data in the table.

## I am cleared till catalog item creation and task creation for one of the group via workflow.

But how we can have this below requirement fulfilled 

Once any member from this group reviewed the request and closed it. I need to insert this data into a particular table "u_abc".

if the table names (list collector) field values already exists in the table "u_abc" then we do not need to insert the data in the table.

Thanks !

-----------------------***************------------------------------

Can you pls suggest the approach and logic for this 

[Rahul84]

Hi @Ankur Bawiskar ,

Can you pls reply and help to achieve this requirement.

If possible pls provide a sample script logic to achieve this.

Thanks

[Rahul84]

Hi Team,

Can anyone help me on the asked requirement..

Thanks