Conditional Show/Hide Fields in Layout

[John Stephen]

I think I have a way to do this but thought there might be a cleaner way. This is pretty simple concept. I have an invoice layout and only want to show data related to discounts if the order has had a discount applied. So if the person paid full price, I don't want to remind them that there could have been a discount by displaying a "discount" field title and empty field on their invoice. So the field title and field content should display only if the order has a discount applied, otherwise the space allocated for this information is blank. If anyone has done this and is willing to share the results, I would appreciate it.

[andygaunt]

Hi --

Create a field label in a calculation instead of using text on the layout

Case (

Not IsEmpty (Your Order discount field), "Discount"

)

This way, if your discount field is blank then the label will not be there.

Make sure you turn off Allow Entry into Field from the Format > Field Format menu by clicking on the field in Layout mode.

HTH