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         Field is:    Is Aggregate included:            possible answers in drop down are : YES   or   NO.  

How do I write it in the exact for that
if YES is selected then    " Aggregate to be supplied by Contractor " is put on the exact form

or 
if NO is selected then     "Aggregate supplied by Customer" is put on the exact form. 


Any help would be appreciated and Thanks in Advance!!!!

------------------------------
Tina Revermann
------------------------------
Formulas and functions
Wizards and add-ons

3 Replies

Sort By
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    4 years ago
    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
        Icon for Qrew Legend rankQrew Legend
        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
        ------------------------------