Jump to content

hide if empty


This topic is 5601 days old. Please don't post here. Open a new topic instead.

Recommended Posts

I have a layout called invoice which I obviously use to invoice people hoever some people have an agent and some people don't so is it possible to hide a field and text label i.e. if agent = null don't show the field on the layout?

Link to comment
Share on other sites

Create a field to check if the agent field is empty, such as,

Agent_status = If (not IsEmpty(invoice_Agent);1;0)

Have another field that is auto-enter with a value of "1" or a global field. I will call this field, CommonOne. If you use a global field, set it to "1" before hosting.

Create a self relationship and relate Agent_Status to CommonOne. In the invoice table, use a poral to cover the field you want to toggle.

Invoice.zip

Link to comment
Share on other sites

You don't need the 1 ; 0.

IsEmpty() is a boolean test that returns 1 if true and 0 if its empty

What your effectively typing if you use the If Function is:

If(not IsEmpty() ; If not IsEmpty() returns 1... 1 ; If not IsEmpty() returns 0... 0 )

As opposed to not IsEmpty()

Link to comment
Share on other sites

This topic is 5601 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.