Forum Discussion
QuickBaseCoachD
7 years agoQrew Captain
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>"
SystemAdmin7
6 years agoQrew Cadet
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
------------------------------