is it possible to enter variables of a code list in the field randomly but have them in a chronological order in the database in Collect?

Hi Beka!
In the exported csv file, a multiple code attribute is exported into several columns, each column corresponding to the position of the selected values (e.g. tree_habitat1 = first selected value, tree_habitat[2] = second selected value, tree_habitat[N] = Nth selected value...).
If you want to see the values in a different way, you can select among the Additional options of the CSV export Expand code attributes (add boolean columns for each code value).
The result will be a csv file with additional columns, one per each value of tree_habitat (e.g tree_habitat_1, tree_habitat_2) and true or false if the value has been selected or not.
Thanks,
Open Foris Team

Hello Beka,

I offer another solution. I assume that in your code list for habitat features there are more than 10 options. Anyway, create 10 (code) attributes for your entity, hab1..hab10. Set them as Not required, and add custom checks for hab2..hab10, as follows

I am missing the custom error message in this example but that you can add as needed.

This is not giving from Collect exactly that table what you are looking for, but in the data analysis you can get frequencies for categories in hab1..hab10 as necessary.

Regards, Lauri

Beka, OF Team programmer can help in that question regarding error message. I have - again - a bit different solution: add habitat selections into a calculated text field. This additional text field (Dist_txt below) can be set invisible (deselect Show in entry form). Use function shown below

When exporting the data into CSV, all selections goes into one field, which requires parsing in R or Excel.

-Lauri