I’m pretty new with using Filemaker, but still I built a solution that fits pretty all my needs (for now…)
I’m still experiencing one big problem with my solution for which I would need help.
Here’s the context : I run a little company. We receive financial reports every quarter.
All quarterly reports ( Excel file or csv file) have the exact same form.
I then created a layout based on the table created when importing the csv that works properly.
My need: as I’m to receive a new financial report on next quarters (Q12018, Q22018, Q32018 etc.), I would like to pull the new data from my Main layout.
Is there a way of having a layout pull the data from the new table (actually whatever table) to be created each time I’ll be importing a new Financial Report without getting rid of the original data (which I would like to keep in place, for obvious reasons)? Let’s say from a pull down?
Thank you very much for your help and don’t hesitate to get back to me if my explanations aren’t clear enough.
I'd get some problems with date formats after installing FMS 15, and I'm trying to solve it by importing to a clone of the original database. But two tables has no layouts and I can't find a way to import these tables without making a layout in the clone or adding a table when importing. The last seems to be the simplest, but how will the relationships behave?
How can I extract content from sub summary layout objects using? https://fmhelp.filemaker.com/help/16/fmp/en/index.html#page/FMP_Help/getlayoutobjectattribute.html
I'm able to grab the content from the first subsummary, not the remaining however.
set field( output; GetLayoutObjectAttribute( 'header', 'content' ) & GetLayoutObjectAttribute( 'row', 'content' ) & GetLayoutObjectAttribute( 'footer', 'content' ) ) works fine, the bad thing is that only row 1 finds its way to the output-field.
By Bobby Bradley
I have a layout for printing on a letterhead and have inserted an image file as the Background Image to serve as the letterhead. Printing and Save to PDF work as expected, but for the life of me I cannot get the background image to display correctly in Preview mode.
Not displaying correctly in Preview mode is not terrible except, when the client does a print preview and it doesn't line up, there will be questions...even though it print correctly.
Basically, it looks like the background image has a pre-determined padding applied to it at the top, but all parts and objects are set to padding 0.
Has anyone else experienced this?
Preview mode - letterhead has padding
Printed PDF - the letterhead is up where it should be:
I'm using some script to direct users to different layouts when the access my database via WebDirect. At the moment all users are directed to one of two layouts using the following
#t ( Case ( APP__Application::Type = "Long" ; "Application Detail WEB" ; "Application Detail Rapid WEB" ) )
What I actually need to happen is that when a "reviewer" logs in they are directed to "Application Detail Review WEB" for everyone else the above code is correct.
Any help would be much appreciated.