When creating a newrecord, the system needsto verify for duplicates after filling thefollowing field

Nani16
Tera Contributor
"When creating a new record, the system needs to verify for duplicates after filling the following fields : Name, Year of applicability . The duplicate verification is done on 2 fields : Nani16_0-1719412950657.png - Name - Year of applicability Option 1 : If there is no match then the record can be created Option 2 : If there is a duplicate then - Display the following error message ""The service [Name] has already been created for the year [Year of applicability]. Please click on Continue to modify the ongoing service or on Next to open the existing Service Record."" If they click on Next to update the existing record, it discards (delete) the record they tried to create that was a duplicate."
1 REPLY 1

SAI VENKATESH
Tera Sage
Tera Sage

Hi @Nani16 

 

Is the Name or Service name is reference field right ?

 

Once this form is submitted will it store in any table ?

 

Thanks and Regards

Sai Venkatesh