SamW
6 years agoQrew Cadet
Combine values from an entire column of text fields
I have a table of 'Research Words'. It has about 60 rows, each containing a field named 'Research Word'. I would like to have a separate multi-line text field somewhere else that concatenates all those different Research Words.
I tried creating a parent table - 'Research Words Combined' - and using the Combine Text summary field. But it turns out that has limit on the number of characters and rows it can combine (I think it's 25 rows).
Can anyone suggest a way I can successfully combine all my Research Words into one field?
I tried creating a parent table - 'Research Words Combined' - and using the Combine Text summary field. But it turns out that has limit on the number of characters and rows it can combine (I think it's 25 rows).
Can anyone suggest a way I can successfully combine all my Research Words into one field?