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

Help with Calculation - How to remove a blank space if no record in between


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

Recommended Posts

Posted

Hi All,

I am wander how can I write a case statement for something that I don't want to show the return blank space if no record in one of the following field. Any help will be good. Thank you in advance.

<>

<>

<>

<>

<>

Posted

Select the fields in Layout Mode, Main Menu >> Format >> Slide/Printing. Then Select the Slide Up.

This will only be seen in Priview Mode and when printed.

HTH

Lee

Posted

Hi Lee,

Thank you for the help. I guess I was not that clear on the post. What I am trying use the send e-mail from Filemaker but I need to have a calculation if in case I have an unused field inserts still cause a carriage return, so we have all 

this blank space before the paragraph. How can I write a calculation to avoid the blank space if in case no data into the field. Any help will be appreciated. Thank you in advance.

PhP

Posted

A simple method:

Case ( not IsEmpty ( MondayTODO ) ; MondayTODO & ¶ ) &

Case ( not IsEmpty ( TuesdayTODO ) ; TuesdayTODO & ¶ ) &

...

Case ( not IsEmpty ( FridayTODO ) ; FridayTODO & ¶ )

A more sophisticated method can be found here.

Posted

And if we wait until the person post their calculation, we can be more specific.

This topic is 6529 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.