I have a zoho creator application with a deluge validation script that works perfectly when entering data via the form:

2. dat  =  Add_Redbook_Income_Columns  [ID == input.Redbook_Income];
3. if ((dat.Redbook_Income_Column_Type  =  "Invoice")  &&  (((((input.Date_Invoiced  ==  null)  ||  (input.Invoiced_From  ==  null))  ||  (input.Invoice_Number  ==  null))  ||  (input.Invoiced_To  ==  null))  ||  (input.Invoice_Total  ==  null)))
4. {
5.     alert "Please note you have tried to record an invoice with out all the relevent details (Date Invoiced, Invoiced From, Invoice Number, Invoiced To, Total Invoiced), please update these details and re-submit.";
6.     cancel submit;
7. }

But fails when adding data via import even if the correct data is in place - please can you help.

Thanks