Is it Possible to Use Custom Script for Sql Query?

Hi Guys!

Is it Possible to on Custom Script to use Sql Query?

I want to avoid existing data entry and once it’s already exist it trigger pop up message that this record already exist.


Instead identify a field that MUST be unique all the times. Simply set that field as Unique via Customize Form (if it is a default document) or Edit Doctype (if it is a custom doctype in a custom app).

yes this is a unique field name.

I have field name type which is I consider as a table. This type have 3 selection as dropdown:

  1. A
  2. B
  3. C

and Payment Start, Due Date

For payment Start and Due Date I Consider as datetime for this.