ListType and NumberedListType are both keywords used to transform CSV values into HTML lists without using a template.
Use the ListType keyword to transform a CSV value into an HTML ordered list. This can be used with or without a template. Compatible to use with a categoryFilter, csvFilterAnd or csvFilterOr.
ListType items can quickly be sorted using the Ascending (asc) or descending (desc) parameters.
You can use this keyword in the:
Comments
19 comments
If there's a comma in my sentence, how do I include it without the code reading it as a line break?
Example: "If this was a sentence, the comma would line break." would appear as
>If this was a sentence
> the comma would line break.
Hello Jdam,
It is not possible to use a comma in your text without a line break. That's how this keyword works.
Kind regard.
Thomas
Hello @Jdam.
@Thomas is correct. Armed with this knowledge, we can bypass the ListType keyword from breaking your sentences by substituting your sentence-commas with HTML code for commas - ,.
Hope this helps.
- Randy
Is there anyway to manipulate the ">" and make it not visible? Via CSS?
Hello Joaquin,
You can achieve this with:
.awt_list>ul>li:before{display:none}Nicolas
Is there any way to change the ">" to a different symbol, like a regular bullet point? Via CSS?
Hello Sam Roberts,
There is no such possibility to have the bullet point without a template sheet and CSS code.
Thank you for your understanding.
Thomas
Hi @Sam.
Yes, there is a way to change the bullet points to a standard one. Please copy and paste the code below to your <style> template. Click here to learn how.
.awt_list>ul>li:before {content: "\2022";
color: red;
}
* Note: The font color is included in case you need it. Remove or replace this as needed.
After pasting the code, simply refresh (F5) your view to see the changes.
- Randy
Hello.
Is there a way to use ListType for line breaks, but still be able to filter the comma-separated values (and not the newly created HTML ordered list as a single value) ?
Example: if the values in my cell are "USA, FRANCE, UK", I want line breaks + filter them for "USA", "FRANCE" and "UK". For the moment, if I use both ListType and csvFilter, I have the line breaks but I can only filter the values for "USA, FRANCE, UK"
Martin
Hello Martin Bagnol,
It is not possible to use ListType with a break line and keep the filter.
Kind regards.
Thomas
Randolph Abelardo, your answer was perfectly helpful and worked for us. Thank you!
Glad to be of service, @Sam Roberts :)
Hi @Martin Bagnol.
As @Thomas mentioned, there's no native way to achieve your desired end result in Awesome Table. But there's a simple hack that meets all the specifications you cited (we won't be using the listType keyword here). Read more if you're interested.
Note: This topic is beyond the scope of support and the solution shared is provided as a best-effort.
1.) Create a helper column for the target column (Skills & Expertise in our demo). Apply the hidden keyword.
2.) Apply the formula below: (modify as needed)
> This simply tells GSheets to find all instances of a comma followed by a space and replace it with an HTML line break <br> and add a pseudo bullet point for each csv entry.
* I just improved the formula, so please ignore the screenshot discrepancies.
3.) Make sure the data source range is updated to include the newly created helper column.
Click here to create your own copy of the demo. Simply click the USE TEMPLATE button at the top-right corner.
Hope this helps.
- Randy
Hello.
i tried to use the ListType with Links to a google Form. But, now, i want to replace the Link (https://docs.google.com/forms/...) for a text ("Form"), then use de ListType, but the Hiperlink isn´t work.
Hello Geronimo Diaz,
ListType only works with plain text, not Hyperlinks.
Regards
I´ll have to agree with Jdam, comas are kind of useful when writing text on bullet points. Any way to change the line break with a ; instead of a , ?
Hi @Billy.
Though we can't replace the standard comma-separated values function with a semicolon, a workaround is in place (solution also shared above).
Simply search & replace all commas in your text-records with its HTML equivalent ",".
Our listType / NumeredListType should render properly and your view will still output the commas where they were originally.
Hope this helps.
- Randy
Works like a charm @Randolph. 🤩🤗 Thanks for your quick answer! You're the boss ;)
Hello! I have possibly tricky question.
My goal is to create a recipe catalog that allows persons to filter by all possible ingredients they have and then be left with recipes containing at least one of the items they indicated.
I was able to create the spreadsheet and had been playing pack and forth with csvFilter and CategoryFilter for the ingredients. The problem with csvFilter, is that the ingredients aren't compounded so it isn't a list of continuous recipes it will only show recipes that have those specific ingredients. With the CategoryFilter I could have a dozen columns for every individual ingredient but then the drop down would be very annoying. Would there be a way to turn that into a button for each ingredient that will still filter as it goes? Might be too much for this platform but say it done in others so wasn't sure if there was a short-cut I hadn't found yet. Thank you!
Please sign in to leave a comment.