Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

How to hide field name if field is empty?


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

Recommended Posts

Posted

Hello,

I am trying to figure out this:

I have database with lots of people. When I am printing list of those people, in each person i have two field for telephone and two for mobile, like this:

Tel1: 111 111 111

Tel2: 111 222 222

Mobile 1: 123 123 123

Mobile 2: 321 321 321

what I would like to do, is to hide field name (Tel1, Tel2, Mobile 1, Mobile2) if the field with that telephone number is empty. Because now, my printed list seems like this:

Tel1: 111 111 111

Tel2: 111 222 222

Mobile 1: 123 123 123

Mobile 2: 321 321 321

--------

Tel1: 111 111 111

Tel2:

Mobile 1: 123 123 123

Mobile 2:

Thank you for any suggestions.

Posted

The first approach might be to create the labels into calculations

label_tel2 (text) = if( isempty(tel2) ; "tel2" )

but I recommend to create a new table for all those numbers and place a portal on the layout with the possibility to enter every number of numbers of any type.

-jens

This topic is 6601 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
×
×
  • Create New...

Important Information

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