[image] Now you can add a “Joined List” column in production apps. In the example, I joined the list of dishes from a category relation, separated by a comma.

is there a limit on the number of items/characters that should be included in a joined list? if hypothetically I included several hundred rows in a big joined list of several thousand characters, would this cause performance issues?

[image] Chat and Comments using the Trebuchet Method Project Showcase According to @Jason you can store 1 million characters in a glide table cell. Google sheets limited to 50,000 characters per cell I think here’s the relevant info.

[image] Jeff_Hager: I use it myself to build dynamic html or markdown tables from multiple rows of data. Would love to see a couple simple versions of this

@Robert_Petitto I threw together a quick example here. Multiple Row Reset Concept It’s adapted from how I currently use it in my main app to display a list of lessons in an Invoice. I mix it with CSS to get the border and the alternating gray bar.

Thanks Jeff! Really appreciate you taking the time to create an example!

Not sure if this might be of interest to anyone, but we can avoid use of formulas to split items across several rows by just replacing the comma with < /br > < /br > and pull the items as a list using the rich text component.

Can you give us a usecase Wiz? I guess I didn’t get it at all

Just a single CRLF (carriage return line feed) also works. I use this to generate CSV exports.

@Lucas_Pires say we have a long list of items. Comma separated result is below: [comma separated] HTML break tag separated result is below [HTML break tag]

🆕 Joined List column ready in production

Ask for Help

Purvang_Joshi September 10, 2021, 2:42pm 24

I’ve posted months ago. I’m using apps script for the same. It’s so easy to implement and not more than 10 lines of code

Topic		Replies	Views
Is it possible to add multiple rows with Joined list? Ask for Help	1	672	March 26, 2022
Write an array column (via Lookup) to Google sheet Report a Bug	42	4425	August 13, 2020
How to combine text from the same Column based in a value in another Column Ask for Help	8	1084	January 17, 2024
Multiple Columns of Data Merged in Glide? Ask for Help	20	4050	May 7, 2021
Join columns and unite the results in one line Ask for Help	15	2183	January 17, 2024

🆕 Joined List column ready in production

Related topics