Creating if statements for rich text fields for exact forms plus

  • 0
  • 1
  • Question
  • Updated 2 months ago
  • Answered
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],
Photo of Joshua

Joshua

  • 84 Points 75 badge 2x thumb

Posted 2 months ago

  • 0
  • 1
Photo of Dan

Dan

  • 1,400 Points 1k badge 2x thumb
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]),
..........
Photo of Joshua

Joshua

  • 84 Points 75 badge 2x thumb
thanks Dan so tired  u were completely right