Discussions

Expand all | Collapse all

Creating if statements for rich text fields for exact forms plus

  • 1.  Creating if statements for rich text fields for exact forms plus

    Posted 02-01-2019 15:14
    So I am trying to create a field inside Exact Forms Plus that will only show the information I choose without the additional spacing for cells that are not being used. 
    Example: Sometimes customers will choose Roofing - then I want the pertinent information to display. But if customers choose Roofing and Siding  - then I want both information to show. I have no problem doing this part. The problem I have is removing the dead space on EFP when I choose only 1 of those options. I hope that makes sense. I read some others code on this but I keep getting an error . Its telling me at the end of my code I have a yellow box "Expecting bool, text"  Any suggestions?

    List("<br />",
    If(Trim([Shingled Roofing Commercial])<>"","Shingled" & [Shingled Roofing Commercial],
    If(Trim([Flat Roofing Comm])<>"", "Flat Roof" & [Flat Roofing Comm],
    If(Trim([Misc Comm])<>"","Misc" & [Misc Comm],
    If(Trim([Gutters Comm])<>"","Gutter" & [Gutters Comm],
    If(Trim([Window Comm])<>"", "Window" & [Window Comm],


  • 2.  RE: Creating if statements for rich text fields for exact forms plus

    Posted 02-01-2019 16:22
    I think you need a closing parentheses at the end of each line, like so:

    List("<br />",
    If(Trim([Shingled Roofing Commercial])<>"","Shingled" & [Shingled Roofing Commercial]),
    If(Trim([Flat Roofing Comm])<>"", "Flat Roof" & [Flat Roofing Comm]),
    ..........


  • 3.  RE: Creating if statements for rich text fields for exact forms plus

    Posted 02-01-2019 16:27
    thanks Dan so tired  u were completely right