We have reset all users FileMaker related profile fields. Please take the opportunity to update your information,  this will provide background to members whom read your posts. Click here.

Jump to content
Mari

A4 Layout ready to print

Recommended Posts

Mari    0

Hi There, 

I am creating a Filemaker Data base to help me with my work flow. 

I would like to create A4 Layout but I can't find an easy option how to find it on FMP 13. 

I can't find an easy way to create a template with size selection for Header - Body & footer and make sure that it will be printed on A4 Size. 

Does anyone can help? 

Many thanks, 

Mari

Share this post


Link to post
Share on other sites
Lee Smith    142

Hi Mari,

Under File, choose Page Setup, and select A4. Then View >> Page Margins.

Is this what you are after?

Share this post


Link to post
Share on other sites
Mari    0

Hi Lee, 

Thank you for your help. I found it but it's more about being able to lock the size page including: Header, Body & Footer parts and to make sure it will print as I wish.

As I am modifying an old database I am trying to change some current setup which do not fit my needs and I am having difficulties to find these options.

Example:

1. One of the layout page can't be printed in Portrait (instead of Landscape) & even if I change it in "Print" > the database is still saving the pdf file in Landscape.... and if I change the layout setting into x2 or x1 column FMP doesn't want to accept it if one object (an extending compiling list) is too big but if I change the size I don't think all my datas will be printed.

2. I can't copy/paste the script of the old database into a new one layout by layout... I think this option could be easier for me but it looks like I have to change my original file directly.

 

I though File Maker Pro would be an intuitive software but I am struggling so much.

I am using FMP 13, maybe the newer version is easier/better...

Share this post


Link to post
Share on other sites
Mari    0

Hoorah!!!!!!!!!!! 

I found it for the printing issue 1. > So to change from landscape to portrait to print, you need to:

1. Click on the button (that has been made to print the document) 

2. "Perform script" > "Specify" > Click on the tiny wheel > Select: "Edit..." > Select: "Print Setup" then Double click on it & select Landscape or Portrait. 

 

Share this post


Link to post
Share on other sites
Lee Smith    142

Hi Mari,

Here is a trick that goes way back in FileMaker (circa FileMaker 2).

There are functions that FileMaker will remember if you do the function manually, i.e. Print is one. First, Perform a Print set up the way you want it, and them immediately create a script using the Print step. It will use the setup you just used in the manual print.

Lee

Share this post


Link to post
Share on other sites
Mari    0

Thank you Lee. 

I have progressed into the making of my Database since yesterday. 

However, does anyone know how to insert page number "Page 1 of 2"  at the bottom or the top of a layout?

