@ ZOHO Creator Team:

I have a Form (say FormA) which contains a Dropdown (ListBox) Field (say FieldX).

FieldX is designed to be dynamically populated from a field (say FieldY) in another Form (say FormB) ... I have the script in the on Add on Load section of FormA to do this.

When I add records in FormA via the Add Form, everything works as expected.

But this Table (FormA) has hundreds of records ... so Client setup a Spreadsheet ... so contents of FormA can be uploaded via the Import link.

I find that FieldX is empty in all records after the Import operation.

If I specify a value for FieldA at Edit time, then the records with this value are imported properly.

So it looks like the Import function is a brute force method that does not respect the scripts to be serviced prior to adding each record.

In another Application, I noticed that when another user did a Bulk Edit (he is the Owner/Admin so I can't prevent him from doing this), ZOHO Creator ignored the on User Input section of the Form/Field.

When ZOHO Creator allows inconsistent updates to the data (depending on whether it is being done through the Form or via bulk methods), it compromises the integrity of the Database !!!

All bulk updates must be passed through the ...

- on Add on Load, on User Input, on Add on Validate and on Add on Success sections (import)

- on Edit on Load, on User Input, on Edit on Validate and on Edit on Success sections (bulk edit)

Gaev