Two fields' answers merged into one column in the responses table or CSV
What you are seeing
Two fields' answers merged into one column in the responses table or CSV.
#Why it happens
Two fields on the same page share a Field ID. The index keys answers by Field ID, so the later field silently overwrites the earlier.
#What to do
Give every field on a page a unique Field ID. The auto-slug from the Label produces duplicates whenever two fields share a label.
#Limits that apply here
Limit | Value | What happens |
|---|---|---|
Indexed property size cap | 28,000 characters | The per-page index of answers is capped. Over the cap, multi-value answers are first truncated to their first 5 entries; then whole forms are dropped from the index; and if it still will not fit, the |
#Related
Large form's answers stopped appearing in the byline, the catalogue and property search - but they a
The page's forms exceeded the 28,000-character index cap. Multi-value answers were truncat
Columns in the responses table change as I page through
The field columns are built from whichever fields appear in the 25 rows currently on scree
Everything else
The rest of this family.
Found it? Good.
