comment

Use a summary field defined as Count of [any field that cannot be empty], Running count, Restart summary for each sorted group. That would create a conflict when two users want to produce different reports.

How about = MEDIASIZE * If ( PatternCount ( MEDIASIZE ; "GB" ) ; 1024 ; 1 )

I agree. There is a big red flag waving over this question. If this is an attempt to deny some users access to some records, then it's bad practice and wholly unsafe.

This is also why you should have a good reason to separate a solution into individual files. If you don't, consolidating it into a single file with multiple tables would seem to be the simplest solution.

Have a look at the Last() function. Note that the order of related records can be changed by sorting the relationship. If you sort the related records by date, descending, the latest record will become the first related record and its fields can be referenced simply by their names (or displayed directly on the layout of the parent table).

Because of FMP 16 enhanced security. See the first one of "Tips on usage" here: http://www.filemaker.com/help/16/fmp/en/index.html#page/FMP_Help/perform-applescript-os-x.html

If I understand your question correctly, you need to import your records (to a new table) multiple times, each time importing the title and one of unique combinations of size, color and short.

Do you mean like this? Archive.zip

Okay, I have managed to reproduce the problem. It's a bug. 1. How to work around the bug: Use Insert Calculated Result[] instead of Set Field[]. 2. How to avoid the bug: Save a copy of your file as clone (no records) and import the records into the clone. The new file's date format will be YYYY-MM-DD and your script will work. 3. How to avoid the bug and follow the best practice of not having your script depend on any date format: Make your script do: Enter Find Mode [] Set Field [ Calendar::calDate; Date ( Get (ScriptParameter) ; 1 ; Year ( Get (CurrentDate) ) ) & ".." & Date ( Get (ScriptParameter) + 1 ; 0 ; Year ( Get (CurrentDate) ) ) ] Perform Find [] where script parameter is a number between 1 and 12 (there's really no good reason to send the month name as text, then spend 12 lines of code converting it to a number).

First thing, your file's date format is MM/DD/YYYY. It is set to always use the current system's setting. Are you sure your OS short date format is YYYY-MM-DD? Because if it isn't, that would explain the described behavior.

Could you post a copy of your file with only the date field, the buttons and the script?

I mean perform the script in your file that does "Save a Copy as" .

You're not showing us how the $_range variable is being defined, so there's very little we can say. We also need to know what date format your file is using.

Actually, there were at least four of them: EventScript, DoScript, zippScript and FMI's own plugin example.

You could use the OS scheduler to open a file that does nothing but call a backup script in your "real" file.