Skip to main content
Question

Creating if statements for rich text fields for exact forms plus

  • February 1, 2019
  • 0 replies
  • 81 views

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],
This topic has been closed for replies.

  • Registered
  • February 1, 2019
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]),
..........

  • Author
  • Registered
  • February 1, 2019
thanks Dan so tired  u were completely right