I have a "portal" element prior to it & if I add anything below it creates automatically x2 pages ;(

Thank you for your help

Share this post


Link to post
Share on other sites
Mari    0

Hi Lee, 

Thank you very much and it works but it's counting all the records present within the layout in the database instead of counting the number of page present in the current layout/record. 

Does there is a formula to add to make it work?

I'm sure it's something easy to do but know how to do it.

At the moment this is what have got:

Formula: Pg. {{PageNumber}} / {{FoundCount}}

Perform script:

Enter preview mode

Go to record/Request/Page [first]

Set variable [$pp;:Value:Get (PageNumber)}

Go to record/Request/Page [last]

Pause/resume script [indefinitely]

 

Thank you

Share this post


Link to post
Share on other sites
comment    1,357
46 minutes ago, Mari said:

Go to record/Request/Page [first]

Set variable [$pp;:Value:Get (PageNumber)}

If you set the variable while you're on the first page, it will always have the value of 1.

You should read the KB article Lee pointed to.

 

Edited by comment

Share this post


Link to post
Share on other sites
Mari    0

Hi there, 

So.... I am still a bit struggling with the page numbers so I decided to go back to the start and to do it steps by steps. 

As per the File Maker help and your advices, I need to "set a variable" but how do I do that?

Where do I physically click to "set a variable" (prior to: "insert merge variable")?

(see this link: http://www.filemaker.com/help/13/fmp/en/html/create_layout.9.34.html#1064499)

I don't find it very clear... 

Thank you so much in advance.

Mari

Share this post


Link to post
Share on other sites
comment    1,357

It's a script step. I thought you already had it in your script (at least that's what your previous post shows). You only need to change the value part.

Edited by comment

Share this post


Link to post
Share on other sites
Lee Smith    142

Attach a copy of your script - it is easy - and then paste it in a Reply.

C:PScript in 13.png

Share this post


Link to post
Share on other sites
Mari    0

Hi there, 

Thank you for your prompt reply and thank you Lee but the following was already typed when I saw your answer above.

 

I would like to get the page numbers on each layout with the correct total of page for each layout (instead of total record number).

For instance:

Layout 1: has 2 pages, once printed it will be written:

"Page 1 of 2" then "Page 2 of 2"

Layout 2 has only 1 page once printed it will be written:

"Page 1 of 1"

 

So here it's what I have done:

1. Clicked on "Edit Layout"

2. Then "Insert" > "Merge Variable" 

3. Named variable: "Page {{PageNumber}} of <<$pp>>"

4. Right click > "Button Setup" > "Perform Script" > "Specify"

5. "+" > "New" then Script Name: "<<$pp>>"

6. Then I create the following script:

  • Enter Preview Mode [ ]
  • Go to Record/Request/Page [First]
  • Set Variable [$pp; Value:Get (PageNumber)]
  • Go to Layout [original layout]
  • Go to Record/Request/Page [Last]
  • Pause/Resume Script [Indefinitely]

Then I click on "OK" - I make sure the script selected is the good one then I click on "OK" again.

7. I exit "Layout mode" and I can see where I have inserted the "Merge variable" the following: "Page ? of       "

8. When I put the arrow/mouse over it + click, I enter the "Preview mode"

9. then I can see on the 1st page of my Layout 1: "Page 1 of 1"

and on my Layout 2: "Page 2 of 1" > which is incorrect. It should be: "Page 1 of 1"

The number of page should be reset/different for each layout.

10. If I click on one of my button, previously created to get a Pdf of one of my layout the following appears: "Page 1 of      " 

The end is blank.

 

11. OPTION 2:

I have tried something else -

If I write this text: "Pg. {{PageNumber}} / {{FoundCount}}"

Without using any formula it will do the following on a Layout which has only 2 pages:

On my page 1  it will be written: "Pg. 1 / 3"

And on my page 2 it will be written: "Pg. 2 / 3"

The number "3" = the number of Record I have for this type of layouts. 

I would like to change/get the formula when "FoundCount" equal the total of pages on each layout. 

Thank you so much for your help and I'm sorry about this long explanation. I hope it all makes sense. It is so easy to do in word and excel. At the end: I will master Filemaker Pro :) !

And Here is the pic. 

I think I have to ask the software to look at the layout instead of "record".

Thank you

Getting page num.png

Share this post


Link to post
Share on other sites
comment    1,357

We are going in a circle here. You need to change your script so that it does:

Go to Layout [ **your print layout** ] 
Enter Preview Mode [ ]
Go to Record/Request/Page [Last]
Set Variable [$pp; Value:Get (PageNumber)]
Go to Record/Request/Page [First]
Pause/Resume Script [Indefinitely]

This is assuming you want the same script to put user on page 1 in Preview mode. Note also that the $pp variable will be deleted once the script runs out. If you want to retain it, rename it to $$pp (and adjust the text on the layout accordingly).

With regard to the text on the layout: when you click into it (in Layout mode), you should see exactly this:

Page {{PageNumber}} of <<$pp>>

--

Having written all this, I now find that the help has the same script and merged variables example:
http://www.filemaker.com/help/15/fmp/en/#page/FMP_Help%2Finserting-merge-variables-on-layout.html

 

 

Edited by comment

Share this post


Link to post
Share on other sites
Mari    0

Hi there, 

Thank you now the formula works but when I try to print it, it appears like this: "Page 1 of     "

(the total number of page doesn't appear :(

Share this post


Link to post
Share on other sites
comment    1,357
7 minutes ago, Mari said:

when I try to print it, it appears like this: "Page 1 of     "

I suspect I already answered this:

36 minutes ago, comment said:

Note also that the $pp variable will be deleted once the script runs out. If you want to retain it, rename it to $$pp (and adjust the text on the layout accordingly).

 

Share this post


Link to post
Share on other sites
Mari    0

I understood it and it's what I've done, I have followed your instruction with <<$$pp>> but the printing issue is there.

Thank you.

Share this post


Link to post
Share on other sites
Lee Smith    142

You have the Record Request Steps backwards.

Go to Layout [The layout you want to print]
Enter Preview Mode [ ]
Go to Record / Request / Page [Last]
Set Field [Table::Page Count, Get ( PageNumber )]
Go to Record / Request / Page [First]
Pause/Resume Script [Indefinitely

 

Have you used the Debugger and Data Viewer to follow this?

Share this post


Link to post
Share on other sites
Lee Smith    142

This was pointed out in the Link I post here,

On August 24, 2016 at 10:32 AM, Lee Smith said:

and by comment 

Quote

You need to change your script so that it does:

and then

Also, my last post, 

1 hour ago, Lee Smith said:

Attach a copy of your script - it is easy - and then paste it in a Reply.

I didn’t want the Screen Shot, I wanted the Text.

Share this post


Link to post
Share on other sites
Mari    0

Hi Lee,

I wanted to copy and paste but I am unable to do it on Filemaker Pro 13. The script window do not look like the one you have and I can't copy/paste into a text editor.

Share this post


Link to post
Share on other sites
Lee Smith    142

Wow, that’s weird?

Anyway, you can always print a script to Preview and then copy that. Don’t bother doing that now though.

p.s

Sorry, I guess the button came as part of a plugins -  Sorry. 

Edited by Lee Smith
p.s.

Share this post


Link to post
Share on other sites
tdub808    0
On 9/6/2016 at 10:11 AM, Lee Smith said:

You have the Record Request Steps backwards.

Go to Layout [The layout you want to print]
Enter Preview Mode [ ]
Go to Record / Request / Page [Last]
Set Field [Table::Page Count, Get ( PageNumber )]
Go to Record / Request / Page [First]
Pause/Resume Script [Indefinitely

 

Have you used the Debugger and Data Viewer to follow this?

In case someone else (like myself) run into the issue of Preview Mode or Prints only showing the first page number on all the pages. i.e. Page 1 of 15 on every single page.

Solution: Uncheck "Restart page numbers after each occurrence" in Layout Mode --> Double click on the footer part or tab.

Now it should show Page 1 of 15 on the first page, Page 2 of 15 on the second page, and so on.

Cheers!

 

Share this post


Link to post
Share on other sites

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


  • Similar Content

    • By AlesD
      Hello,
      I would like to ask question for which I didn't find answer. I have several filemaker dbs which differs only by data entered. All tables and fields are same. My question is if it's somehow possible share layout design across all those databases because occasionally I need to modify that layout. Change it in all dbs could be time consuming. Of course I can have empty "design db" where I could re-import data after layout change but again it could be time consuming too.
      Also I'm wondering if is possible to use field name (in layout) without any table name and table would be used relative by table defined in layout? (Shows records from)
       
      Thank you
       
    • By surgite71
      Greetings and thanks for giving this a look!

      I am rebuilding a client's database that was done formerly in PHP. I'm now using FM 16 Pro Advanced. There is one print layout I'm having trouble recreating.
      There are a number of data fields the realtors fill out...some get filled in, other times some don't. In addition it needs to print the name of the data field then the data itself, so for instance "Construction  Stick Built". I've figured out how to go through and print only the fields (and their labels) that have data. The issue I have is with the spacing in the columns.
      In the attached photo, you can see that each label/data line is neatly organized in a column so that the space between the label and the data is consistent all the way down the column. It's not centered, and it's not justified...it calculates for each row of data, how much space is needed in that row to line everything up.
      Would I need to determine how wide the column is, and then calculate how long the combo of the field name and data is (with that nice separator space in between them) and then use that to space everything? Seems like a lot of calculations going on but maybe that's what needs done?

      I also need to figure out if the data will require it being in 1 column or using a 2 column like the one in the picture. I believe I can figure that out...it's this 2-column alignment/spacing that's got me tied up.
       
      Thanks!

    • By Dimitrios
      Hello,
      I am not sure if this is a tip, or if it is already known.
      Anyway it has a practical value for me so I thought I post it.
      Sometimes I need to present data in a layout with several sub-summary parts and usually no body parts
      I find it good interface, to give the user the ability to click on the only visible sub-summary part and reveal the next part in the hierarchy, and so on...
      Thus expanding and collapsing the list by clicking on the headers.
      From what I read in the forums the standard technique for this is to have a global variable to store whether part X is expanded or not.
      I don't like that method very much so I thought of an alternative.
      Layout  Example Structure
      Sub-Summary Part1   (based on COUNTRIES::Name)
      Sub-Summary Part2   (based on COUNTRIES::CityID)
      Sub-Summary Part3   (based on CITIES::SalesmanID)
      To the right of the sub-summary part, just off screen we put an instance of the field we are sub-summarizing by. 
      For example, inline with sub-summary Part1 we put an instance of the field COUNTRIES::Name and we name the Object as "Part1"
       
      Now if the sub-summary part is visible using the following :
      GetLayoutObjectAttribute ( "Part1";"source" ) will give us "COUNTRIES::NAME"
      or if the sub-summary part is not visible will give us error 102 (Field is missing)
       
      By looping with a $counter variable through all sub-summary parts (1....n) 
      we can get a list of the visible sub-summary parts (the fields they are based on)
      Then we can use this information to sort the records anyway we want to.
       
      That's it!
      I think it would be nice if someone thought a way to have the list sorted in the way the parts are presented.
      Thanks, Dimitrios
    • By 123
      Hey,
      I want to use the same header on all my layouts in FileMaker Pro 15 Advanced but I can't seem to find a way to accomplish it. I read on Google and other forums that there is no way to do it, however the posts I found are all at least a year or two old. Did they add a way to do it in FileMaker 15 or do I still need to duplicate a layout to get the same header on a different one?
      Thanks in advance,
      Mike
×