Jump to content
Sign in to follow this  
tanbog

Expanding a field when printing.

Recommended Posts

Hello,

 

I am in a bit of a pickle here. I have a small database implemented in FM11 that records information about clients and some notes made by staff. I have to add a print out feature that produces a print out of certain information from the database, however, the document produced must also allow for additional hand written notes to be written - it will later be used in an interview and/or filed in a paper file.

 

The first page of the document is just information from database so is fine. Page 2 however consists primarily of 2 boxes (two different sets of notes) and a small section at the bottom for the signature of a supervisor and filing information. 

 

Either/both of the fields the boxes are populated from could be empty, have a small amount of text or have a large amount of text.  Both boxes need to have a minimum size below which they will not shrink. Below is a - pretty crummy - attempt to draw what the print layout of page two should look like. At a minimum this page should always fill a single A4 page. and the supervisor section should always be at the bottom of the page.

 

No Text or                

a small amount         Lots of text.

(minimum size)         (any reasonable length)     

 ______                    ______

|            |                  |            |

|______|                  |            |  

_______                  |______|  

|            |                  _______

|            |                  |            |

|______|                  |            |

++++ ++                   |            |

                                |______|

                                ++++ ++

 

Top and bottom boxes should be independent. One could stay minimum size while the other grew many times normal size.

If the text in either box is too big for the minimum size then it is ok to overflow onto a third (or more) page, otherwise it should  always reach to the bottom of page 2. 

 

I have played around with several solutions but nothing works very well. My basic idea has been to make a dedicated print layout with mostly merge fields from the relevant table. 

 

Sliding up has not worked as needed as;

  1. I still need to set a maximum size and shrink down from it, which I don't really want to do and
  2. there appears to be no way to set a minimum size for a field sliding up.
  3. Fields with no content appear to completely disappear.. 

In summary what I want to do is have a print layout with two boxes that have:

  1. A minimum size
  2. Expand to accommodate large amounts of text

 

I feel like this should be easy...

 

Any ideas?

 

 

 

 

Share this post


Link to post
Share on other sites

FileMaker does not expand fields. You need to design your print layout to accommodate the field with the most content, and then use the slide up feature shrink the objects up accommodate your print look.

 

Start by reading this help page on Removing blank spaces

  • Like 1

Share this post


Link to post
Share on other sites

 

 

You need to design your print layout to accommodate the field with the most content, and then use the slide up feature shrink the objects up accommodate your print look.

 

I have no flexibility in the design. It is based on a paper system and I have zero chance of changing it.

 

The only way sliding up will work is if there is a way to set a minimum size. That I could work with.

 

An idea that comes to mind at the moment is to insert non-printing characters or some other nonsense into any field that is not the minimum length but that strikes me as a silly solution and I would love to hear better ideas.

Share this post


Link to post
Share on other sites

Why don't you let these "boxes" shrink to nothing if necessary, and use another object to limit the sliding of the subsequent object / containing part?

Share this post


Link to post
Share on other sites

 

 

Why don't you let these "boxes" shrink to nothing if necessary, and use another object to limit the sliding of the subsequent object / containing part?

 

Could you possibly give me an example?

 

I did toy with some line segments at some point. I "drew" on the sides of the box. But the vertical lines do not shrink up which leaves a box which is always maximum size.

Share this post


Link to post
Share on other sites

Ah; thanks for that - does the slide only happen when you preview?

Share this post


Link to post
Share on other sites

Ah; thanks for that - does the slide only happen when you preview?

 

Yes - and that's the kind of question you should lookup in the help.  :grad:

Share this post


Link to post
Share on other sites

Se if this helps:

 

attachicon.gifSlideLimit.fp7.zip

 

That works great, thanks!

 

Only one -  probably dumb - question though, how do I stop the blank space created at the bottom of the document when all the content slides up from being printed?

Share this post


Link to post
Share on other sites
how do I stop the blank space created at the bottom of the document when all the content slides up from being printed?

 

If I understand correctly, you want to turn on the "Also resize enclosing part" option for all sliding objects.

  • Like 1

Share this post


Link to post
Share on other sites

If I understand correctly, you want to turn on the "Also resize enclosing part" option for all sliding objects.

 

AH thanks again. I missed the tick box on a field at the bottom of the page.

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

  • Similar Content

    • By Jon David Wardlow Petrie
      Hello My name is Jon Petrie and I am in the same boat as you are and I am trying to setup the samthing as you are with Filemaker To keep track of my bank transactions.
    • By Calvin Tomm
      In list view I want to be able to "grab" an object so I can move the record up or down in the found set. Is there a way to do this? It would be just like how an item on an list in an iPhone gets moved up or down. For example, on a play list in Music, I can change the order of songs to be played.
      Also, I would like to have this capability when I move my solution over to FileMaker Go
      Thanks!
    • By amerioca
      Hi everybody,
       
      I recently amended a db from an old Lynda course, controlling shore excursions for river cruise ships. For my limited expertise (I am still a rookie at the very best) the construction is somewhat complex as there is many vessels, different routes, different charterers and consequently different shore excursion programs and prices. In some cases the shore excursion program of different vessels and operators is similar but not the same and so on.
      I have 7 different tables partly related (pls see graph attached):
       
      For every journey ::customers and ::trip are assigned a tour code and date (“tour code” is not unique as journeys repeat themselves during the season, “Tour Code” in conjunction with “Date” is unique)
      Every tour operator/vessel has many trips on every journey. All table occurences and fields are uniquely defined by unique id.
      Now I want to create an opening layout reflecting all relevant cruise information such as passenger list from ::customer and ::trip (shore excursions) for the specific journey, as well as other information in text fields.
      But I seem to be unable to get the right relationship and layout setups together. I tried all possible relations and layout setup combination but nothing worked so far.  
      On the same layout I was able to either retrieve the passenger list from ::customer for each journey or the offered shore excursion (trip) list from ::trip  but not both together on one layout.
       
      What is it, I am doing wrong? Any ideas are appreciated

    • By Gismo12
      Hi All,
      I need to copy one field only from one layout (+- 200 records) and past all those records from that field into another layout.
      I have tried a few commands but does not produce the required result.
      Please could you advise on a script?
    • By V!ncent
      Hi there,
      I have a topic that can take the chosen value in a vertical radio buttons list.
      But some values in this list have a description so long that it can not be displayed on one line. So I need a "return to line" in the list of radio buttons. (see attached photo)
      How to do ?
      Thank you for your wise advice.
      V!ncent

  • Who Viewed the Topic

    1 member has viewed this topic:
    Bob Minteer 
×
×
  • Create New...

Important Information

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