Catalog client script to compare values with table

Andyj00
Tera Contributor

‎02-06-2024 12:42 PM

I have a record producer that has fields submitter (reference), nominee (reference), and created on (date). They are entered to their respective fields on a table.

I want to create a rule that if within the past month the same submitter has nominated the same nominee then an error message will occur and now allow a submission.

I've tried to do this with a catalog onSubmit client script and have had no success.

See below:

Andyj00_0-1707252060096.png

Any help is appreciated thank you.

 

0 Helpfuls
  • 362 Views
1 REPLY 1

Dr Atul G- LNG
Tera Patron
Tera Patron

‎02-07-2024 03:49 AM

Hi @Andyj00 

Did you try with UI Policy

 

I tried to build something on change tabel

 

LearnNGrowAtul_0-1707306523645.png

 

 

Give a try on your parameters. and if it match show error in Script

LearnNGrowAtul_1-1707306559311.png

 

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************
0 Helpfuls