I am using a multiple select from an entity list (select_one_from_file this_list.csv). I want to combine labels to show these in the multiple select list, for example contract number + farmer name.
I tried to use the column relevant and entered: value=id, label=contract_number, label=full_name_farmer. This does not work.
I also tried the list_name + label column in the entity tab using concat (concat("contract_number: ",${get_contract_number}, " name_farmer: ", ${name_farmer})
No result neither.
Please provide the xlsform if you can. It is a bit difficult to understand your scenario.
If your entity list contains another column which can act as key, says key1 and this key1 is the results of concatenate multiple attributes, similar to your label, you can place value=key1 as parameters in select_one/multiple question. This will return the key1 value instead of uuid.
I think using value=label might not working, but you can try.
Thanks for the feedback. I finally solved it by creating a separate label column in my entity list combining names with concat(). So, I now added a calculate row in my XLSform using concat(). With that I combine farmer_name and contract_nr in my entity list. And then I use this column in. y entity list to create the label.