Leaderboard

Many developers use a script that runs on opening the file to populate some global variables. You'd probably not want to do this with current date or time, but it is convenient for values stored as preferences that need to be accessible from any context.

If Month (studentDOB) returns an error, then my guess would be that studentDOB does not contain a valid date. What is a valid date is determined by the date format being used by the file: this could be either the format of the current system or the format of the system that first opened the file, as selected in File Options.

All 24U plug-ins are now code-signed for better security Prague, CZ — January 31, 2019 — 24U Software has released a new updates of all currently available 24U’s plug-ins for the FileMaker platform. The just released new versions of the following plug-ins are now code-signed for macOS, Windows, and iOS: - Gonector - 24U SimpleDialog Plug-In - 24U SimpleFile Plug-In - 24U Phone Companion Plug-In - 24U Phidgets Plug-In - 24U Simple Talk Plug-In - 24U Toolbox Plug-In - 24U SimpleSound Plug-In - 24U SimpleHASP Plug-In About code-signing Code-signing is a security feature that allows user to verify the identity of the plug-in’s publisher and that the plug-in has not been modified by maliciuous software such as virus. This is not only safer for everyone but also makes it easier to deploy solutions using 24U’s plug-ins in environments with strict security rules, where only code-signed software is allowerd to be installed. Code-signing is becoming one of security measuers required, by default, by the latest version of the macOS and Windows operating systems, so this update is recommended to all users in order to maintain better compatibility with future versions of the operating system and the FileMaker platform. About Gonector Gonector is a FileMaker plug-in that allows a native application for iPhone or iPad to communicate directly with mobile hardware devices. Being able to interact with professional mobile devices enables you to use the FileMaker platform to create a POS, Inventory and lots of other heavy-duty mobile business apps with friendly, fast, and reliable user interface. About 24U SimpleDialog Plug-In Display professionally looking custom input dialogs and progress dialogs. New version added Pause and Cancel buttons to progress dialogs and input dialogs for iOS. About 24U SimpleFile 24U SimpleFile Plug-In lets user FileMaker solutions easily access files stored anywhere on your hard drive, server, or network, allowing your users to keep their files and documents organized without ever leaving your solution’s user interface. About 24U Phone Companion Plug-In Robust telephony integration for FileMaker Pro. New version adds support for VOIP systems by directly controlling SNOM telephones. Make calls by clicking a button you avoid calling wrong numbers About 24U Phidgets Plug-In Control hardware devices and read environmental sensors, read & write low-frequency RFID tags. New version added support for VINT, stepper motor and more. About 24U Simple Talk Plug-In Custom internet client and server inside FileMaker Pro. Recently released new version added 64-bit support. About 24U Toolbox Plug-In Stable and reliable client & server-side plug-in providing a set of handy functions for your daily use, such as Execute SQL, running system scripts etc. New version adds support for iOS and FileMaker Cloud, and GetAsHTML. About 24U SimpleSound Plug-In Audio playback and MP3 ID3 metadata management. Latest version no longer depends on QuickTime and ID3 tags manipulation now works server-side. About 24U SimpleHASP Plug-In Secure hardware-aided protection of your data and intellectual property, using copy-protected USB dongles. New version is compatible with latest version of FileMaker and latest version of the Sentinel dongles. Availability of 24U Plug-ins All the updated 24U Plug-Ins are immediately available for download free of charge as fully functional 14-days trial versions, which can be activated after purchasing a license. More information: https://www.24usoftware.com About 24U Software With a team of full-time testers, web, plug-in, Mac, Windows, Linux, iOS, and Android native app developers, and FileMaker certified developers, led by the FileMaker DevCon 2015 Developer Cup champion, 24U excels in taking care of existing FileMaker solutions, optimizing their performance, identifying and resolving potential issues and liabilities, improving reliability, stability and scalability, integrating them with other systems including various hardware devices, and extending them beyond expectation. As a platinum member of the FileMaker Business Alliance, we help global businesses around the world to maintain sustainable growth by working with their in-house developers or completely taking care of the maintenance and development of their business solutions. Customer contact: HOnza Koudelka Software Division Manager, 24U s.r.o. sales@24usoftware.com http://www.24usoftware.com Press Contact: pr@24uSoftware.com ### (c)2019 24U s.r.o. All rights reserved. 24U, 24U Software, and FM Bench are trademarks of 24U s.r.o. FileMaker is a trademark of FileMaker, Inc., registered in the U.S. and other countries. All other trademarks are the property of their respective owners. Pricing and availability are subject to change without notice.

Aren't we all.

This is merely a screen refresh problem, and it would be best to address it as such: attach a script trigger to gReportDate, and have it do Refresh Window [Flush cached join result]. Otherwise Filemaker will be trying to minimize the CPU cycles (and network traffic, if the file is served). BTW, while this is an interesting problem, I doubt there's a human that can learn anything useful from looking at so much data at one - even with 1/10th of the records .

Hello all Here we've posted an example FileMaker 13/12 calendar. You can download it for free and use it in your own code. Go here to read blog post. Have fun! The igeeks

Most likely you're using a reference to the picture, as opposed to a copy in FileMaker.

Does this answer your question:

When you say you cannot insert a PDF in Record 2 - what exactly does that mean? Is the menu option greyed out, or is it enabled and you just don't see a result of the action?

I think all practical methods have already been mentioned in this thread: 1. Filemaker's native way: Date ( Month ( startDate ) + n ; Day ( startDate ) ; Year ( startDate ) ) 2. Filemaker's native way with a limit: Let ( [ newDate = Date ( Month ( startDate ) + n ; Day ( startDate ) ; Year ( startDate ) ) ; limit = Date ( Month ( startDate ) + n + 1 ; 0 ; Year ( startDate ) ) ] ; Min ( newDate ; limit ) ) 3. Just add 30 days for each month: startDate + n * 30 Alternatively, use the average number of days in a calendar month (30.436875). None of these methods is more correct or strict than any of the others. Each one produces "illogical" results in some circumstances. Of course, the results are only illogical when judged from within a logic other than the one applied in the calculation - but they still look weird to the average human mind. See also: http://www.fmforums.com/forum/showpost.php?post/263667/