ListType and NumberedListType

Follow

Comments

18 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.

    0
    Comment actions Permalink
  • 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

    0
    Comment actions Permalink
  • 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

    0
    Comment actions Permalink
  • Avatar
    Joaquín Mathó Arata

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

    0
    Comment actions Permalink
  • Avatar
    Nicolas Gauvin

    Hello Joaquin,

    You can achieve this with:

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

    Nicolas

    1
    Comment actions Permalink
  • Avatar
    Sam Roberts

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

    0
    Comment actions Permalink
  • 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

    -2
    Comment actions Permalink
  • 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

    2
    Comment actions Permalink
  • 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

    0
    Comment actions Permalink
  • Avatar
    Thomas Morin

    Hello Martin Bagnol,

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

    Kind regards.

    Thomas

    0
    Comment actions Permalink
  • Avatar
    Sam Roberts

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

    0
    Comment actions Permalink
  • Avatar
    Randolph Abelardo

    Glad to be of service, @Sam Roberts :) 

    0
    Comment actions Permalink
  • 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

     

     

     

    0
    Comment actions Permalink
  • 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.

    0
    Comment actions Permalink
  • Avatar
    Nicolas Gauvin

    Hello Geronimo Diaz,

    ListType only works with plain text, not Hyperlinks.

    Regards

    0
    Comment actions Permalink
  • Avatar
    Billy Milon Esparza

    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 , ?  

    0
    Comment actions Permalink
  • Avatar
    Randolph Abelardo (Edited )

    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 "&#44;".
    Our listType / NumeredListType should render properly and your view will still output the commas where they were originally.

    Hope this helps.

    - Randy

    0
    Comment actions Permalink
  • Avatar
    Billy Milon Esparza

    Works like a charm @Randolph. 🤩🤗 Thanks for your quick answer! You're the boss ;)

    0
    Comment actions Permalink

Please sign in to leave a comment.