Collection in List style pulling from Data spreadsheet only shows raw text

I’m trying to figure out how to use the Collection in List style to display the Description field in Rich Text / Markdown rather than as plain text. The column in my data table is a Rich Text / Markdown column, but is only displaying the Markdown characters rather than applying them.

Is this just how the List style works? Is there some other way to do this that will show multi-line formatted text? (None of the other styles seem to be able to show multi-line text in a compact way.)

Use a Custom Collection with rich text component inside the collection container.

I know I can use a Rich Text component, but these are multiple lines on a spreadsheet and I want this FAQ list to automatically update every time I add a line to the spreadsheet. I want to use a component that simply pulls the data from the spreadsheet without having to update the page manually for every question.

.

Repeating yourself is not a helpful answer.

So you added a custom collection component to your screen, then added a rich text component pointing to the column in your table with the markdown, and it still didn’t work?

It’s exactly what @Robert_Petitto showed in his video.

Here’s the documentation on custom collections.

If something still isn’t clear, feel free to share some screenshots showing how you tried to set it up.

1 Like

@mhsu_pw

It might help to understand how the custom collection works:

  • Each new item of the collection, often represented by a card or line in the display (though custom collections can do more than that), represents a row in the table.

  • Each component of the collection, which you can add in the selection panel on the left-hand side, represents a column or group of columns (attributes) in the table.

So the collection elements go vertically in the table, whereas components go horizontally, if that makes sense.

2 Likes

@Jeff_Hager Your third answer actually contained some helpful steps to check, as well as resources. Thank you. I have tried the HTML-based accordions, but unfortunately they do not have the option to pull data from a spreadsheet.

With the clarification from @nathanaelb I finally understand why I’ve been told to use a Custom Collection component. It will automatically iterate over all rows in a spreadsheet that meet the any Filter Data criteria that is set in the Custom Collection’s Options. All the user needs to do is create the Components and set them to the correct field of the data. This level of information is not present in any of the help pages that I was able to find, so thank you again Nathaniel!

While testing these two solutions, I discovered something - I was confused about why, when I added a Custom Collection component, it was being added not as Custom but as just Collection. Turns out that you cannot add a Custom Collection to a Container component. Glide does not give any sort of message but fails silently and converts it to a basic Collection within the Container. I will log this interaction as a bug.

Now that I have that information, I am able to add a Custom Collection. Based on Nathaniel’s response, I realized that the two components that I add to that Custom Collection are Text (pulling Data from the Question field of my spreadsheet) and Rich Text (pulling Data from the Answer field of my spreadsheet).

Now I have been able to get a well-formatted FAQ that pulls automatically from our spreadsheet. Thank you.

1 Like

That doesn’t sound right.

Pages Test · Glide 2023-09-15 at 8.00.02 AM

“Custom” is its own component, while a collection can take any other forms. From what you described, there’s a chance you chose another type of collection, instead of custom.

Also, there’s no chance you can add a custom collection inside a container. That’s not supported.

2 Likes

Hi @ThinhDinh - The screenshot you provided is exactly the component that I was clicking to add to my page. That is, in my understanding, a Custom Collection component. When added to a page, it is given the label “Custom Collection” which can be seen in my screenshot as the third item up from the bottom.

When I try to add it to a Container, though, I do not get any sort of error message. If that action is not supported, I would expect an error message saying so. I have logged that as a bug.

I mean you can’t drag that into a container anyway… It will just go out of the container and work on its own, so I can’t see how that can “convert to a basic collection”.

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.