About Import Fields (Picklists) ...
Hi:
I am trying to setup a Table of (US) States and (Canadian) Provinces ... to be used as a dropdown with Import Fields in other Tables.
I want the entries to appear in alphabetical order ... but all the (US) States first ... followed by all the (Canadian) Provinces ... so I can not make use of the checkbox labelled "Show choices in alphabetical order" ... as a work around, I thought of bulk uploading (Import) the records in the desired order ... and I ran into two issues ...
a) since the records are stored in the reverse order of them being loaded (imported) ... I had to make sure the source (.csv) file contained the records in the reverse order than that which I desire to be listed in the dropdown box ... I was able to get around this by ...
- first importing the list in desired order
- exporting the (now in reverse order) records to another csv file
- deleting all the previously loaded records
- importing the (now in reverse order) records
b) however, I find that even though the records display in the desired order in the Table (View) that they are loaded, when I ask to show themn in Lookup fields in other Tables, they are displayed in the order they were loaded ... making it unnecessary for me to go through the steps in (a) above.
Perhaps the way ZOHO Creator handles the loading of records in a Lookup field ... should be clearly explained in the Help documentation ... so others do not waste their time similarly.
Also, the Lookup field could provide additional options ... like sort the records by fieldx (asc/desc) + fieldy (Asc/Desc) etc.
Gaev