The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.
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!