ListType and NumberedListType

Follow

Comments

15 comments

  • Avatar
    Jdam

    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.

  • Avatar
    Awesome Table

    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

  • Avatar
    Randolph Abelardo (Edited )

    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

  • Avatar
    Joaquín Mathó Arata

    Is there anyway to manipulate the ">" and make it not visible? Via CSS?

  • Avatar
    Nicolas Gauvin

    Hello Joaquin,

    You can achieve this with:

    .awt_list>ul>li:before{display:none}

    Nicolas

  • Avatar
    Sam Roberts

    Is there any way to change the ">" to a different symbol, like a regular bullet point? Via CSS?

  • Avatar
    Thomas Morin

    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

  • Avatar
    Randolph Abelardo (Edited )

    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

  • Avatar
    Martin Bagnol

    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

  • Avatar
    Thomas Morin

    Hello Martin Bagnol,

    It is not possible to use ListType with a break line and keep the filter.

    Kind regards.

    Thomas

  • Avatar
    Sam Roberts

    Randolph Abelardo, your answer was perfectly helpful and worked for us. Thank you!

  • Avatar
    Randolph Abelardo

    Glad to be of service, @Sam Roberts :) 

  • Avatar
    Randolph Abelardo (Edited )

    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)

    ="<br>• " & REGEXREPLACE(H3,", ", "<br>• ")

    > 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

     

     

     

  • Avatar
    Geronimo Diaz

    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.

  • Avatar
    Nicolas Gauvin

    Hello Geronimo Diaz,

    ListType only works with plain text, not Hyperlinks.

    Regards

Please sign in to leave a comment.