Combined Text Summary Field (Order and Clean)

I believe what I did was to that code on the child table data as i needed the Combined text summary field to sort by [Record ID#] so the oldest ones would be first, but I did not want to show the date field.

For example let's say that the child data had Student names who were wait listed for a class and I wanted to list them in the order they registered, which I deemed to be by [Record ID#] as opposed to alpha. 

So I created a field on the wait list child record like

"<a href=" & PadLeft(ToText([Record ID#]),7,"0") & ">" & "</a>" & [Student name]
 
Then do a combined text summary field
Then on the parent record make a Formula Rich Text field which will convert the combined text field to text (which will end up being semi colon delimited), and substitute the semi colons with a html <br> character which will force a line break.

var text ConvertedToText = ToText([my combined text summary field]);

SearchAndReplace($ConvertedToText, " ; ", "<br>)

Let me know if that works in your use case.


------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------