Prevent Duplicate Records
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-30-2023 03:09 AM
Hi All,
Kindly, help with your inputs for below requirements.
Catalog Item Variables:
1. Groups
2. Modules: Aa and Bb (only 2 choices)
This is creating a record on Table: (Table Name = Demo)
Field on a Table:
1. Module (Reference)
Condition: Once 'Aa' is selected on a catalog form, it will map to Module field on a table with "Post 1" value.
if "Bb" selected on catalog form, it will map "Post 2" value on table. (This is done using flow designer)
Requirement:
If there are existing records on table with group name = ABC and Modules = Aa and Bb, then it should not allow to create another record.
i.e., if there are already records created as below then it should give error msg.
If there Record is created with only 1 Module (i.e. Aa) then it will allow to create another one with module Bb.
E.g.,
1st Record
Catalog Form Variable:
- Group = ABC
- Module = Aa
Record created on a table with below field:
- Module = Post1
2nd Record
Catalog Form Variable:
- Group = ABC
- Module = Bb
Record created on a table with below field:
- Module = Post2
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-01-2023 01:41 AM
Hi @Sandeep Rajput ,
Thanks for your inputs.
I have written Script Include and Client Script, but it shows that there is an error in JavaScript.
Script Include:
Catalog Client Script:
Error:
"There is JavaScript Error in Browser Console."
Can you please help in this?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-01-2023 01:53 AM
@Rakshanda Kunte Could you please check the browser console when the error appears and share the detailed logs here?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-01-2023 02:33 AM
Hi @Sandeep Rajput ,
The record is created and submitted but it shows below error and script include is not returning any value.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-01-2023 02:47 AM
@Rakshanda Kunte I have sent you a message, please check.