Forum Discussion
MarkShnier__You
Qrew Legend
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
------------------------------
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
------------------------------
SystemAdmin7
5 years agoQrew Cadet
There may not be a good answer for this...
The fields that I am combining in to one are a rich text field, so when I create a combined text it's changing all the "&" to & and all the line breaks to " " The problem I am now running in to is that the Trim(Part($value,1,";")) is using the first semicolon in the text to break it up, which is sometimes contained in the " " etc. Do you know if there's a way around that? Looks like that is the ticket to getting it to sort new - old.
------------------------------
Amanda Luna
------------------------------
The fields that I am combining in to one are a rich text field, so when I create a combined text it's changing all the "&" to & and all the line breaks to " " The problem I am now running in to is that the Trim(Part($value,1,";")) is using the first semicolon in the text to break it up, which is sometimes contained in the " " etc. Do you know if there's a way around that? Looks like that is the ticket to getting it to sort new - old.
------------------------------
Amanda Luna
------------------------------
- SystemAdmin75 years agoQrew Cadet
Figured out a work around for anybody in the future:
1. Append a not commonly used character to the end of the field that you are going to create a combined text out of. I used "|".
2. Then use theList(", ",
Trim(Part($value,1,"|")),
Trim(Part($value,2,"|")),
Trim(Part($value,3,"|")),
Trim(Part($value,4,"|")), Etc
Formula posted by Mark, but instead of using a semicolon, you're going to use the special character you appended to the field above. I did warn everybody on staff that that character will break up the text weird if used, and they said they never use it anyway. That's the best I could work out.
------------------------------
Amanda Luna
------------------------------ - MarkShnier__You5 years agoQrew LegendIf you like contact me directly at mark.shnier@gmail.com and I will have a look at your app with you, "off the clock"
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------