Quick Base Discussions

Expand all | Collapse all

Combined Text Summary Field (Order and Clean)

  • 1.  Combined Text Summary Field (Order and Clean)

    Posted 01-29-2019 19:12
    The Combine Text summary field is great. But what I would like to do is determine the order -- Which I have achieved by creating a [Order] field within my child table....

    [Combine Text Field] = 1 Group A, 2 GroupD, 3 GroupH, 4 GroupY, 5 GroupU, 6 GroupK  

    The new Ordered Combine Text Field is now ordered -- but I want to remove the numbers as well as ";" which is "hidden" in the combine text field.

    Example: when I create a rich text formula field -- and only insert the [Combine Text Field] -- the field is displayed -- [Rich Text Formula fieldA] = 1 Group A, ; 2 GroupD, ; 3 GroupH, ; 4 GroupY, ; 5 GroupU, ; 6 GroupK  

    I would like for the field to display as =  Group A, GroupD, GroupH, GroupY, GroupU, GroupK

    I was almost successful with the formula below -- but the formula would only display the first five Groups --- so if greater than 6 groups --- no luck -- also issue is I had "10" as a position...

    Almost worked formula below = Group A, GroupD, GroupH, GroupY, GroupU, 

    List ("", 
    Part(ToText([Combined Text]),1,"123456789;"),
    Part(ToText([Combined Text]),2,"123456789;"),
    Part(ToText([Combined Text]),3,"123456789;"),
    Part(ToText([Combined Text]),4,"123456789;"),
    Part(ToText([Combined Text]),5,"123456789;"),
    Part(ToText([Combined Text]),6,"123456789;"),
    Part(ToText([Combined Text]),7,"123456789;"),
    Part(ToText([Combined Text]),8,"123456789;"),
    Part(ToText([Combined Text]),9,"123456789;"),
    Part(ToText([Combined Text]),10,"123456789;"),
    Part(ToText([Combined Text]),11,"123456789;"))

    Any advice is greatly appreciated.


  • 2.  RE: Combined Text Summary Field (Order and Clean)

    Posted 01-29-2019 19:55
    var text value = ToText([my combined text summary field]);

    List(", ",
    Trim(Part($value,1,";")),
    Trim(Part($value,2,";")),
    Trim(Part($value,3,";")),
    Trim(Part($value,4,";")),
    Trim(Part($value,5,";")),
    Trim(Part($value,6,";")),
    Trim(Part($value,7,";")),
    Trim(Part($value,8,";")),
    Trim(Part($value,9,";")),
    Trim(Part($value,10,";")),
    Trim(Part($value,11,";")),
    Trim(Part($value,12,";")),
    Trim(Part($value,13,";")),
    Trim(Part($value,14,";")),
    Trim(Part($value,15,";")),
    Trim(Part($value,16,";")),
    Trim(Part($value,17,";")),
    Trim(Part($value,18,";")),
    Trim(Part($value,19,";")),
    Trim(Part($value,20,";")),
    Trim(Part($value,21,";")),
    Trim(Part($value,22,";")),
    Trim(Part($value,23,";")),
    Trim(Part($value,24,";")),
    Trim(Part($value,25,";"))
    )


  • 3.  RE: Combined Text Summary Field (Order and Clean)

    Posted 01-29-2019 20:08
    Mark,

    Your formula works great for removing the ";" --- any suggestions for removing the numbers -- 

    1 Group A, ; 2 GroupD, ; 3 GroupH, ; 4 GroupY, ; 5 GroupU, ; 6 GroupK  

    I use the numbers to allow me to determine the order --- 

    Thank you


  • 4.  RE: Combined Text Summary Field (Order and Clean)

    Posted 05-21-2019 17:18
    Hi I am running into a similar issues and need to figure out how Quickbase sorts the Multi-select Text (summary) field. I need a way to set the sorting order. 

    Thank you


  • 5.  RE: Combined Text Summary Field (Order and Clean)

    Posted 05-21-2019 18:07
    I recently needed to have the Summary field sort by Record ID# which is not alpha.  The raw summary field will sort alpha.

    I used a formula rich text field and prefaced each element with a fake href hyperlink. The hyperlink has a "URL" component, but no words to be displayed, so it ends up being invisible in a formula  Rich Text field.

    "<a href=" & PadLeft(ToText([Record ID#]),7,"0") & ">" & "</a>"




  • 6.  RE: Combined Text Summary Field (Order and Clean)

    Posted 01-30-2019 00:21
    List(", ",
    Trim(NotLeft(Part($value,1,";"),2)),
    Trim(NotLeft(Part($value,2,";")),2),

    etc




  • 7.  RE: Combined Text Summary Field (Order and Clean)

    Posted 01-31-2019 22:31
    Thank you Mark.....worked great!