Sep 02, 2022 04:49 PM
Gday all,
I have a rollup field of ‘text’, which I am trying to display as a list.
Currently the rollup displays like this:
Item1Item2Item3
What I want to achieve is:
Item1
Item2
Item3
I’ve tried multiple different formulas - concatenates but cannot get it to work!
Thanks
Sep 02, 2022 05:36 PM
What formulas have you tried? Can you share a screen shot of the fields in question?
Have you tried `ARRAYJOIN(values, “\n”) as the rollup formula?
Sep 03, 2022 12:23 AM
Thanks @kuovonne - this formula works perfectly, BUT can the field wrap the text so it displays as the 3 lines without clicking into the field?
Sep 03, 2022 01:45 AM
You can increase the row height. There isn’t anything the formula itself can do about this behavior.
Sep 03, 2022 03:39 AM
You can’t change that behavior on the grid view itself, but there are at least 2 other ways that you can visually prevent the text from collapsing together like that.
These 2 ways would enable you to always see the properly wrapped text with its carriage returns (i.e. new lines) always visually intact:
Use Airtable’s Interfaces feature. Interfaces will always display the fully-expanded text of a long text field at all times. Some people dislike this because it can take up a ton of screen space, but in your case, it sounds like exactly what you’re looking for.
Use the 3rd-party extension On2Air: Amplify, which lets you create your own customized dashboards with the exact height & width of whatever fields you choose. You get to specify exactly how wide & how tall you want your chosen fields to be, and you also have the benefit of never needing to leave grid view to switch to Airtable’s interfaces feature.
p.s. I should also mention that I am an Airtable consultant, so if your company has a budget & you need one-on-one help setting these things up, please feel free to contact me through my website: Airtable consulting — ScottWorld.
Sep 04, 2022 11:30 PM
Thanks Scott! Will check out your website for sure!