Ordering and Sorting of Views
I am really enjoying digging into the heart of Zoho Creator! It is very powerful.
However, I find it incredibly unintuitive that the first records entered into a view are listed last and the last records entered listed first. This makes it really hard for the type of database I am currently working on:
http://creator.zoho.com/scotto/countries-and-states/
In this database, it is important that the views list the countries in order for easy browsing. To do this, I've had to re-sort them in descending order before importing.
Also, it seems that sorting only works a page at a time. I cannot sort the whole database. This really adds a challenge as to keep the records in alphabetical order, I have to re-import all the records. Any new record added goes to the end of the database and there is no way that I can find to put it into its proper place.
On top of this, since the records are read last to first, to put records in A to Z order in a dropdown, I have to have them listed in descending order as well. (for instance in the regions view in app I mentioned.) It seems that even if you choose to display them in alphabetical order in the field options, it will still order them from last to first.
Regardless of these challenges, I still love Zoho Creator but I feel these are fundamental issues that should be addressed.