Forum Discussion

TinaRevermann's avatar
TinaRevermann
Qrew Member
4 years ago

If/Then statements in Exact Form - Need Help

I am working on an exact form for a proposal.   I have numerous fields that if the "YES" is picked from the drop down field, I want a statement to go into the exact form proposal. Such as         F...
Formulas and functions
Wizards and add-ons
MarkShnier__You's avatar
MarkShnier__You
Qrew Champion
Np, just create a text formula field in Quick Base to calculate the phrase and then use THAT field on the Exact Form.  Post back if you need help with the formula.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
TinaRevermann's avatar
TinaRevermann
Qrew Member
4 years ago

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 = "&#8226;" &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__You's avatar
    MarkShnier__You
    Qrew Champion
    4 years ago
    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
    ------------------------------