Looking for a way to construct a form for users to fill in
to display the form, by default the fields are listed in order of the field IDs. You can easily override this by using the sort and fields parameters.
Thanks, Rick.
But there are some problems. First: The default seems not to be by element ID. In fact, not even the tracker admin view does that. Sorting by element ID is set, but still tiki-admin_tracker_fields.php?trackerId=ID displays all field in a random order, which makes form design a tough job.
I tried to analyze what exactly the order is. It is not the order of field creation time, I could reproduce this by erasing the tracker and recreating it piece by piece in strictly the correct order. Also, in theory time creation couldn't be the reason, as MySQL does not store creation timestamps for records. I could not find any other order that is used. It's not numeric, it's not alphanumeric, so in lack of a better description I have to call it "random".
This tracker has 18 fields, so the order is of the essence. For instance, there have to be more than one field to store user consent (By law, consent to billing has to be separate from consent to membership, and consent must have date/time as entered by the user). If the order is broken, the form becomes useless.
Also, the records created in this way cannot be viewed with built-in tools like tiki-view_tracker.php: Same problem, seemingly random ordering of fields.