Combined Text Summary Field (Order and Clean)
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 G...
Forum Discussion
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>"
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>"
Mark,
Would you be able to explain this again? I've been trying to figure out where you put this formula, and I'm not having any luck. Is it on the field before you create a combined text? or is it the field that you add to your report?
Also, do you happen to have any ideas on how to get this thing to sort by date, from newest to oldest, where the number of texts fields you're combining will vary?
I think if I created a field where it's yyyymmdd and then used your method above I'd get most of the way there. I just would then need to sort it new - old.
------------------------------
Amanda Luna
------------------------------
Would you be able to explain this again? I've been trying to figure out where you put this formula, and I'm not having any luck. Is it on the field before you create a combined text? or is it the field that you add to your report?
Also, do you happen to have any ideas on how to get this thing to sort by date, from newest to oldest, where the number of texts fields you're combining will vary?
I think if I created a field where it's yyyymmdd and then used your method above I'd get most of the way there. I just would then need to sort it new - old.
------------------------------
Amanda Luna
------------------------------
- MarkShnier__You
Qrew Legend
Amanda,
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: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>"
------------------------------
Amanda Luna
------------------------------- MarkShnier__YouI 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
------------------------------
