Discussions

Expand all | Collapse all

If/Then statements in Exact Form - Need Help

  • 1.  If/Then statements in Exact Form - Need Help

    Posted 8 days ago
    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
    ------------------------------


  • 2.  RE: If/Then statements in Exact Form - Need Help

    Posted 8 days 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
    ------------------------------



  • 3.  RE: If/Then statements in Exact Form - Need Help

    Posted 7 days 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

     

     






  • 4.  RE: If/Then statements in Exact Form - Need Help

    Posted 7 days 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
    ------------------------------