Forum Discussion
QuickBaseCoachD
6 years agoQrew Captain
No problem. But it will take 3 loops.
You already have your Combined text Summary field.
Use the ToText function to change it to text. It will appear as a semi colon space delimited sequence. Call it [First 25 terms]
Look that up to the child table
Make a new combined text Summary field subject to the condition the the [First 25 Terms] does not contain the value of the research word.. Call it [Next 25 terms]
Repeat the ToText and then the lookup and then do yet another combined text summary of the research words but now have two conditions in your filter to exclude if the word is in either the First or the Next.
Once you assemble the three fields into one using say the List function.
List "; ", and then three fields separated by commas)
you will have a long semi colon delimited string.
You can use this code to convert that to a clean vertical list
var text CombinedText = ToText([My Text Concatenation Field]);
var text RemoveSpaceAfterSemiColon =
SearchAndReplace($CombinedText, "; ",";");
// substitute new line for semicolon
SearchAndReplace($RemoveSpaceAfterSemiColon,";","\n")
You already have your Combined text Summary field.
Use the ToText function to change it to text. It will appear as a semi colon space delimited sequence. Call it [First 25 terms]
Look that up to the child table
Make a new combined text Summary field subject to the condition the the [First 25 Terms] does not contain the value of the research word.. Call it [Next 25 terms]
Repeat the ToText and then the lookup and then do yet another combined text summary of the research words but now have two conditions in your filter to exclude if the word is in either the First or the Next.
Once you assemble the three fields into one using say the List function.
List "; ", and then three fields separated by commas)
you will have a long semi colon delimited string.
You can use this code to convert that to a clean vertical list
var text CombinedText = ToText([My Text Concatenation Field]);
var text RemoveSpaceAfterSemiColon =
SearchAndReplace($CombinedText, "; ",";");
// substitute new line for semicolon
SearchAndReplace($RemoveSpaceAfterSemiColon,";","\n")