nleon307

In case anyone sees this in the future... Visually, everything worked how I needed it to. I had probelms getting the relationship to filter the totals correctly in the portal so I changed the calculations to use the ExecuteSQL function to have more control over the relationships and the report works fine and looks like some subsummary parts are open while others are closed.

While it's going to take a while to get the relationships and calculations right, I deleted the subcategory subsummary part and added a filtered portal to the main subsummary part that slides up and resizes enclosing part. Visually it works, I just need to fight with the calculations to get the report right again.

Hello I have a subsummary report with a main group and subcategories. Some main groups only have one subcategory which is the same as the main group. Other main groups have up to 4 subcategories. Is there a way to hide the subcategory line for the groups with only one subcategory which is the same as the main group? If it were a pivot table in Excel I would just close the row. Thank you

If you're looking to use longitude and latitude in the web address instead of the address, take a look at: https://support.google.com/maps/answer/18539?hl=en If you're trying to get longitude and latitude from the web viewer, it looks like it's in the url after "Click to see this area on Google Maps" in the source code. Sample below: <a title="Click to see this area on Google Maps" href="https://maps.google.com/maps?source=embed&q=87+E+42nd+St,+New+York,+NY,+10017&iwloc=0&ll=40.756896,-73.977449&spn=0.014011,0.027466&z=16&vpsrc=6&oi=map_misc&ct=api_logo" target="_blank"> The latitude and longitude are: 40.756896,-73.977449

Interesting solution. I'll have to give it a try for future use. For the specific report I created, for how users have started using the report, capturing the sort fields seems less important than it did when I created it. They're usually only picking one field and it's obvious which one it is. Thanks

Hello Is it possible to capture the fields sorted by in a variable? I have a sub-summary report with multiple sub-summary parts. The script will be set to Sort Records with dialog so users can take out or rearrange the order of the fields. I'd like to capture the actual sort order and use the variable as a header in the report. I see sort state as a get function, but don't see a get function for sorted fields. Is it possible to capture? Thank you.

Is there an easy way to use the plug in to track if a response was received to an email sent using the plugin?

That's what I've done in the past, but since it seemed to be part of the theme, I was wondering if it could be accessed through the CSS or XML.

Hello How can you access the print layout in the style sheet or XML file? This may be a surprise but I don't want the theme color or image to print in the background. I understand the basics of modifying the style sheet and creating custom themes but do not see where modes are differentiated. Thank you

I just ran a test in FMP 11 and the portal is included in Preview-Copy. Is this a FMP 12 with Windows 7 bug?

Attached please find an example database, Copy of Preview and actual screenshot. For me it seems to be all databases that do not pick up the portal data if I copy in Preview mode. Is this true for everyone? PortalScreenshotExample.zip

To answer: "I ended up having it go to the same record number in the second window" ..and you did this, how? To explain what I'm doing a little, the second window is a Calculator that allows a user to click on fields in the first window, sets a global text field to add the field name so the user can build calculations. A second field then evaluates the calculation for each record. This calculator floats as the top window until closed. Navigation is only in the first window, but there's nothing stopping a user from performing a find or sorting in the second window. What I did to sync the windows: When the second window is launched, a variable is set to indicate it is open. The main window has an OnRecordLoad script trigger that checks for the variable to see if the second window is open. If so, Item number (key field) and Record number variables are set. The second window then goes to the same record number as the main window and checks to make sure the item number is the same as the main window. If the Item number is not the same, the second window closes and reopens. In the case that a user performs a find or sort in the second window, I added a sync button on the second window.

I ended up having it go to the same record number in the second window, checking to make sure it is still on the same record ID and if not it reopens the second window.

Yes it previews fine and prints fine. It's just copying the page from preview mode that doesnt pick up the portals.

When you preview you can copy to grab a screenshot of the page being previewed. My portals aren't copying. Is that just how it works?

Floating Document Window is a New Window option in FMP 12 that keeps the new window on top. I'll give your suggestion a try, thanks. Any advice on how to keep the two windows on the same record?

Thank you, I will look into it more. Pulling the data into InDesign definitely sounds like a better solution.

Ahhh. Thank you for the response. I just wasn't getting that one.

Hello What is the best way to keep a floating document window on the same record as it's launch window when both windows are based on the same table? Also, is there any way to get the Floating Document Window to work in an expected way with Windows 7? It does not seem to be possible to work in both the floating window and the main window with the main window maximized and the floating window kept to specific dimensions. Thank you

thanks a lot for the advice when I was looking at the FDF file, I saw the coordinates and was afraid I would need to pull them somehow to do this. I will take a look at the book. Thank you

Is it possible to use Scriptmaster with iText to add highlight or comment annotations into a PDF from Filemaker?

Hello I need to add sales rank data (stored in Filemaker) into a PDF catalog. I'm wondering if there's a Filemaker plugin that can handle this or if this needs to be done completely in Acrobat (or another PDF software) or in In Design where the PDF is originating. My guess is that the sales rank data would either be a comment or possibly a hyperlinked popup. I currently have the following data in Filemaker: Item number, Catalog page number, Sales rank The PDF Catalog has several items on each page with both text and images in different places on each page. Is there a way to associate the sales rank data with the item number text on the PDF as either a comment or hyperlinked popup using a plugin? If not is there a plugin to import the filemaker data as page comments? Thanks a lot Nina **It looks like highlights with comments in them look/act the way I would like, but I still need to get them there.

I hadn't thought of that, but that's a great idea. Thanks

So with field level access, they would see "Not Authorized" (I cant remember exactly what it says) where the fields are they do not have access to, right? If it's a lot of fields, mainly on specific tabs, is field level access usually used with the intercepted click or are different layouts used instead?

Is there a way to do tab level security other than to put a script on a tab to check security privileges?