Forum Discussion
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
I am almost there. I got those field to work and show up on a list. However, I also have a multi-select box that I got on the list by using ToText but if numerous items are checked they show up on one line. Anyway to get these to show on multiple lines?
Here is my formula. Its itemfive that I am having the problem with.
var text itemone = If([Opportunity - Resident notification required]="YES","•" & [Resident Notifications for Proposal],"");
var text itemtwo = If([Opportunity - NO Parking signs required]="YES","•" & [No Parking for Proposal], "");
var text itemthree =If([Opportunity - Sweeping Responsibility]="POST", "•" & [Sweeping Responsibility for Proposal],If([Opportunity - Sweeping Responsibility]="PRE/POST","•" & [Sweeping Responsibility for Proposal],""));
var text itemfour ="•" & "Furnish and Apply" & If([Opportunity - Product]="REC"," Reclamite",If([Opportunity - Product]="CRF"," CRF",""));
var text itemfive = "•" &If(ToText([CAM to])<>"",ToText([CAM to]));
List("<br>", $itemone, $itemtwo, $itemthree, $itemfour, $itemfive)
Tina Revermann
Operations Manager
Corrective Asphalt Materials, LLC
300 Daniel Boone Trail
South Roxana, IL 62087
618-254-3855 – office phone
618-484-7650 – Direct line/cell
618-254-2200 – fax
- MarkShnier__You5 years ago
Qrew Legend
np,
When you convert a multi select field to text it will appear as
apples ; peaches ; pears ; plums
with a separator of space semicolon space.
so if you make the formula
SearchAndReplace(ToText([my multi select field]), " ; ", "<br>")
then that would replace the current separators with <br> html line breaks.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------