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
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
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
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
------------------------------- 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
------------------------------
