im creating a Grid Style index with glide (first time user)
when you select one category, it opens various options, the thing is that I would like to add a line breaks when a category has various items.
for example, instead of showing “a b c” (thats whats currently in the data tab)
show:
a
b
c
is it posible to add a command or symbol that ads this break ?
Are you storing it exactly like that in one column (“a b c”)? You could use a template column to replace the space character with a CRLF character. I guess it all depends on how the data is stored and how you are displaying it.
Its an imported excel. It’s not just a b c, it’s longer names.
Thing is that it’s stored in once single cell.
I would like it to display in different rows, but the excel is various terms in one cell.
Can you elaborate on how you want to display it? Do you just want to to see it as text on the screen? You mentioned displaying in separate rows. I just want to make sure you don’t mean separate table rows, and actually mean just visually displayed with line breaks on the screen.
Do you have an example of actual data?
Yeah so we are organizing a fair for small business, we asked all attending business to complete a Google form.
In that form one question is “what are you selling” so people responded like “bread, baked goods and cookies” for example.
When this is exported from Google forms, that answer is just one cell.
I’m using glide to have an index of every stand and what they sell.
But in glide it looks like this:
“Bread, Baked
Goods, cookies”
And I would like it to looks like this:
Bread
Baked goods
Cookies
Also, some stands have lots of things to sell. Whereas other stands just sell one thing.
Ok, so you have a couple of options.
Like I said above, you can use a template column to replace the commas with a CRLF or a <br> html tag, and then display in whichever component works best. Maybe a rich text component for example.
Another option is to use a Split Text component to convert it to an array. Then use a Joint List column with a CRLF (or <br>) separator to convert it back to text. This second method is kind of pointless because it would ultimately be the same result as using the template column on it’s own.
YES! This works beautifully, thank you very much!!
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.