2 of 2 people found this helpful
You only need
IsEmpty ( Table::container )
If ( someExpressionIsTrue ; 1 ; 0 )
is a redundant form, because that expression already is itself True or False, i.e. 1 or 0, and returns that value without the conditional clause.
You may want to consider using a related table instead of numbered field. That would not only solve this problem by simply making it irrelevant (you create related records only on demand - what doesn't exist need not be hidden), but also other issues you may encounter down the road (meta data, reporting, aggregating ...)
Ok great - thanks you. I will look into the related table idea.
One more question about hiding things - I have a tab control which I am using on one of my layouts. Is it possible to hide one of the tabs on there is a specified field is empty?
No ... but you could use a calculation to adapt the tab title, and use an object name and a script trigger (OnPanelSwitch) to prevent users from entering the tab "If ..."
And possibly there is a totally different approach, but we coulnd't tell from just the fact that you have a tab control ...
1 of 1 people found this helpful
In place of a tab control, put a Slide control on your layout with buttons set up as your tab labels. Each Slide control panel then needs to be given an object name in the inspector and the buttons just use Go to Object to bring a slide panel into view. To hide your panel, you now just hide the button for it.