Thank you so much for your help!
One more final question. How do I combine the 2 fields? I want the RTF field so I have the bullets and I want the sort order.
Parent table:
Field 1: EOD Status List:var text CombinedText = ToText([EOD Status Combined Text]);
var text ConvertToVerticalListWithBullets=
Trim(SearchAndReplace($CombinedText, " ; ","<br>•")); // separate entries with a new line and a bullet
If($ConvertToVerticalListWithBullets<>"", "•") // this is a bullet for the first entry
&
$ConvertToVerticalListWithBullets
Field 2: EOD Status List:
var text Raw =
SearchAndReplace(ToText([EOD Combined Text Session Text for Combined Text Summary sorted]),"</div>","|");
List("\n",
Right(Part($Raw,1,"|"),">"),
Right(Part($Raw,2,"|"),">"),
Right(Part($Raw,3,"|"),">"),
Right(Part($Raw,4,"|"),">"),
Right(Part($Raw,5,"|"),">"),
Right(Part($Raw,6,"|"),">"),
Right(Part($Raw,7,"|"),">"),
Right(Part($Raw,8,"|"),">"),
Right(Part($Raw,9,"|"),">"),
Right(Part($Raw,10,"|"),">"),
Right(Part($Raw,11,"|"),">"),
Right(Part($Raw,12,"|"),">"),
Right(Part($Raw,13,"|"),">"),
Right(Part($Raw,14,"|"),">"),
Right(Part($Raw,15,"|"),">"),
Right(Part($Raw,16,"|"),">"),
Right(Part($Raw,17,"|"),">"),
Right(Part($Raw,18,"|"),">"),
Right(Part($Raw,19,"|"),">"),
Right(Part($Raw,20,"|"),">"),
Right(Part($Raw,10,"|"),">"),
Right(Part($Raw,21,"|"),">"),
Right(Part($Raw,22,"|"),">"),
Right(Part($Raw,23,"|"),">"),
Right(Part($Raw,24,"|"),">"),
Right(Part($Raw,25,"|"),">"),
Right(Part($Raw,26,"|"),">"),
Right(Part($Raw,27,"|"),">"),
Right(Part($Raw,28,"|"),">"),
Right(Part($Raw,29,"|"),">"),
Right(Part($Raw,30,"|"),">"),
Right(Part($Raw,31,"|"),">"),
Right(Part($Raw,32,"|"),">"),
Right(Part($Raw,33,"|"),">"),
Right(Part($Raw,34,"|"),">"),
Right(Part($Raw,35,"|"),">"),
Right(Part($Raw,36,"|"),">"),
Right(Part($Raw,37,"|"),">"),
Right(Part($Raw,38,"|"),">"),
Right(Part($Raw,39,"|"),">"),
Right(Part($Raw,40,"|"),">"),
Right(Part($Raw,41,"|"),">"),
Right(Part($Raw,42,"|"),">"),
Right(Part($Raw,43,"|"),">"),
Right(Part($Raw,44,"|"),">"),
Right(Part($Raw,45,"|"),">"),
Right(Part($Raw,46,"|"),">"),
Right(Part($Raw,47,"|"),">"),
Right(Part($Raw,48,"|"),">"),
Right(Part($Raw,49,"|"),">"),
Right(Part($Raw,50,"|"),">"),
Right(Part($Raw,51,"|"),">"),
Right(Part($Raw,52,"|"),">"),
Right(Part($Raw,53,"|"),">"),
Right(Part($Raw,54,"|"),">"),
Right(Part($Raw,55,"|"),">"),
Right(Part($Raw,56,"|"),">"),
Right(Part($Raw,57,"|"),">"),
Right(Part($Raw,58,"|"),">"),
Right(Part($Raw,59,"|"),">"),
Right(Part($Raw,60,"|"),">"))
------------------------------
Esther Schonfeld
------------------------------
Original Message:
Sent: 08-02-2022 16:48
From: Mark Shnier (Your Quickbase Coach)
Subject: Convert Combined Text into a list?
=Change the [session date in words] field to the text field that you are trying to float up to the parent record ... what you are doing the combined text on now, but don't like the alpha sort.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
Original Message:
Sent: 08-02-2022 16:33
From: Mark Shnier (Your Quickbase Coach)
Subject: Convert Combined Text into a list?
Try this trick
Create a formula text field on the child
Child formula
var text RollupText = ToText([Session Date in Words]);
var text ZeroPaddedDaysfromFiveYearsSAheadFromToday=
PadLeft(ToText(100000 - ToDays((AdjustYear(Today(),5) - [Date]))),8,"0");
"<div style=" & $ZeroPaddedDaysfromFiveYearsSAheadFromToday & ">"& $RollupText & "</div>"
Then make a combined text summary of that field called something like
[Combined Text Session Text for Combined Text Summary sorted]
Then make this formula on the Parent.
Parent formula
var text Raw =
SearchAndReplace(ToText([Combined Text Session Text for Combined Text Summary sorted]),"</div>","|");
List("\n",
Right(Part($Raw,1,"|"),">"),
Right(Part($Raw,2,"|"),">"),
Right(Part($Raw,3,"|"),">"),
Right(Part($Raw,4,"|"),">"),
Right(Part($Raw,5,"|"),">"),
Right(Part($Raw,6,"|"),">"),
Right(Part($Raw,7,"|"),">"),
Right(Part($Raw,8,"|"),">"),
Right(Part($Raw,9,"|"),">"),
Right(Part($Raw,10,"|"),">"),
Right(Part($Raw,11,"|"),">"),
Right(Part($Raw,12,"|"),">"),
Right(Part($Raw,13,"|"),">"),
Right(Part($Raw,14,"|"),">"),
Right(Part($Raw,15,"|"),">"),
Right(Part($Raw,16,"|"),">"),
Right(Part($Raw,17,"|"),">"),
Right(Part($Raw,18,"|"),">"),
Right(Part($Raw,19,"|"),">"),
Right(Part($Raw,20,"|"),">"),
Right(Part($Raw,10,"|"),">"),
Right(Part($Raw,21,"|"),">"),
Right(Part($Raw,22,"|"),">"),
Right(Part($Raw,23,"|"),">"),
Right(Part($Raw,24,"|"),">"),
Right(Part($Raw,25,"|"),">"),
Right(Part($Raw,26,"|"),">"),
Right(Part($Raw,27,"|"),">"),
Right(Part($Raw,28,"|"),">"),
Right(Part($Raw,29,"|"),">"),
Right(Part($Raw,30,"|"),">"),
Right(Part($Raw,31,"|"),">"),
Right(Part($Raw,32,"|"),">"),
Right(Part($Raw,33,"|"),">"),
Right(Part($Raw,34,"|"),">"),
Right(Part($Raw,35,"|"),">"),
Right(Part($Raw,36,"|"),">"),
Right(Part($Raw,37,"|"),">"),
Right(Part($Raw,38,"|"),">"),
Right(Part($Raw,39,"|"),">"),
Right(Part($Raw,40,"|"),">"),
Right(Part($Raw,41,"|"),">"),
Right(Part($Raw,42,"|"),">"),
Right(Part($Raw,43,"|"),">"),
Right(Part($Raw,44,"|"),">"),
Right(Part($Raw,45,"|"),">"),
Right(Part($Raw,46,"|"),">"),
Right(Part($Raw,47,"|"),">"),
Right(Part($Raw,48,"|"),">"),
Right(Part($Raw,49,"|"),">"),
Right(Part($Raw,50,"|"),">"),
Right(Part($Raw,51,"|"),">"),
Right(Part($Raw,52,"|"),">"),
Right(Part($Raw,53,"|"),">"),
Right(Part($Raw,54,"|"),">"),
Right(Part($Raw,55,"|"),">"),
Right(Part($Raw,56,"|"),">"),
Right(Part($Raw,57,"|"),">"),
Right(Part($Raw,58,"|"),">"),
Right(Part($Raw,59,"|"),">"),
Right(Part($Raw,60,"|"),">"))
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
Original Message:
Sent: 08-02-2022 14:24
From: Esther Schonfeld
Subject: Convert Combined Text into a list?
Thank you very much, that worked perfectly!
Anything on getting the list to sort by date?
------------------------------
Esther Schonfeld
Original Message:
Sent: 08-02-2022 10:31
From: Mark Shnier (Your Quickbase Coach)
Subject: Convert Combined Text into a list?
There are 2 ways to make bullets
https://www.quickbasejunkie.com/blog/multi-select-bullet
and a formula rich text field like this.
var text CombinedText = ToText([My Text Concatenation Field for Child names]);
var text ConvertToVerticalListWithBullets=
Trim(SearchAndReplace($CombinedText, " ; ","<br>•")); // separate entries with a new line and a bullet
If($ConvertToVerticalListWithBullets<>"", "•") // this is a bullet for the first entry
&
$ConvertToVerticalListWithBullets
as for getting the list to sort by date
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
Original Message:
Sent: 08-01-2022 15:21
From: Esther Schonfeld
Subject: Convert Combined Text into a list?
Hi,
I have 2 questions on the Combined Text field.
- I am looking into making it a list. I tried the above, which works great. Is there a way to add a character or bullet point before each line?
- How can I sort the combined field, based on a specific date field in my child table?
------------------------------
Esther Schonfeld
Original Message:
Sent: 07-20-2020 12:16
From: Paul Peterson
Subject: Convert Combined Text into a list?
I had issues getting the summary fields right. I think I'm finally there.
------------------------------
Paul Peterson
Original Message:
Sent: 07-17-2020 16:49
From: Mark Shnier (YQC)
Subject: Convert Combined Text into a list?
I'm still not understanding.
I previously posted this above.
The best way to get the min max and count would be to make new summary fields on the same relationships where the Combined Text Summary field was made.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
Original Message:
Sent: 07-17-2020 16:14
From: Paul Peterson
Subject: Convert Combined Text into a list?
It's not a matter of what I want it to look like, it's more a matter of how I can manipulate the data. I need to get a count of the actual items in the "list", get max and min values over that same list. I am able to extract some of the data into a summary field, but not for all fields needed.
------------------------------
Paul Peterson
Original Message:
Sent: 07-17-2020 15:24
From: Mark Shnier (YQC)
Subject: Convert Combined Text into a list?
What do you mean by "an actual list". Can you attach an image of what you want it to look like?
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
Original Message:
Sent: 07-17-2020 15:21
From: Paul Peterson
Subject: Convert Combined Text into a list?
This method doesn't actually generate a list. Is there any way that will create an actual list rather than something that looks like one?
------------------------------
Paul Peterson
Original Message:
Sent: 07-10-2020 15:27
From: Mark Shnier (YQC)
Subject: Convert Combined Text into a list?
To convert a combined text summary field into a vertical list, you can use this syntax in a formula text field.
SearchAndReplace([My Combined Text Summary field], " ; ", "\n")
The best way to get the min max and count would be to make new summary fields on the same relationships where the Combined Text Summary field was made.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
Original Message:
Sent: 07-10-2020 12:42
From: Paul Peterson
Subject: Convert Combined Text into a list?
What is the best way to convert a combined text summary field to a list? Also, is it possible to find the highest value, lowest value and total items in the field?
------------------------------
Paul Peterson
------------------------------