Forum Discussion
Can you ask a complete question? You are asking me to re-explain "this".
As for sorting by date, yes, you will need to make a field in the format YYYYMMDD and have that be the first field so as to sort on that. The combined text summary field will sort alpha, from low to hight.
You will need to zero pad the MM and DD to handle months and days with 1 digit.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------
Hi,
Maybe I didn't reply on top of the comment to which I was referring..
Would you mind elaborating on this:
------------------------------
Amanda Luna
------------------------------
- MarkShnier__You5 years agoQrew LegendI 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
------------------------------- SystemAdmin75 years agoQrew CadetThere 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
------------------------------- 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
------------------------------
- GerryMunroe11 months agoQrew Trainee
Thank you so much, this is genius!
------------------------------
Gerry Munroe
------------------------------