Zuke

Represent page breaks.

Ok here is my problem. I have created a summary report that pulls together weekly reports for projects under a specific office of work. SO each report generated could be specific to a set area. In the report layout i set it up with a title header for the cover sheet, a sub summary section which shows each sub- group, a sub summary section that has all the project specific text and report, and then the body which has pictures and captions for the project. The pictures and captions are repetitions 1-8 of the same fields. So it is supposed to look like this ------------- title page(area name) Title Header ------------- -Sub area Sub Summary ------------- Project data info Sub Summary ------------- Picture Caption Picture[2] Caption [2] --------------- Picture [3] Caption[3[ Body Picture [4] Caption [4] --------------- Picture[5] Caption[5] picture[6] caption[6] The trouble I am having is if a user only enters, say 4 pictures instead of 8, I will have 2 blank pages that need to be removed. I didnt have much luck in sliding up cause i had pictures on both sides of a page break and the page layout was not consistent from one report to the next. I need to find a way to remove the blank page that occurs if there is less than 8 pictures with the report. Any help would be appreciated.

Hi all, I am trying to "insert from device" a picture into a container field that is inside a slider. There are 8 repetitions of that container used to store photos. I don't want to go through the filemaker go insert menu because i want to restrict the size of the pictures taken on a mobile device to medium. I need a script to get the active repetition number for the container field and then insert from device into that specific repetition. Part of the challenge seems to be the containers placed on a slide control. I have tried several scripts but cant get the repetition number to work correctly. Its been years since writing scripts in filemaker and i am probably missing the obvious but any help would be appreciated DLC_Weekly_Reports.fmp12

Ok I think I have this figured out, although not fully tested. Here is the solution so far. I created 9 single row portals on the page, each one starting at the initial row 1 and having just one row. I filtered the portals using a solution i found here http://www.supportgroup.com/blog/portals-without-scrollbars/ which is the easiest solution I have found so far. I created the following script which triggers whenever a room is selected from the left hand selection portal: The $$PStart variables control what the initial record will be show when a new room selection is made. This is what will control the portals for the paged control. Sorry but i haven't gotten that script all written, but I dont see that being an issue yet. I have manually changed the script above to different initial portal rows and it seems to function fine but will withhold the cheers until i get the navigation built. The key to the solution was the the filter applied to each portal. Let ( subset=MiddleValues ( $$IDs; $$P2Start; 1 ) ; FilterValues ( subset ; Specifications::Spec ID ) ≠ "" ) So far so good as the filter is doing what i wanted. Script1.tiff

Lee, It seems that i was not able to download the files. Thanks for the suggestions, I solved question 2 using a found count calculation. I guess maybe a better way to ask the questions 1 is: "is there a way to change the displayed related record in a single row portal?".

Hello all, I have been trying to create a layout with a Portal interface that mimics a typical online shopping interface. I have created a layout that has a 9x9 grid of single row portals to display the possible buyer choices. Each single row portal has the initial row starting at the next incremental value (1,2,3,4 and so on). This works great except when the possible choices are less than nine but causes the following problems when the choices are more than the 9 portals. 1. I need to create a way to to select the next set of possible choices for when the possible choices exceed 9. I was planning to use arrow buttons on the bottom to scroll to the next set of items. I have tried using Go to portal row to change the displayed record but since there is only one row that didn't work. There doesn't seem to be a way to change the initial portal row by a script. 2. I need to figure out a way to calculate the total number of records that match the filtered result so the navigation buttons will only work (or show) when there are more than 9 choices. 3. Was hoping to find a away to hide portals when there is no record present. So if there were 6 options available the remaining three portals would be hidden. I have attached a screen shot of layout. Hoping i can get some help or direction on where to begin. Thanks portal.tiff