Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About Mari

  • Rank
  1. 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.
  2. Thank you Lee and I will try this.
  3. 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.
  4. 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 )
  5. 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
  6. 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
  7. 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
  8. 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
  9. 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.
  10. 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...
  11. Thank you very much Lee for your help.
  12. Mari

    solutions wanted A4 Layout ready to print

    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
  • Create New...

Important Information

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