Multiple columns as one label - search from csv

1. What is the issue? Please be detailed.
I would like to display multiple column values and display as label from search in appearance cell.
Example, i have monthly summary for crops and yield. I would like to dispay crop and yield together as a label in choice and month as values.

2. What steps can we take to reproduce this issue?

documentation says " If you wish to include multiple columns in the labels, include a comma-separated list of all columns to include. The name column will be dynamically populated based on the column name you put there, and the label column will be dynamically populated based on the column name(s) you put there."

However, It does work. It takes last column written in cell of label.

3. What have you tried to fix the issue?

4. Upload any test forms or screenshots below.

Can you attach the files for what you have tried so far?

When I tried yesterday, somehow it is working in my new form.

It would be great if you can share how you solved the problem, so that the community can learn from what you did.

In survey sheet question is select_one that fetching data from external csv with search tool in appearance column.
in Choices sheet, list_name - name - label is following setting (label with comma separated).
parcel_list_concat parcel_uid parcel_name,srno

see attached form

4_household_onboarding-form-designV1 - Copy.xlsx (28.9 KB)
land_db_new.csv (740 Bytes)

1 Like