Forum Discussion

JoshuaSmith's avatar
JoshuaSmith
Qrew Trainee
7 years ago

Creating if statements for rich text fields for exact forms plus

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],
Formulas and functions
  • DanLadner1's avatar
    DanLadner1
    Qrew Trainee
    7 years ago
    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]),
    ..........