Jump to content


  • Content count

  • Joined

  • Last visited

  • Days Won


comment last won the day on July 13

comment had the most liked content!

Community Reputation

1,402 Excellent

About comment

  • Rank

Profile Information

  • Gender
    Not Telling

Platform Environment

  • OS Platform
  • OS Version

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. comment

    How to show record number in sub-summary

    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.
  2. How about = MEDIASIZE * If ( PatternCount ( MEDIASIZE ; "GB" ) ; 1024 ; 1 )
  3. comment

    Hide Object based on Field Value and Permission

    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.
  4. comment

    multi files

    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.
  5. comment

    Returning a field from latest record

    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).
  6. 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
  7. 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.
  8. comment

    Relating 2 DB using a range of timestamps

    Do you mean like this? Archive.zip
  9. 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).
  10. 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.
  11. Could you post a copy of your file with only the date field, the buttons and the script?
  12. I mean perform the script in your file that does "Save a Copy as" .
  13. 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.
  14. Actually, there were at least four of them: EventScript, DoScript, zippScript and FMI's own plugin example.
  15. You could use the OS scheduler to open a file that does nothing but call a backup script in your "real" file.

Important Information

By using this site, you agree to our Terms of Use.