looks like I do have a sort of rookie problem here.
I created a subsummary report which is sorted by a break field and all works fine. All is fine in layout and preview mode. Just in browse mode I seem to have a problem. There is a large grey empty area just underneath of the subsummary part showing. Anyone with an idea what it is I messed up here? I already googled but just found 1 similar report from 2010. Sort of optically annoying.
Any help is highly appreciated.
I am working with filemaker on and off for the last recent years but, no doubts about it, I am still a rookie.
lately I have created a db similar to a booking engine for shore excursions for river cruise ships. Lots of modules, layouts, scripts etc. As I really have to work with my limited knowledge, it took a long time and is not really constructed in a way any pro would do it with a lot of workarounds and probably sort of unorthodox. However, it works just fine for me and I am sort of proud, to have gotten to the point where I am. However, I am afraid, that I corrupted the whole thing somehow.
No I am trying to integrate a sort of an accounting layout consisting out of a summary or subsummary report. The report contains fields from 4 related tables. and a summary field. The db has some 5 different tables and around 35 different active layouts. First problem is that my subsummary part, which I created with the New Layout/Report assistant, does not show up at all in browse mode. I have tried to base the layout on all 4 tables, but it seems not to be working.
The second problem is that the summary field is not working and producing some random weired numbers instead of the summary of the field it is assigned to. On the attached pics I have placed the summary field into the bottom in order to demonstrate the results. In every ordinary case it is located in the subsummary part. I have played around here a lot. deleted it, created a new field, created a new layout etc, etc, but it just won't calculate the value of the field it is assinged to.
Anyone any idea, of what am I doing wrong here? Tnx for any help in advance.
By Jhon Doe
Hi, I hope you having a wonderful day,
Currently I'm traying to create a dashboard with Filemaker, the idea is show several portals and grafics of differnets databases but with specific criterias. The case that i'm trying to resolve is the next one:
There are three database related, one is for clients, another is the contract of this clients (services) and the last one is client's tickets, so we have the next relationships:
tickets DB ------ Clients ------ Services
(I didn't create that DB distribution). The idea is show in the dashboard which tickets were created for clients who have certain services. The first thing i did was create a self join relationship of Services to filter those clients who have the services i want to filter, next, i put this relationship into a portal in a layout based on the Services database and it works, but if i put into the portal a field related with the client's name, the portal doesn't match the results of the self join relationship whit the correct client, neither with the tickets that it supposed are related with the results of the self join relationships, how can I created a query in Filemaker taking into account more that one database? I made the self-join in the manage/database/relationships menu.
Updated file management plug-in is compatible with FileMaker 18 and sets movie metadata.
Alphen aan den Rijn, the Netherlands, May 22, 2019–Troi today announced the immediate availability of Troi File Plug-in 11.0 for FileMaker 18.
What is Troi File Plug-in?
Troi File Plug-in is a very powerful tool for getting access to information outside the FileMaker database. Any files or folders stored on the computer can be accessed through the functions of the plug-in. All from within FileMaker you can:
get data from files that are on the disk of the computer into FileMaker create files anywhere on the hard disk and put data from FileMaker fields into them manipulate files and folders on the disk: this includes creating, deleting, copying, moving and modifying files and folders get the size on disk, creation and modification dates and much more launch and reveal files directly from FileMaker manage your images and movies, including reading and writing metadata What is new in version 11.0?
Troi File Plug-in 11.0 has the following new functionality:
Tested and made compatible with FileMaker Pro 18 and FileMaker Pro 17.0.6. Added new TrFile_ExportToFile function, which can save container data to disk. This function can also be used on FileMaker Server. Added a new TrFile_IsFree function, which can be used to determine if a file is in use by a different application (or locked). (macOS) Added a new Set MetaData of Movie script step and TrFile_SetMovieMetaData function, which can add metadata to movie files (like .mov and .mp4). It can add and change metadata like title, GPS and creation data. (macOS) Improved TrFile_CreateThumbnail function and the Create Thumbnail script step: you can now create thumbnails of movie files (like mov, mp4 etc). The plug-in creates a thumbnail of the first frame of the movie. (macOS) Prepared the plug-in for notarization: the plug-in can now be added to a runtime, to create a hardened FileMaker runtime app which can be notarized by Apple. Notarization gives users more confidence, as the runtime has been checked by Apple for malicious components. (Windows) Improved the TrFile_ExecuteShell function and the Execute Shell script step. If you use the switch “-Encoding=UTF8” the plug-in now indicates invalid UTF-8 characters with the string <INVALID UTF8>.Also Improved the ExecuteShell.fmp12 example file, you can now specify the encoding of the result of the command. In Troi File Plug-in 11.0 we also made the following changes and improvements:
IMPORTANT (macOS only) The minimum supported FileMaker version is now FileMaker Pro 14. Also the minimum supported Mac OS version is now OS X 10.10 (Yosemite). You can keep using v10.2 for older versions of FileMaker Pro or Mac OS X. (macOS) The plug-in no longer has the 32-bit code included. Improved the initialization when installing the plug-in with the FileMaker Pro “Install Plug-In File” script step. Updated the EasyInstallTroiPlugins.fmp12 file, it can show additional error information from Get(LastExternalErrorDetail) when running on FileMaker Pro 18. The EasyInstallTroiPlugins.fmp12 file can also run a test registration script for a plug-in after you have installed it on FileMaker Server. Updated the example files for FileMaker Pro Advanced 18 and made small corrections to the user guide. Fixed bugs in several functions. More detailed information on all changes and improvements implemented in Troi File Plug-in 11.0 can be found on the File Plug-in page.
Pricing & Availability
A fully functional demo version of Troi File Plug-in 11.0 is available on the File Plug-in page.
Licenses cost US$ 99 per user. Details on developer licenses and multi-user discounts can be found on the File Plug-in page. You can order licenses there or from our shop.
Version 11.0 needs a new registration. The upgrade is free for users who bought a license for Troi File Plug-in on or after May 15, 2018. Eligible users will be sent a new registration. Contact us if you have not received yours after May 29, 2019.
Upgrades from licenses bought before May 15, 2018, are available from US$ 59 per user. Upgrade prices for other licenses can be found on the File Plug-in web page or in the shop. You can order upgrades there.