More flexibility regarding change of schema
Hello!
More flexibility regarding a change of the underlying data schema is maybe the most important improvement I wished to see in in "Zoho Creator".
Example: I create a field "Rating" of type "Choices - Single select" in form "Book" with following choices: {poor,middle,super}. Then I put some records into the corresponding table and also fill in some ratings. Now I rename the available choices of the field "Rating" to {bad,ok,good}. The result is, that in every record the value of the field "Rating" simply disappears. I would expect, that "poor" turns into "bad", "middle" into "ok" and "super" into "good". Well, like if there's a primary key for the choices. Not the labels should be stored, but some IDs like {1=>bad,2=>ok,3=>good}. That would also correspond to HTML way of displaying selection lists: The value attribute gets the ID and actually displayed is the label.
OK, I just realized that there's a workaround. Simply create a form "Rating" which contains the records "bad", "middle" and "ok" or whatever and then refer to that form by using a field of type "Import data from".
But again there's the problem. If I would migrate now from my old schema (using "Choices") to the new schema (using "Import data from") all values in the field "Rating" are lost.
Do you think this can be managed in an elegant way?
Thanks for reading.
Benjamin