EstherSchonfeld
Qrew Member
Joined 6 years ago
User Profile
User Widgets
Contributions
Re: Convert Combined Text into a list?
Sorry for the bother, I have one final question. How can I get the first line to display a bullet? var text Raw = SearchAndReplace(ToText([EOD Combined Text Session Text for Combined Text Summary sorted]),"</div>","|"); var text RawStepTwo= List("<br>•", 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,"|"),">")); If($RawStepTwo<>"", "#8226" & $RawStepTwo) ------------------------------ Esther Schonfeld ------------------------------Re: Convert Combined Text into a list?
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 ------------------------------Re: 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 ------------------------------Re: Link to new dashboard view from current Home Page
I am attempting to add a button to my homepage, but it won't give me an option to link the dashboard. It only allows me to add reports or pages and the dash does not show up. Any ideas? ------------------------------ Esther Schonfeld ------------------------------
