Zoho Creator Import Excel file with the unique value generating in the form

Zoho Creator Import Excel file with the unique value generating in the form

I am trying to avoid the duplication of records imported from the Excel file.

What I did:

Created a field with "No Duplicate Values" which is generated by combining values from 3 different fields.
input.Unique_Value = input.Patient_ID + input.DOS + input.Patient_Last_Name;
This script was added to : Form - On Add -On Success, Form - On Edit - On Success, Field (Unique_Value) - On User Input and On Update.

I guess, with the current implementation of the data import in Zoho Creator, it is not possible to generate a unique_value before records are being imported.

If so, I just do not understand why after importing of the data from the Excel file and encountering a unique value duplication (after trying to generate a unique_value - on success)  those records are not deleted automatically or at least, the user is not being informed on the possible records duplication.


What am I doing wrong?