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],
Question
Creating if statements for rich text fields for exact forms plus
This topic has been closed for replies.
Sign up
Already have an account? Login
Login to the community
Login with Quickbase US – quickbase.com Login with Quickbase EU – quickbase.eu
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.